SQL Server Worker Thread Alert
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
455 reads
Scripts
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
494 reads
2019-04-30
754 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
512 reads
SQL Server System Audit Report
SQL Server System Audit Report Rudy Panigas, 2018-05-25 (first published: 2016-02-02) With every technology, security is in the forefront of the minds of professionals around the world. Ensuring that your SQL Server is secure is the job of every Database Administrator (DBA). The DBA(s) needs to configure the system to minimize the “attack surface” (reducing […]
2019-04-18
321 reads
2019-04-16 (first published: 2019-04-12)
1,349 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
264 reads
DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
1,226 reads
2019-02-27 (first published: 2019-02-20)
242 reads
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
537 reads
Blogs
Learning Containers
I find that I’m using containers more and more to get things done with...
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series...
Inspector V1.4 now available
The SQL Installation script can be found here The Inspector sample report has been...
Forums
Lock Request Timeout period Exceeded Error 1222
A long running job is doing a SELECT INTO a table, so the table...
Primary Keys
What is a good way to determine which combinations of fields should make up...
Net Earned in Triangles without a Triangular Join?
Something I've been trying to figure today is can I achieve a figure for...
Ask SSC