Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
41 reads
Articles
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
35 reads
Essential Steps for the Integrated Enterprise Data Warehouse, Part 1
This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.
2008-05-13
2,998 reads
SQL Server Management Studio Reports and Dashboard
This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.
2008-05-13
5,062 reads
Mirrored Backups
One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
2008-05-12 (first published: 2007-06-12)
8,478 reads
Moving Databases
SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.
2008-05-12
12,611 reads
Professional SQL Server 2005 Integration Services
A short review of the WROX red covered book that looks at Integration Services for the DBA.
2008-05-12
3,070 reads
Screencast: SQL PerfMon counters for buffer manager
SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.
2008-05-12
2,558 reads
The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
2008-05-12
38 reads
The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
2008-05-12
30 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA Finance WTC Mangga Dua Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001,...
BCA KCU SUNTER Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta...
BCA KCP Arundina Cibubur Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24, RT.2/RW.11,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers