SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes. I decided I really...
2011-11-23
7 reads
Blog Posts
SQL Server Magazine's Top 10 Blogger....#3
So, it seems that I have been selected by the 2011 SQL Server Community Choice Awards, as among the Top 10...
2011-11-23
1,384 reads
The Mute the Phone Office Prank
The client I work with as a lot of conference rooms, all with the standard Polycom conference phone that works...
2011-11-23
671 reads
DBA in Space: Behind the Scenes—Question 4
This is a continuation of my DBA in Space journal.
With each episode, DBA in Space becomes goofier and goofier. Episode...
2011-11-22
545 reads
Download SQL Server 2008 SP3 CU2
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL...
2011-11-22
967 reads
Monitoring a Rollback and sys.dm_exec_requests
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity...
2011-11-22
1,493 reads
Optimizing Backup Performance
If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are...
2011-11-22
1,874 reads
Review: Gamma Seal Lids
Last weekend I needed to go to Home Depot to get a five gallon bucket and a lid so we...
2011-11-22
711 reads
SQL Server 2008 Service Pack 2 Cumulative Update 7 Released
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes...
2011-11-22
1,832 reads
SQL Server 2008 Service Pack 3 Cumulative Update 2 Released
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3...
2011-11-22
1,795 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers