Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
2009-08-11
11,716 reads
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-11
943 reads
If you have trouble connecting to a busy server, you'll want to watch this installment of SQL School. MVP Andy Warren shows how you can use the dedicated administrator connection (DAC) in SQL Server 2005 and above.
2009-08-06
8,124 reads
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
2009-08-04
9,992 reads
I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was...
2009-08-03
3,085 reads
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
2009-07-30
5,190 reads
Learn how you can configure your SQL Server instance using T-SQL code and sp_configure. MVP Andy Warren hosts this SQL School video.
2009-07-28
5,007 reads
2009-07-28
514 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
5,037 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
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