Piiiiiiiigs, er DBAs, in Space!
If you don't get the reference, it was a set of skits on the old Muppet Show and it starred...
2011-10-13
995 reads
Databases – Infrastructure – Security
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,300 reads
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,413 reads
Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,321 reads
Detecting Security Updates on Vista/Windows 7/2008/2008R2
When trying to detect whether updates have been installed or not, there were several places we investigated:
HKLM\Software\Microsoft\Windows\CurrentVersion\UninstallHKLM\Software\Microsoft\WindowsNT\CurrentVersion\HotFixHKLM\Software\Microsoft\UpdatesSome updates still write to...
2011-10-06
2,702 reads
Two Great Talks on the State of Internet Security
Recently I've started following the public work of Mikko Hypponen (blog | twitter), the Chief Research Officer of F-Secure. I've known...
2011-10-05
1,041 reads
Have end users who need an introduction to SQL Server book?
At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....
2011-09-19
1,324 reads
Looking to interact with those proficient in Japanese
In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...
2011-09-12
787 reads
Don't Wait to Start Blogging
I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...
2011-08-15
2,252 reads
Have the Time? Get in the Game.
This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...
2011-08-11
883 reads
Blogs
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...
Webinar Series – SQL Server Indexing
I’m starting a webinar series about SQL Server indexing with the fine folks of...
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