Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
2007-11-21
2,282 reads
Articles
Beginning Database Design - Spot the Flaws
A new series by Steve Jones that tackles a basic design of a few tables. Read the scenario, look over this design, and see if you can find the problems.
2007-11-20
8,777 reads
.NET Building Blocks: Build a Configurable Database Credential Selector
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
2007-11-20
4,108 reads
Enterprise Architecture: Connect-Dots for Adults, Part 2
This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.
2007-11-20
2,301 reads
Monitoring on a Budget
Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this
2007-11-19
9,153 reads
Declarative Management Framework - Performing Policy Management
The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.
2007-11-19
2,087 reads
Importing Text-based data: Workbench
Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL
2007-11-19
4,235 reads
SQL Server Job Scheduling
The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.
2007-11-16 (first published: 2006-03-08)
42,381 reads
Create a Custom Test Interface Provider for Team Sytem
This article looks at fuzzy testing and how to build a provider for your own use.
2007-11-16
3,685 reads
SQL Server 2005 Database Options and Configuration Performance Audit Checklist
As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.
2007-11-16
4,384 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
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