Security Queries: Server-level
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
2,708 reads
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
2,708 reads
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,352 reads
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,200 reads
This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.
2013-10-30 (first published: 2013-10-15)
1,073 reads
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,644 reads
2013-10-22 (first published: 2007-10-10)
30,168 reads
I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.
2013-10-18 (first published: 2013-10-01)
1,866 reads
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,206 reads
This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.
2013-10-15 (first published: 2013-09-23)
1,688 reads
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,193 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