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)
989 reads
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
989 reads
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,347 reads
2013-06-06 (first published: 2009-03-16)
2,614 reads
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,335 reads
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,830 reads
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-09 (first published: 2010-05-04)
1,842 reads
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-02 (first published: 2008-12-09)
2,459 reads
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,091 reads
2008-11-06 (first published: 2008-09-12)
969 reads
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
653 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers