Check Authentication Scheme (Kerberos) on SQL Server 2005
I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I...
2008-08-07
3,768 reads
I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I...
2008-08-07
3,768 reads
As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download...
2008-08-07
904 reads
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
A little while ago Paul Nielsen tweeted about having free Euro-style SQL stickers. All one had to do was email...
2008-08-04
1,886 reads
The SANS Internet Storm Center has a great handler post about working at the Abuse department for an ISP:
Securing a...
2008-08-04
798 reads
Apparently the Kindle is a great success, financially, for Amazon. That's good to hear, though I haven't made the decision...
2008-08-04
747 reads
Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of...
2008-08-04
297 reads
I'm probably in the minority, but I use an offline reader for consuming feeds. Nothing wrong with browser based readers other than that...
2008-08-04
253 reads
We've got two technical sessions scheduled for tomorrow night. The first is by long time oPASS member Dolores Tofel discussing...
2008-08-03
320 reads
I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because...
2008-08-02
711 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers