The February 2009 Energy Update
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
2009-02-25
637 reads
Articles
Running Singleton Queries Against a DMX Data Mining Model - SQL School Videos
Learn how you can run a singleton data mining query against a cube with a mining model.
2009-02-24
1,843 reads
Using Containers with Checkpoints (Part 2)
Continuing on with his series on checkpoints, Aaron Akin now looks at how various types of containers can be used with checkpoints and Integration Services.
2009-02-24
6,034 reads
Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
2009-02-24
66 reads
Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
2009-02-24
69 reads
Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
2009-02-24
63 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online? This question was sent to me via email. My reply follows. Quick question on DB mirroring client redirection after Principal fails
2009-02-24
3,649 reads
Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
2009-02-24
1,756 reads
The Data Loading Performance Guide
This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.
2009-02-24
3,931 reads
8 Clicks to What Changed
Finding out what happened on a SQL Server instance can be a challenge for even experienced DBAs. SQLClue, a new tool by longtime SQL Server expert Bill Wunder can help. We have a short case study that shows you how this tool can help.
2009-02-23
3,006 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
Solutions for Environmental and Pollution Testing | Fare Labs Pvt. Ltd.
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
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