Virtualization and the existential angst of the DBA
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
2011-12-19
99 reads
Tony Davis
- Interests: football, modern literature, real ale
Stairway to Transaction Log Management in SQL Server, Level 4: Managing the Log in Simple Recovery Mode
Tony describes in more detail the SIMPLE recovery model, and the way it works, its advantages and disadvantages.
2011-11-18
7,490 reads
Gold in the Execution Plan hills
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
215 reads
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
2011-09-26
127 reads
Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery
This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.
2011-09-07
9,662 reads
Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture
In order to make it easier to understand truncation, space reuse and fragmentation in the log file, Tony gives a brief explanation of how the transaction log works.
2011-08-17
14,687 reads
Being an extremely productive DBA
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
2011-07-18
250 reads
Cloud Barriers
I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?
2011-07-04
82 reads
DBAs on ACID
Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.
2011-04-04
261 reads
Let the optimizer drive
For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.
2011-02-07
190 reads
Blogs
Webcast Tomorrow on SQL Server Disaster Recovery
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
Forums
Agent job security account
Hi All, I have few sql server agent scheduled jobs which are supposed to...
How to manage Time zone changes for countries
Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October...
How much transaction logs generated by hourly/daily
For MSSQL is there any queries or methods for me to pull historical data...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers