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
613 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
664 reads
2019-04-30
975 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)
562 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
505 reads
2019-04-16 (first published: 2019-04-12)
1,542 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)
303 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,254 reads
2019-02-27 (first published: 2019-02-20)
283 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)
648 reads
Blogs
Last Week Reading (2019-06-16)
By Kamil
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...
Back with new focus
Back with a new focus First let me say wow can’t believe that it...
A Double Day
By Steve Jones
I’m traveling back from Australia today. A few weeks ago I lost a day...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Migration from server to server
I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...
Temporary data and Differential Backup size
Comments posted to this topic are about the item Temporary data and Differential Backup...
Ask SSC