SQL Server – Changing Default Database Location for Server
When you create a new database in SQL Server without explicitly specifying database file locations, SQL Server created files in...
2013-03-18
2,215 reads
Blog Posts
SSIS 2012 Deadlock When Running SSIS from SQL Agent Job
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
5,085 reads
Star Trek and the Death of IT
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,144 reads
T-SQL Tuesday #40 Roundup: Files and Filegroups
Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect...
2013-03-18
851 reads
Using Templates
Templates are one of those really handy tools that most DBAs I know of have either never heard of or...
2013-03-18
1,168 reads
PASS Data Arch VC presents Steve Hughes on Accounting for Windows Azure
I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services...
2013-03-17
641 reads
PowerShell Usage in DBA Work — Case Study 4/7
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs...
2013-03-17
941 reads
SQL Server : Part 5 : Explaining Non clustered Index on Heap
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,826 reads
Database Health and Performance at SQLSaturday Detroit
Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my...
2013-03-16
620 reads
Scaling SQL Server 2012 in Lisbon, Portugal
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
735 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers