PowerSQL – Identify a Head of the Database Blocks and Generate Automated Alert across all listed SQL Instances
This is going to be a simplest way of capturing and sending some useful information via an email of ‘N’...
2013-05-06
754 reads
Blog Posts
Quick Tip: Navigating to a UNC within SQLPS
I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the...
2013-05-06
764 reads
SQL Server – How to Best Remove Extra TempDB Data Files and Log Files
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
946 reads
SQL Server – How to find Default data and log path for SQL Server 2012
To identify default data and log directories in SQL Server 2012 you can use SERVERPROPERTY() function. In SQL Server 2012...
2013-05-06
921 reads
SQLSaturday Atlanta #220–May 18th
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th...
2013-05-06
555 reads
SSRS 101 – Your First Report
I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL...
2013-05-06
1,391 reads
Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-04
924 reads
May the Fourth Be With You – Kindle Bonus!
It seems that with the Disney purchase of Star Wars this past year that May the Fourth is coming on...
2013-05-04
440 reads
A Replacement for DBCC IND in SQL Server 2012
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some...
2013-05-03 (first published: 2013-04-17)
3,209 reads
Reblog: April 26 to May 2
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-03
1,077 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