Check SQL Error Logs using Powershell
Dynamically check your SQL Error Logs and filter using Powershell.
2015-05-07 (first published: 2013-06-04)
4,671 reads
Scripts
Capture current queries when cpu is above certain threshold
If you get alerts for high CPU, but by the time you login/check the server cpu is back to normal, then use this sp to create a sql agent job and run it every min.
2015-05-06 (first published: 2013-06-04)
3,033 reads
2015-05-06
417 reads
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,042 reads
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,749 reads
2015-05-01 (first published: 2013-08-13)
3,791 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)
818 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)
985 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,165 reads
2015-04-24 (first published: 2015-04-15)
1,211 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers