Find the position of all occurrences of an expression within a string
This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.
2015-05-12 (first published: 2013-03-24)
2,242 reads
Scripts
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,695 reads
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,658 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,025 reads
2015-05-06
405 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,940 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,730 reads
2015-05-01 (first published: 2013-08-13)
3,785 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)
794 reads
2015-04-24 (first published: 2015-04-15)
1,203 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers