Bradley Ball at MagicPASS on January 15, 2014
First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks. Let them know you’ll be...
2014-01-13
669 reads
Blog Posts
Do you clean up after yourself?
TweetG’day folks,
I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that...
2014-01-13
1,268 reads
Last Weeks Top “Reading” Links #66
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-13
1,072 reads
Microsoft Project Migration Template for the move to SQL 2012
For those planning a move to SQL Server 2012, although this process can apply for many Database Migrations, perhaps this Microsoft...
2014-01-13
10,810 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,692 reads
Protesting government web surveillance: Feb 11 Blackout
We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the...
2014-01-13
454 reads
SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
144 reads
SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
1,455 reads
SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
266 reads
SQL Server 2012 and Virtual Service Accounts
This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the...
2014-01-13
22,834 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers