TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,084 reads
Blog Posts
[Speaking] Lots of Speaking Engagements in September and October
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
766 reads
Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,113 reads
Expert? Ha!
How do you define an expert? My personal definition: An expert is the person that is a chapter ahead of...
2011-08-22
1,245 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
947 reads
Networking Dinner at the PASS Summit 2011
We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...
2011-08-22
677 reads
Outstanding DBAs Make Relationships a Priority
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,032 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
6 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
683 reads
SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features
sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:
- Compression,
- Partitioning,
- TDE and...
2011-08-22
1,371 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
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...
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