July SCSUG Meeting
First, I wanted to post a reminder that the July SCSUG meeting has been moved to this coming Monday, July...
2010-07-08
609 reads
First, I wanted to post a reminder that the July SCSUG meeting has been moved to this coming Monday, July...
2010-07-08
609 reads
This is a bit later than usual as the meeting was a week ago now, but I wanted to post...
2010-06-18
660 reads
I saw a Blog post by Grant Fritchey (Blog | Twitter) a couple days ago on using Geospatial data in SSRS...
2010-06-18
1,797 reads
Another quarter gone, and unfortunately I’m still looking about the same on goal progress. Still looking good on Blog posts...
2010-06-10
1,020 reads
In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008...
2010-06-08
1,116 reads
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they...
2010-06-02
742 reads
Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular...
2010-05-24
2,413 reads
This coming Thursday is the SCSUG meeting. This is no normal meeting. Instead of the standard format of pizza/socialization followed...
2010-05-10
904 reads
Whew! So I've been super busy the past week and a half upgrading our production server from SQL 2000 to...
2010-04-26
702 reads
Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of...
2010-04-13
804 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