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
628 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
672 reads
2019-04-30
998 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)
564 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
519 reads
2019-04-16 (first published: 2019-04-12)
1,562 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)
309 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,255 reads
2019-02-27 (first published: 2019-02-20)
285 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)
657 reads
Blogs
Cool Stuff in Snowflake – Part 9: ILIKE
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Globally Distributed Azure Cosmos DB
By Arun Sirpal
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Upgrade SQL Server 2012 R2 cluster to 2016 by adding 2016 node
We have a SQL Server 2012 R2 failover two-node cluster that we'd like to...
Power Shell script to add a user to sysadmin server role on many SQL instances
Can someone please copy/paste or provide me the script for this? The list of...
Ask SSC