Filtering Unneeded Dimension Members in PerformancePoint Filters
Removing redundant dimension members from a Tree filter in PerformancePoint 2007 by using a simple MDX query.
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
Attribute Member Values in Analysis Services
Learn how the appropriate use of attribute member Value can support the selection and delivery of enterprise data in a more focused and consumer-friendly manner. Join BI Architect Bill Pearson in a hands-on examination of the attribute member Value property and its underlying settings in Analysis Services.
Scaling Up Your Data Warehouse with SQL Server 2008
This paper discusses how to use SQL Server 2008 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers.
Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit
Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.
The SQLServerCentral Party at PASS
Details for those of you coming to PASS and looking to attend the SQLServerCentral.com party on Tuesday night.
Twitter Your Issues
Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.
Using the File System Task - SQL School Video
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
Building a SQL Server Data Dictionary with the Extended Properties and Third Party Tools
When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers