Delete All Database User Accounts for a Given Server Login
Easily and quickly delete all database accounts even if they don't have the same name as server login.
2015-05-05 (first published: 2013-07-18)
7,027 reads
Scripts
Create a Comma Delimited CSV File from Any Table/View with Debugging
Dynamically build a comma delimited CSV file using the BCP utility from any table or view in your database with a useful code debugging parameter.
2015-05-04 (first published: 2013-08-12)
5,745 reads
2015-05-01 (first published: 2013-08-13)
3,788 reads
Function to display integer as binary string
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
815 reads
Function to count set bits in a signed integer
This function counts the number of 1's in the binary representation of an integer.
2015-04-28 (first published: 2014-02-24)
980 reads
Extract default & Named Instance from @@servername
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2015-04-27 (first published: 2015-04-15)
1,163 reads
2015-04-24 (first published: 2015-04-15)
1,207 reads
Check existence of a database
Check Status of a database. It will loop through all databases and will print message if the db is present.
2015-04-21 (first published: 2015-04-10)
1,329 reads
READ Data from default Trace
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2015-04-17 (first published: 2015-04-08)
1,426 reads
Show Database and Log sizes, free space and location
This script helps to identify which database/log takes most of the disk space and how much is free.
2015-04-15 (first published: 2013-06-18)
3,004 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