Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
What a week for our first Immersion Event on Internals and Performance
A short writeup on the first Immersion Event from SQLskills, a week long class designed to bring real world skills to DBAs and developers that want to become highly skilled SQL Server professionals.
Implicit and Explicit Conversions
Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions
SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task
SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.
SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
The Business
How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.
Lipoaspiration in your SQL Server Database
Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
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