Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
572 reads
Patrick LeBlanc
Scripting Indexes
I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.In the posting the author explained...
2010-01-15
1,453 reads
MVPs on the SQL Lunch
On January 19th and February 25th the SQL Lunch will have two well known authors, speakers and MVPs presenting at...
2010-01-14
605 reads
SSRS Data Driven Subscriptions Cryptic Job Names
When you create and schedule a Data Driven Subscription for a SQL Server Reporting Services (SSRS) report a job is...
2010-01-14
824 reads
SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)
Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions!...
2010-01-12
803 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-12
623 reads
Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,569 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-05
532 reads
SQL Lunch #7 – Top Tablix Tips
SQL Lunch # 7 – Top Tablix Tips
Speaker: Jessica Moss
Topic: Top Tablix Tips
Add to Outlook: Add to Calendar
Description:
SQL Server Reporting Services 2008...
2010-01-04
1,450 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-28
1,523 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