December PASSMN Meeting
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
352 reads
Blog Posts
IT Education Part 1
Like many in IT I’m self taught, starting with DOS and batch files, then proceeding through QuickBasic, Visual Basic in...
2010-12-06
619 reads
Moving Windows in Windows 7
I had my laptop connected to a projector recently, and for some reason a few windows got moved off screen,...
2010-12-06
565 reads
My Weekend
We are now well into December and Christmas is fast approaching, I have most, but not all of my shopping...
2010-12-06
511 reads
Review: Idera SQL Doctor
Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...
2010-12-06
2,606 reads
SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
375 reads
The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-06
2,220 reads
Tip: Schema Qualify Objects in SPs
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,708 reads
Digg
I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to...
2010-12-05
526 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,423 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
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...
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