Comparing Two Recordsets Using Powershell
How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.
2012-07-13
3,862 reads
Tom Powell
INFORMATION_SCHEMA.101
Get information about the objects in your database using these ANSI standard, multi-platform views.
2011-10-04
6,422 reads
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
Azure SQL database AAD user management
I have an Azure SQL DB where I have set up the Azure active...
Use a recursive CTE to produce 1 update statement using dynamic SQL
I want to be able to generate 1 merge statement rather than loop through...
Query to Update balance based on columns from two different rows.
Hello All, Below is the my existing table structure from which I am trying...
Ask SSC