2016-03-10
1,387 reads
Wayne West
2009-10-30
67 reads
Get record count for every table in a database
I wrote this code to make it easier to compare record counts between a live database and a restored copy to test my backups, I thought people might find it useful. You need to run it against your live side when you do the backup that you're going to restore and compare against.Copy the output […]
2007-05-24 (first published: 2007-05-07)
2,719 reads
Blogs
Daily Coping 30 Mar 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Error handling protip: @@Error resets after the next command
The system variable @@ERROR is a quick and easy way to retrieve the error...
Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions
Introduction Recently have been working on a “Proof of Concept” task where I wanted...
Forums
The Coping Thread
I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...
Get the difference from one record to the one previous
In it's simplest form I want a table that I can use to store...
Regarding for Microsoft Azure Certification
Hello Everyone, I am new here and I am preparing for microsoft azure certification...
Ask SSC