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.
2009-03-11
62 reads
Articles
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...
2009-03-11
3,430 reads
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.
2009-03-11
2,147 reads
Basic Auditing - SQL School Video
Learn the basics of how to audit changes on your SQL Server with MVP Andy Warren.
2009-03-10
5,673 reads
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.
2009-03-10
4,264 reads
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...
2009-03-10
1,439 reads
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.
2009-03-10
5,694 reads
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.
2009-03-10
571 reads
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.
2009-03-10
784 reads
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.
2009-03-10
556 reads
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