Minimize permissions for file locations
When we talk about security, we often point to the Point of Least Privilege. I write a lot about applying...
2014-05-23 (first published: 2014-05-16)
1,738 reads
Databases – Infrastructure – Security
The Scary DBA Comes to Columbia, SC
*sound of glass crashing* *cue theme music*
(in a wrestling announcer’s shocked voice) “It can’t be! He’s not supposed to be...
2014-05-09
691 reads
Understanding the Three A’s of Security for SQL Server
Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look...
2014-05-01 (first published: 2014-04-22)
7,356 reads
Encrypt usernames and passwords stored in files
I was looking at a product recently and came across a rather unpleasant surprise: the install instructions specified that I...
2014-04-02
3,336 reads
Speaking at Midlands PASS Chapter tonight
The Midlands PASS Chapter is an official PASS (Professional Association for SQL Server) chapter located in Columbia, SC. It’s free...
2014-03-13
461 reads
A summary of the SQL Server security #datachat is live
Recently I posted about participating in a #datachat about SQL Server security. As it turned out, we didn’t talk about...
2014-03-12
640 reads
Auditing VMware vCenter Actions (on SQL Server)
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....
2014-03-07
1,344 reads
The weakest link in database security
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is...
2014-03-06
947 reads
Security #Datachat on Twitter Tonight
Tonight, at 9 PM Eastern, I’ll be participating in a #datachat on SQL Server security. It’s sponsored by Confio (now...
2014-02-27
985 reads
Presenting on Top SQL Server Vulnerabilities
On February 19th, 2014, I’ll be giving a webinar from 3-4 PM Eastern on the Top SQL Server Vulnerabilities. You...
2014-02-18 (first published: 2014-02-12)
1,951 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers