Randomized Colors in Report
Randomized color report? So help my CODE!
Writing a Reporting Services report can be challenging, making you use the most of...
2014-07-01
1,660 reads
Generating Email Reports using XML
SQL Server has some handy features: one of those features is dbmail, which I tend to use less until I’ve...
2014-06-19
837 reads
Mind the Gap
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...
2014-03-04
625 reads
Memory Timeouts
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...
2013-12-30
1,294 reads
Blogs
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
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