The Afternoon Whistle
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
2010-02-18
112 reads
Editorial
The R2 Penalty
An interesting point was made by a reader about the price of SQL Server licenses when R2 is released. Steve Jones comments about a penalty that some of you may find if you look to build a SQL Server 2008 server later this year.
2010-02-17
254 reads
The Average Joe
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
2010-02-16
408 reads
President's Day 2010
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
2010-02-15
37 reads
The Community Has Been Heard
Steve Jones talked about the announcements of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 in this editorial.
2010-02-15
163 reads
Safety in Numbers
One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.
2010-02-12
118 reads
When is 8000 too small?
Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
382 reads
The Best Laptop
Steve Jones recently went on a search for a new laptop, looking for the "best" one for him. But what it the best? And is it worth pursuing?
2010-02-10
503 reads
An Administrative Security Hole?
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
2010-02-09
200 reads
Measures and Rules
Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.
2010-02-08
362 reads
Blogs
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
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...
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