Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
794 reads
Ctrl-alt-geek
Quick Tip: Migrating a SQL Server Mirroring Witness server.
If you’re like me, you might be thinking “I want some more things to think about when I migrate between...
2014-03-27
642 reads
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
736 reads
Issue with sys.dm_db_index_usage_stats in SQL Server 2012
I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...
2014-03-10 (first published: 2014-02-27)
3,215 reads
SQL Server configuration files
Problem: You require the ability to perform a repeatable standardised installation of multiple instances of SQL Server or the ability...
2014-02-13
44,296 reads
Conditional Aggregates
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,076 reads
My Favourite SSMS productivity tips
It’s a well known fact that any sitcom that runs for a certain length of time will release a clip...
2014-01-13
1,670 reads
Apply SP1 to SQL Server 2012 on active/active Windows Server 2012 cluster.
A while ago I blogged my about my approach to service packing a SQL Server 2008R2 active active cluster. Time...
2014-01-08
1,576 reads
Quick tip: Could not load package “xxx” because of error 0xC0014062
I struck this error in one of my SSIS packages, I found lots of tips and suggestions online for the...
2014-01-08 (first published: 2014-01-06)
1,995 reads
Duplicate Statistics
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,493 reads
Blogs
Deploying SQL Server to Kubernetes via SQL Server 2025
Following on from my previous post about hitting the Kubernetes API from SQL Server...
Accessing the Kubernetes API from SQL Server 2025
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit...
Empowering Technical Teams: Leading with Vision, Not Micromanagement
By Chris Yates
Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a...
Forums
Script to check which Employee id is using and Blackberry device
Hi I have an SQL script that will check which employee is using an...
Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM Integration
Comments posted to this topic are about the item Model Context Protocol (MCP): A...
How to safely and surgically restore filegroups
Comments posted to this topic are about the item How to safely and surgically...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers