2010-01-14
3,781 reads
Sudhir Chawla
2010-01-05
4,419 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,245 reads
Extract Objects of a Linked Server
In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,
we need to write following query:
2009-08-07 (first published: 2009-07-20)
699 reads
2008-12-23 (first published: 2008-11-10)
2,924 reads
2008-11-27
4,107 reads
2008-11-26
4,941 reads
Get Record count of all tables of current database
This script will return record count of all user tables from the current database
2008-11-05
1,067 reads
Blogs
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
Forums
Script-Drop Orphan users from SQL Server Database
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
The Hidden Cost of Ignoring Software Bugs
Every expert knows you can't make perfect software that never crashes or has bugs....
Building Flame Diagram for MSSQL stored procedures
I wanted to share with you tools from my personal toolbox. If your code...
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers