SQL Server Magazine July 2004
[Focus]
Concerns about legislation regarding personal privacy have DBAs searching for solutions that SQL Server doesn’t support natively. With this example solution, you can secure your database row by row and satisfy the most stringent privacy requirements.
By Sean Maloney
The pressure's on to keep customer data private, but your organization can still use its valuable collection of customer information--and even make money from it. Just follow these basic steps, and you and your customers can rest secure.
By Brian Connolly
[Features]
A well-designed data warehouse can help your organization make faster and more informed decisions, but data-warehousing projects are risky business. Here's why so many data-warehousing projects fail and how to increase your project's chances for success.
By Craig Utley
Creating this sample credit card encryption application can teach you a lot about the realities of building, testing, and deploying CLR-based stored procedures--and about how the CLR provides functionality that T-SQL can't.
By William Vaughn
[SQL Server Savvy]
SQL Server doesn't store file-creation times in the system tables. However, if you have a database file's full name you can acquire the file's creation time by using xp_getfiledetails.
By Brian Moran
If you're careful, you can have your cake and eat it, too. I've found a way to achieve high insert throughput rates without significantly damaging my ability to handle read queries at the same time.
By Brian Moran
Pageiolatch_sh is a shared latch of the generic class pageiolatch. A pageiolatch_sh value identifies a connection that's waiting on SQL Server to read a particular page from disk into memory that's available to the SQL Server buffer pool.
By Brian Moran
[Editorial]
As the range of activities categorized as BI stretches into new areas, your organization might already be participating in BI projects—and you don’t even know it.
By Michael Otey
[Inside SQL Server]
Help the query optimizer determine the best execution plan by clearly identifying variables and understanding parameters.
By Kalen Delaney
[T-SQL Black Belt]
Take a look at these back doors to nondeterministic T-SQL functions before they close, and peek in a side door that lets you modify data through inline UDFs.
By Itzik Ben-Gan
[New Products]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
The top four features in Microsoft’s new ASP.NET Resource Kit.
By Michael Otey
[Lessons from the Field]
For high performance, bidirectional transactional replication has no equal--if you can get around several limitations.
By Bren Newman
|
