Directory Listing in SSMS
Get a complete directory listing of the contents of folders and subfolders with the below script. This is useful if you don’t have direct access to the server operating system where SQL Server is installed,…
Search SSRS Reports for Keywords
Microsoft’s SQL Server Reporting Services, colloquially known as SSRS, provides a great way to expose data from SQL Server in human-consumable form, typically via a web site. Generally, it’s a good idea to use a…
Parse DTSX Package Connection Manager Properties
The following query returns connection manager properties from the SSIS .dtsx packages stored in a particular file system folder. The code relies upon the undocumented and unsupported sys.xp_dirtree extended stored procedure that ships with all…
On Nomenclature, and Execution Plan Plus
Nomenclature, or the science of using words to name things using a logical system, is important since accurate names portray with clarity what the thing does. Recently, there’s been a suggestion, posited by Erin Stellato…
Identifying the Physical Location of a Row
Occasionally I’ve needed to determine the physical location of a row stored in SQL Server. The code in this post uses the undocumented feature, %%PHYSLOC%%, which returns a binary representation in hexadecimal of the location…
Auditing DDL Events
SQL Server doesn’t audit DDL events out of the box, aside from several major events which are captured in the Default System Trace. By “audit”, I mean there is no log of the data-definition-language statements…