2016-03-10
1,393 reads
Wayne West
- Interests: Card/board game design, photography
2009-10-30
76 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,742 reads
Blogs
Andreas Wolter on Evading Data Access Auditing
By Brian Kelley
There are always bad actors who will seek to get access to and, likely,...
Adding a Named Default Constraint to a Table: #SQLNewBlogger
By Steve Jones
As part of a demo recently I was adding a default value to a...
Using Python Code in SSIS
By Tim Mitchell
SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and...
Forums
NKTg Law on Varying Inertia – A Different Way to Think About Motion
Hi everyone, I’d like to share something from the science side of life rather...
How to create your custom GPT SQL Expert
Comments posted to this topic are about the item How to create your custom...
Storage Enhancements
Comments posted to this topic are about the item Storage Enhancements
Question of the Day
Getting Azure SQL Database Permissions
When I run this on Azure SQL Database, what is returned?
SELECT * FROM sys.fn_builtin_permissions('Server') AS fbp See possible answers