2016-11-29
1,147 reads
Ren
Index rename to standards
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,059 reads
Duplicate Records using SQLCMD
We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.
2009-04-06
9,816 reads
How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
9,318 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
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...
Connect tabular model to excel via Power BI semantic model
I have a tabular cube, with myself included in one of the roles. I...
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