What is a database exactly? Steve Jones wonders if we should define it differently after viewing a list of some of the largest databases in the world, many of which might not equate to what a DBA or developer would consider a "database."
2009-12-18
152 reads
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
255 reads
Some change requests, such as deploying a new stored procedure or trigger, are relatively easy to manage whereas others, such as data deployments, tend to thwart all attempts at standardization. And yet, there must be a way, and Rodney Landrum believes that DBA-developer co-operation lies at the heart of it.
2009-12-16
288 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
96 reads
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
433 reads
Steve Jones looks at query optimization, and based on some blogging from Microsoft, the level of impact that you can have on a system.
2009-12-14
87 reads
For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.
2017-08-11 (first published: 2009-12-11)
745 reads
A guest editorial from Andy Warren today looks to inspire you with a few thoughts about how you might force yourself to grow a little next year.
2009-12-10
107 reads
What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.
2014-10-17 (first published: 2009-12-09)
197 reads
This editorial was orignally published on Dec 8, 2009. It is being re-run as Steve is on vacation. Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2014-10-01 (first published: 2009-12-08)
149 reads
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
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