2016-11-29
1,134 reads
Renato Buda
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)
992 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,355 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
7,621 reads
Blogs
Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set...
Good to see you at Houston Tech Fest 2019!
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Trying to create Nested SUM OVER Function for backwards running total.
Here is sample code from my running total, now I need to reverse it...
Copy or Move Shapshot Reports
Hi We have snapshots on an old report that we would like to move...
Ask SSC