SQL Server encryption vs. hashing for data security
Study encryption and hashing algorithm options for data security in SQL Server 2005 and use symmetric/asymmetric keys to encrypt and decrypt SQL Server data.
2007-12-25
3,463 reads
Additional Articles
Analysis Services 2005 Processing Architecture
Processing is the operation in which the Analysis server reads data from the relational data source and populates the cubes, dimensions, mining models, etc. This whitepaper describes the Analysis Services 2005 processing architecture in detail and provides guidance on how and when to use the various processing controls.
2007-12-24
1,091 reads
SQL Server 2005 Express Edition - Part 12 - ClickOnce Deployment and Updates
Part 11 of this series presented the publishing options of ClickOnce-capable applications that involve User Instance-based databases. This article takes a closer look at the deployment process, demonstrating the impact of your selections on its characteristics.
2007-12-21
1,434 reads
Optimise SQL Server queries with these advanced tuning techniques
Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options.
2007-12-20
4,971 reads
SQL Server Training at TCU
If you are near Texas Christian University, you might want to check out this training from a SQL Server MVP.
2007-12-20
1,558 reads
RAID Scaling Charts, Part 3: 4-128 kB Stripes Compared
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
2007-12-19
2,353 reads
Serve SQL Data in XML Format
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
2007-12-19
2,780 reads
RAID Scaling Charts, Part 2: RAID 5 And RAID 6
For our RAID tests, we once again use Samsung HM321KJ SATA/300 drives. This time, we benchmarked RAID 5 and RAID 6 setups with three to eight hard drives.
2007-12-18
2,724 reads
Using the DATE data type in SQL Server 2008
In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
2007-12-18
4,179 reads
RAID Scaling Charts, Part 1
Most enthusiast and mainstream users would consider setting up a RAID array mainly for performance reasons - few really care about data safety. For this reason, the majority of arrays installed consists of only two drives, which run a simple RAID 0 stripe set. Haven't you ever asked yourself how these RAID arrays scale as you increase the number of hard drives?
2007-12-17
2,911 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
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