EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
2007-09-22 (first published: 2002-12-09)
32,452 reads
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2007-09-22 (first published: 2003-06-05)
30,114 reads
I have been on vacation the last week, which meant I spent the previous three weeks at work preparing to...
2007-09-10
607 reads
"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software
The Midlands PASS Chapter...
2007-07-31
1,562 reads
If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it...
2007-07-25
1,728 reads
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,656 reads
If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for...
2007-07-17
1,716 reads
Last week I received an email indicating that MySQL had made available an entry level certification, the Certified MySQL Associate....
2007-07-16
1,558 reads
In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what...
2007-07-16
1,565 reads
What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM
Speaker: SQL Server MVP...
2007-07-11
1,447 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