SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task
Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
You Don't Know Enough
We never know enough ourselves to be sure that we have completely thought through all the scenarios or holes in our logic. This is why it makes sense for us to have a group that spends time looking for problems.
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
SQL Saturday #73 - Orange County, CA
A free one day training event on Apr 9, 2011 in Huntington Beach, CA. Come learn about SQL Server with a number of SQL Server experts.
Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
ERDDUG - Introduction to Indexes with SQL Server MVP Gail Shaw
If you are in South Africa near East Rand, join the East Rand Developer and DBA group on April 9 for a presentation by SQL Server expert, MVP, and longtime SQLServerCentral author, Gail Shaw.
How To Fix Connect
Today Steve Jones asks for your ideas on Microsoft's Connect. It's a good way to submit bugs and suggestions, but it seems to suffer from a scale problem. What do you think would help?
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
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