Updated: Jan 2008. One of the big changes in SQL Server 2005 is the integration of the CLR into the relational engine itself. This is probably the biggest reason for the delays in completing the product and it is a controversial decision. Steve Jones spends a few minutes looking at the pros and cons of having the CLR integrated and possible implications for DBAs.
This white paper describes how application developers can incorporate data quality into their Microsoft SQL Server 2005 Integration Services solutions.
Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers