What is an “operational” DBA?
On Facebook last night, I posted the following:
An operational DBA isn’t just a manager of a traditional RDBMS, transactional system....
2014-06-27
5,287 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
“A good DBA is a lazy DBA”
I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...
2014-06-25
1,958 reads
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,058 reads
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,391 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
462 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
642 reads
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
Alamat Kantor BCA KCU DAGO WA(082144477715)
WA:0821-4447-7715 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
ALAMAT BCA KCU PALANGKARAYA TLP/WA 08218154374
Hub Cs:08218154374 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan...
ALAMAT BCA KCU SAMARINDA TLP/WA 08218154374
Hub Cs:08218154374 Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan...
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers