Bulk Data Load Using OLEDB Template Libraries
New Author! This is a fairly article that looks at how to do bulk data loading at a very (very) low level. You'll need to be able to read code to make use of this.
2003-10-23
5,855 reads
Articles
For SQL Server, XML Is One Answer
New author! Nick discusses why 'XML is One Answer', outlining some of what he believes are key points about using XML with SQL Server. This is a follow up (and sort of counter point) to another great article we had here on the site a couple weeks ago by Don Peterson. Good stuff!
2003-10-22
5,738 reads
An Interesting Article on Unicode and Character Sets
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
2003-10-21
70 reads
Documenting Stored Procedures
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
2003-10-20
18,696 reads
Mapping Database File Objects and Fragmentation
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
2003-10-16
8,866 reads
When Do You Pull Your Hair Out?
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
2003-10-15
5,181 reads
Terminal Services - A Couple Tips
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
2003-10-14
7,467 reads
Review of SQLDiff by Lockwood
Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.
2003-10-13
6,075 reads
Fixed Database Roles
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
2003-10-10
10,595 reads
Cluster That Index - Part 2
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
2003-10-08
8,593 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers