Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
511 reads
Blog Posts
SQL Azure Migration Wizard
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary...
2011-05-09
1,303 reads
Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
799 reads
SQLRally Orlando Begins This Week!
It actually starts tomorrow for me (and many of you), I’ll be at the Marriott World Center around 1 pm...
2011-05-09
821 reads
SSC Editorial: Running as SysAdmin
My editorial about Running as Sysadmin ran in the SQLServerCentral newsletter yesterday and generated some good (and passionate!) responses. It’s...
2011-05-09
831 reads
Catalog view or compatibility view?
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
2,999 reads
My 2011 PASS Summit Submissions
I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle...
2011-05-06
793 reads
New Diagnostic Manager functionality
The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives...
2011-05-06
1,025 reads
Orlando 101 For SQLRally Attendees: Weather
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-06
834 reads
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of
my customers. One big part of this...
2011-05-06
1,424 reads
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
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
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