Manners
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
Manners
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
Error Handling in SSIS
New author Jack Corbett brings us a look at a way of finding out what caused your error in Integration Services.
Re-size TempDB files
Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.
Congratulations to Grant Fritchey
He was awarded MVP status today, no joke, for his work in the community. According to his blog , it’s not a joke. And it shouldn’t be. Between the excellent book he wrote on execution plans, his work for PASS, and regular contributions on SQLServerCentral.
SQL Server UDF to convert integer date to datetime format
This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.
Portable Data Centers
Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of the changes being put forth by Microsoft and others.
Troubleshooting
New author Mike Walsh brings us an interesting analogy on troubleshooting skills that might get you to think differently about how you attack problems.
Automatic Full Parallel Processing of Hierarchical SQL Queries
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
Service Broker Poison Message Handling
Recent installments of our series dedicated to SQL Server 2005 Express Edition have focused on error handling techniques that leverage Service Broker's transactional nature. This article describes Poison Message detection characteristics and presents an example demonstrating its use.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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...
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