Passively detect attempts to guess passwords
Review the error log for possible brute force or dictionary attacks on your SQL Server instance.
2015-05-08 (first published: 2013-05-22)
2,674 reads
Scripts
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,608 reads
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,005 reads
2015-05-06
370 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)
6,621 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,703 reads
2015-05-01 (first published: 2013-08-13)
3,772 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)
710 reads
2015-04-24 (first published: 2015-04-15)
1,191 reads
2015-04-24 (first published: 2008-07-24)
2,683 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Computer Algebra
Comments posted to this topic are about the item Computer Algebra
Renaming a Database
Comments posted to this topic are about the item Renaming a Database
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers