Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,614 reads
Blog Posts
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
937 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
19 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,389 reads
Diskpart command line utility
To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information....
2011-03-21
466 reads
Next Up: SQL Connections!
SQL Saturday #70 is officially in the books. There's some administrative stuff: I will do a blog post about lessons...
2011-03-21
785 reads
SQL Server Connections in a week
I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...
2011-03-21
791 reads
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-21
1,402 reads
SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask
While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...
2011-03-21
1,304 reads
Einladung zum SQL Server Performance Tuning und Troubleshooting Workshop, 24. Mai 2011 in Wien
Sind Sie schon mal in das folgende Problem-Szenario gelaufen, und mussten Ihren wohlverdienten
Feierabend und die Vorfreude auf das Wochenende opfern:...
2011-03-20
810 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