Architecture Reasons for Putting BLOBs in the Database
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,024 reads
Databases – Infrastructure – Security
Speaking Twice on Oct 1, 2013
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a...
2013-09-30
2,813 reads
PASS BoD: I'm voting for Allen Kinsel
There are some very good names up for this year's PASS Board of Directors. However, I wanted to write a...
2013-09-23
2,382 reads
Installing SQL Server 2008 on a machine with .NET Framework 4.0? Read this.
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,064 reads
Don't Rush When It Comes to Privacy Data
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,217 reads
Why Government Required Backdoors Are a Bad Idea
I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...
2013-09-17 (first published: 2013-09-11)
3,978 reads
Database DoS Whitepaper from Securosis
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,028 reads
Sometimes I don't understand Microsoft's vulnerability classifications
Here's a great example:
MS13-079 - Vulnerability in Active Directory Could Allow Denial of Service (2853587)
Basically, this patches a vulnerability where an...
2013-09-10
1,878 reads
Good Advice on "Certification"
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,636 reads
Is Microsoft's Certification Program Value Microsoft's Fault?
I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...
2013-09-04
1,989 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...
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
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