Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
715 reads
Yet another way to defrag indexes
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,296 reads
2013-06-06 (first published: 2009-03-16)
2,585 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.
2013-05-15 (first published: 2008-09-24)
3,313 reads
My favorite way to access Excel files
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,544 reads
A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-08 (first published: 2010-05-04)
1,830 reads
Deleting old files (with/without archive bit)
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-01 (first published: 2008-12-09)
1,971 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,079 reads
2008-11-06 (first published: 2008-09-12)
926 reads
Getting schemas for your tables
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
645 reads
Blogs
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
7th Anniversary
7 years ago today I posted my very first blog post and I’ll tell...
Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR
By Jen McCown
Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...
Forums
Data Migration Assistant errors - dacpac and openquery failures
Hi all, I am attempting to use DMA to assess an upgrade from 2008...
Scalable SSIS Package - Single SSIS package across 50 different projects
Hi All, I have a successfully running SSIS package which has been created for...
Replication Error - TCP Provider: The semaphore timeout period has expired.
Experts, We are facing an issue with one of the replication subscriber. There were...
Ask SSC