Moving On To New Challenges
After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...
2011-06-13
844 reads
Blog Posts
Non use of persisted data
Working at a client site, that in itself is good to say, I ran into a set of circumstances that...
2011-06-13
627 reads
PASS Update #56-SQLRally 2012 Site Selection
Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...
2011-06-13
990 reads
Speaking at SALSSA June 15th 2011:Understanding Storage Systems and SQL Server
I am very exicted to be speaking at the San Antonio PASS chapter SALSSA! It’s been way to long and...
2011-06-13
590 reads
SQL Server Instant File Initialization (PQW)
Bluntly put, this is something that you always want to be taking advantage of.
As a Database Administrator I’m always on...
2011-06-13
659 reads
SSAS - Understanding KeyColumns Dimension Property
For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to...
2011-06-13
5,891 reads
SSAS Maestro - Day 1 - Redux
Well it’s been an exciting couple of weeks leading up to this course. We have tweaked what we could in...
2011-06-13
630 reads
SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,678 reads
Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
740 reads
What is the best value for Fill Factor in SQL Server?
Introduction
When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to...
2011-06-13
7,479 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers