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)
2,303 reads
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
1,650 reads
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
1,019 reads
2019-04-30
1,884 reads
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)
757 reads
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
4,176 reads
2019-04-16 (first published: 2019-04-12)
11,771 reads
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
566 reads
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
3,405 reads
2019-02-27 (first published: 2019-02-20)
986 reads
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Wa:082374977784 Jl. Laksamana Yos Sudarso No.128/4F, 3 Ilir, Kec. Ilir Tim. II, Kota Palembang,...
Wa:083849450961 Jl. Letkol Iskandar No.51-52, 24 Ilir, Kec. Bukit Kecil, Kota Palembang, Sumatera Selatan...
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers