The Year in Review 2008
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005
In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?
Moving TempDB - SQL School Video
Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.
SSIS Lookup using a Script Component
What would you do if you want to perform 15 to 30 lookups using the same reference dataset? This is how I did it...
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
Database conversion between the most popular DBMSs
Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
Proxy Accounts in SQL Server
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
SQL Bits IV - Call for Presentations
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
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...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers