String Replace in Stored Procedures with Powershell
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,239 reads
Scripts
Disk Space Check
I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.
2018-11-09 (first published: 2018-10-24)
1,161 reads
The Pesky Windows Power Plan Oh My
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
580 reads
2018-11-05 (first published: 2018-10-22)
878 reads
sp_what
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
3,004 reads
2018-10-29 (first published: 2018-10-19)
1,437 reads
Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
1,004 reads
2018-10-24 (first published: 2018-10-15)
911 reads
2018-10-12 (first published: 2018-10-04)
1,170 reads
How to Identify backup tables within production databases
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
574 reads
Blogs
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers