Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
410 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,269 reads
Securing Log Shipping
There was a post recently where someone was asking about securing log shipping to comply with HIPAA requirements. It struck...
2009-12-17
1,232 reads
Using Google Docs for Note Taking
I've admittedly been a terrible note taker growing up. Throughout most of school, I've always been able to remember everything...
2009-12-17
2,129 reads
Machine SID Doesn’t Matter
Ran across this post from Mark Russinovich titled The Machine SID Duplication Myth that seems to debunk the idea that...
2009-12-16
785 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,471 reads
Updated SQL Server 2008 Diagnostic Queries
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
989 reads
Netbook – Finding a GB
I turned on my netbook for the first time in a few weeks recently. My laptop had died, and I...
2009-12-16
731 reads
SQL Saturdays and other events in 2010
It seems that the SQL community is really growing. There are now quite a few events that you can attend...
2009-12-16
995 reads
Someone Needs an Order BY
I was checking on the status of my laptop the other day. It died and I shipped it back to...
2009-12-16
963 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