SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that...
2011-04-28
1,721 reads
Jason Brimhall
SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that they were opening up the presentation schedule a little...
2011-04-28
4 reads
A SQL Experiment – Mentoring
News Flash
The SQL Community is about to get stronger. Why? There is a great new initiative that was recently launched....
2011-04-26
799 reads
A SQL Experiment – Mentoring
News Flash The SQL Community is about to get stronger. Why? There is a great new initiative that was recently launched. Steve Jones and Andy Warren are teaming up...
2011-04-26
12 reads
SQLPeople Interview
Have you heard about this new project out there called SQLPeople? It is a new (relatively) project that is the...
2011-04-25
544 reads
SQLPeople Interview
Have you heard about this new project out there called SQLPeople? It is a new (relatively) project that is the brainchild of Andy Leonard. Andy is trying to help...
2011-04-25
9 reads
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt...
2011-04-12
528 reads
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from...
2011-04-12
2 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan....
2011-04-11
1,112 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the...
2011-04-11
26 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