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
484 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
527 reads
2019-04-30
794 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)
516 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
357 reads
2019-04-16 (first published: 2019-04-12)
1,388 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)
271 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,236 reads
2019-02-27 (first published: 2019-02-20)
251 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)
558 reads
Blogs
The SQL Change Automation in SSMS Beta
By Steve Jones
Give it a try, as the beta is out. I’ve been watching this product...
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to...
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
retrieve all .rdl files from report server
Is there a folder on the report server that houses all of the .rdl...
Idera SQL Compliance Manager, not showing events??
Trying to test this out for work, to see if it might work for...
Ask SSC