AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-07
7 reads
Blog Posts
Blocking and deadlocking on purpose
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,602 reads
Pros and Cons of Switching to Database Managed Services
What are exactly Database Managed Services?
The term is widely used and covers so many things simultaneously, so it is hard...
2015-07-07
1,051 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-07
34 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-07
40 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official support to Windows. While this is great news it...
2015-07-07
20 reads
SQL Server Infernals – Circle 4: Anarchic Designers
Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...
2015-07-07
835 reads
TSQL Tuesday #68 – backup checksum default
Tweet
G’Day,
Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my...
2015-07-07
1,395 reads
10 Best Advices to Choose an SQL Consulting Firm
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
724 reads
Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get...
2015-07-06 (first published: 2015-07-01)
2,086 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers