SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,140 reads
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,140 reads
Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...
2006-06-15
2,053 reads
I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...
2006-06-13
2,329 reads
It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...
2006-06-12
1,581 reads
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,492 reads
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,144 reads
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,450 reads
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,496 reads
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,623 reads
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,650 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
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