DevOps Basics – Ignoring Files in Git
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,519 reads
Blog Posts
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,071 reads
Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
675 reads
If You’re Stuck at Home for the PASS Summit
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
682 reads
Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
582 reads
Networking, and other things to do while at PASS Summit
If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense...
2017-10-30
334 reads
Quick Model Database Tidbit
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
745 reads
Redgate at Summit 2017
I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of...
2017-10-30 (first published: 2017-10-24)
1,193 reads
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
397 reads
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
49 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers