Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
285 reads
Editorial
Consolidating Again and Again and Again
This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2014-11-25 (first published: 2009-11-12)
228 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
124 reads
Is Unit Testing Important?
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
510 reads
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
2009-11-09
332 reads
#SQLPASS on Twitter
With the PASS Summit taking place last week in Seattle, Steve Jones found that there was a tremendous amount of SQL Server news and information on Twitter. It's a medium that is becoming useful for SQL DBAs.
2009-11-09
82 reads
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
2009-11-06
56 reads
Inspiring Change
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
129 reads
The Summit 2009 - Day 1
Steve Jones talks a little about day one of the PASS Summit in 2009. A day of news, announcements, and briefings.
2009-11-04
61 reads
It's Time for Encryption
Encryption is starting to become a necessity, not an option as we work with and store more sensitive data. A guest editorial from Andy Warren comments on our fears of implementing encrpytion and why we might want to just encrypt everything.
2009-11-03
213 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