SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-09
1,154 reads
Brian K. McDonald
How Stale Are My Statistics?
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-08
3,068 reads
SQLBIGeek’s Function Friday – Convert Job Duration to Seconds
Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-03
1,111 reads
Creating Analysis Services Partitions Using BIDS
As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...
2010-11-02
2,638 reads
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
2010-10-21
2,806 reads
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-06
3,573 reads
User Preferences and Styling
This article from Brian McDonalds shows how to allow style preferences from within SQL Server Reporting Services
2009-05-29
3,273 reads
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