The Data Stewardship Approach to Data Governance: Chapter 1
The definitions of data governance and data stewardship that I use have changed, albeit slightly, over the years of providing data governance and stewardship solutions.
Using Report Parameters in SQL Server Reporting Services
Report parameters assist in narrowing down a report for better analysis.
Putting Unit Tests to Work
Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.
Free and Cool - MP3
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
Free and Cool - WMV
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
SQL Server 2005 Express Edition - Part 14 - Replication Support
SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.
SQL Server clustered index design for performance
Find why SQL Server clustered index design should be narrow and static and how clustered indexes affect many-to-many tables to improve database performance.
Adding Custom Code To Reporting Services
Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.
Clearing the Bar
How do you decide who gets hired? Do you get the best candidate? Steve Jones says that most of us don't necessarily hire the best person that applies for a variety of reasons.
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
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