SQL Server Locking Overview
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,350 reads
Blog Posts
Ask The Unicorn: SQL Saturday Registration Is Closed
Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led...
2012-10-20
772 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
638 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
747 reads
fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,258 reads
Lost in Translation – Deprecated System Tables – sysforeignkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-19 (first published: 2012-10-16)
1,771 reads
MDX #19 – There is more to do to concatenate row values into column
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,456 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
520 reads
SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,713 reads
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
933 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers