A Cool Job
Today's editorial was originally published on August 21, 2007. It is being re-run as Steve is traveling. What a cool job it must be to try and tune and get the most performance out of a system.
2012-07-16
159 reads
Editorials
Write Better Code
Better security can be achieved by writing better code. Steve Jones agrees, but doesn't think it's as easy as it sounds.
2012-07-16
262 reads
Kill a SPID
This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. Today Steve talks about the potential problems with killing SPIDs in SQL Server.
2012-07-13
311 reads
One Single View
This editorial was originally published on Oct 9, 2007. It is being re-run as Steve is traveling. When I worked at JD Edwards, one of the goals of our business intelligence system was to house a single view of the truth. I recently saw a blog post by Andrew Fryer that does a good job of explaining what this actually is.
2012-07-12 (first published: 2007-10-09)
538 reads
Why It's Good To Be Wrong
Today we have a guest editorial from Hakim Ali. Being wrong is not as bad as you may think.
2012-07-11
445 reads
It's the Journey...
The story of how Shawn McGehee's journey to becoming a DBA started is just one among many thousands, so let's hear yours too!
2012-07-09
141 reads
Starting to Program
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
2012-07-06
303 reads
Clouds, Costs, and Data Analytics
The cloud can be good or bad for your company, but it can easily be a costly endeavor that doesn't save you money. Steve Jones some data analysis is needed to ensure you have a cost effective cloud infrastructure.
2012-07-05
139 reads
2012-07-04
70 reads
Fix Failures Fast
A new study from Microsoft Research looks at failures in PCs. Steve Jones thinks there are a few things worth talking about for DBAs.
2012-07-03
134 reads
Blogs
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers