SQL Server 2005 has added encryption capabilities to the platform, much to the delight of many DBAs. However setting up encryption can be confusing and difficult for most DBAs. New author Mike Good brings us a perspective from someone who is brand new to this set of features and has spent time working through the functions and documenting them for the rest of us.
This article provides an architecture and process framework to ensure data quality in a data warehousing environment.
SQL Server's CREATE ASSEMBLY statement lets you catalog code with one of three predefined security buckets. But under the covers, there are actually two distinct security models at play: Code Access Security and Host Protection, and you need to understand both.
Managing a large number of servers can be quite the challenge for many DBAs and it seems to get worse each year as more servers are added without an increase in staffing. New author Mark Tierney brings us the first part of a series on the framework he's built to help manage his servers.
T-SQL Try…Catch block for SQL Server exception handling has new, improved functions to handle errors when executing T-SQL code in SQL Server 2005.
Most SQL Server DBAs will never need to read the registry for their instances, however in case you do find yourself needing to read or write something in SQL Server 2005, Vince Iacoboni brings us a technique for performing both of these actions.
Robyn and Phil decide to build an RSS newsfeed in TSQL, using the power of SQL Server's XML.
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Comments posted to this topic are about the item Removing TDE
Comments posted to this topic are about the item The day-to-day pressures of a...
How do I remove TDE encryption of data from database xxx?
See possible answers