Site Reliability Engineering vs. DevOps
What’s the difference between Site Reliability Engineering and DevOps? In this article, Grant Fritchey defines each one and compares them.
2022-04-22
Articles
Basic Git for DBAs: Getting Started with Git
Learn the basics of Git in this article if you've never used this version control system before. We will cover setting up a repo, adding files, changing them, and getting your history.
2022-04-20 (first published: 2020-06-08)
25,660 reads
CASE STUDY: The hybrid monitoring needs of a fast-growing global business
With ambitious expansion plans, PointsBet needed an expansive overview of its server estate, whether on Azure or on-premises, anywhere around the world. Find out how SQL Monitor rose to the challenge.
2022-04-20
How to get length of Text, NText and Image columns in SQL Server
There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
2022-04-20
Incremental Data loading through ADF using Change Tracking
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
16,103 reads
SQL Server Graph Tables – Cross Database Surprises
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
2022-04-18
Webinar | Kick start your DevOps Initiative
Without someone on your team experienced at putting DevOps into practice, it can be difficult to know how to get started. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover his top tips on how to kick start DevOps in your organization.
2022-04-18
Flyway Gotchas
Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are tackling more complex development processes.
2022-04-15
Tips and tricks with DAX table functions in paginated reports
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.
2022-04-15
How to create a table using SQL Server Management Studio
In this article we walk through things you should know to create new tables in SQL Server using the SQL Server Management Studio interface.
2022-04-13
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers