2013-12-02 (first published: 2013-11-18)
1,691 reads
2013-12-02 (first published: 2013-11-18)
1,691 reads
Creates Mirror State-Change Alerts for ALL mirrored databases on a server - can save hours when setting up multiple mirrored instances
2013-11-29 (first published: 2010-11-23)
3,791 reads
2013-11-25 (first published: 2013-11-15)
2,013 reads
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
2,410 reads
Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.
2013-11-19 (first published: 2013-11-04)
1,311 reads
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
32 reads
Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard
2013-11-14 (first published: 2013-10-31)
1,165 reads
This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName
2013-11-11 (first published: 2013-10-29)
1,503 reads
I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.
2013-11-08 (first published: 2013-10-29)
1,835 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,704 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers