2013-11-25 (first published: 2013-11-15)
2,207 reads
Scripts
Split and concatenate function
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
3,113 reads
Powershell script to interactively move cluster resources
Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.
2013-11-19 (first published: 2013-11-04)
2,401 reads
Search Table And Field In All Database And Return Field Value
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
167 reads
Generate row constructors for existing data
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,202 reads
SQL Data File Information
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,547 reads
Right or Wrong, Dynamic SQL AND a Cursor
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,848 reads
Convert int to Excel column name
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
2,075 reads
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-05 (first published: 2013-10-24)
3,169 reads
An easy way to track the growth of your database
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,395 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries