2019-07-09 (first published: 2019-05-01)
491 reads
Scripts
Find Estimate Time of recovery for database after Reboot
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
415 reads
Generate views to correct the column collation on a target DB's tables automatically
You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]
2019-07-05 (first published: 2019-06-26)
361 reads
Audit Users logging in using "sa" or service accounts
Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]
2019-07-04 (first published: 2019-06-26)
649 reads
Script DB Level Permissions v4.5
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
646 reads
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
750 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-05-01
762 reads
2019-04-30
1,235 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)
601 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
709 reads
Blogs
#DPS10 – preconfs
By damianwidera
I have delivered a preconf on the biggest conference in Asia. The preconf was...
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
Forums
Sql 2014 sp3 - extra stats created
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC