The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
Tip for determining I/O Heavy Queries
When it comes to performance tuning, locating the problem index is one of the first steps and being able to very quickly narrow the focus of your efforts makes for a much more efficient DBA.
SQL Q & A: Database Consistency, Temporary Tables, and More
Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.
Policy Based Management - On Change Prevent, Doesn't
SQL Server 2008 introduces " Policy Based Management " (PBM) as a way to better manage your servers. This was a feature that I really thought had, and still has a lot of potential for making the life of a DBA easier. The tagline for PBM is "manage...
Using Operations Manager Reports to Validate Your Uptime
Operations Manager has stacks of reports to help you monitor your applications' uptime, but reporting can be difficult until you understand all the different options, parameters, and the structure of the Operations Manager health model. Firstly, you need a clear idea about the way that your organization defines 'uptime', and only then you can start your reports. Thomas LaRock explains...
Reporting Services Styles in a Database Table
A follow-up on Adam Aspin's series about SSRS styles. I have emailed Adam the article because he suggested it would be good to have one here after his works get published.
Using SP_MSForEachDB and SP_MSForEachTable - SQL School Video
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers