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
316 reads
Editorials
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)
541 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
453 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
144 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
308 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
146 reads
2012-07-04
78 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
141 reads
Security and Honesty
Today Steve Jones talks security and the need for us to share information about issues, especially those that impact security.
2012-07-02
140 reads
2012-07-02
330 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers