Speaking at SQL Saturday #22 - Pensacola, FL
If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010. I will...
2010-06-02
747 reads
Patrick LeBlanc
SQL Lunch Call for Speakers – Quarter 3
One of my quarterly goals is to get speakers for the SQL Lunch webcasts. Q1 and Q2 of 2010 are...
2010-06-01
479 reads
Connecting to DB2 using SSIS
To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is...
2010-05-26
21,702 reads
Upcoming SQL Events
I realized this morning that I will be participating in three SQL Events this week and I want to share...
2010-05-23
572 reads
Report Builder 3.0 - Using Report Parts
Report Builder 3.0 offers many new features to its users. One of the best features, in my opinion, is the...
2010-05-18
1,827 reads
SQL Server Reporting Services R2 - Publishing Report Parts
SQL Server Reporting Services R2 – Publishing Report Parts
SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish...
2010-05-16
4,179 reads
Upcoming SQL Lunch Webcasts
First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We...
2010-05-13
684 reads
Creating Sparklines in PowerPivot
Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2. In this post I will outline the steps...
2010-05-09
2,521 reads
2010 1st Quarter Goals Review
I know it’s kind of late to write a review of my first quarter goals, since we are well into...
2010-05-07
1,093 reads
SQL Server 2008 Performance Tuning Webcast
I recently gave a presentation on SQL Server Performance Tuning via Live Meeting. I discussed how you could use the...
2010-05-07
1,052 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