Keep It Simple
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
Keep It Simple
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
Netbooks - Hands On Review
The other day I was wandering around Best Buy and noticed that they had a few netbooks for sale. I stopped by because I've considered using one for presentations and some light travel, instead of lugging around my full sized notebook. Vacations, maybe...
Process Dimensions in an Analysis Service database
Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.
Basic Auditing - SQL School Video
Learn the basics of how to audit changes on your SQL Server with MVP Andy Warren.
Using Event Handlers with Checkpoints (Part 3)
In Part 3 of his series on checkpoints in SSIS, Aaron Akin talks about how you can use event handlers in your containers to better control the workflow.
Book Review: Big Red - Voyage of a Trident Submarine
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report Builder 2.0 is a standalone product, shipped as separate download from the SQL Server and Visual Studio suites. It allows users to develop and run reports locally, in addition to permitting the publication of these reports to SQL Server Reporting Services.
Guest Editorial: Improving Northwind
The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
Guest Editorial: Improving Northwind
The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers