Service Packs coming for SQL Server 2008/2008 R2
I’m not prophetic, I promise. However, some good news on the service pack front with regards to SQL Server 2008...
2014-06-02 (first published: 2014-05-30)
3,057 reads
Databases – Infrastructure – Security
Do you apply SQL Server Cumulative Updates?
I think Steve Jones makes a great point here with respect to cumulative updates:
“This is one reason I’ve been hesitant...
2014-05-30 (first published: 2014-05-28)
6,877 reads
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,743 reads
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
698 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,368 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,379 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
641 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,347 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
956 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers