The Next Phase of My Career
For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...
2013-11-18
619 reads
For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...
2013-11-18
619 reads
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,486 reads
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
509 reads
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
611 reads
It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T). Wendy's...
2013-05-14
662 reads
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
803 reads
A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I...
2013-02-05
1,093 reads
Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...
2013-01-28 (first published: 2013-01-24)
2,923 reads
My friend and SQL Server professional Tim Radney (blog/@tradney) has written a new entry in the Joes2Pros series:
You can get...
2012-11-01
756 reads
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
631 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers