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
95 reads
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
2011-12-19
95 reads
Tony describes in more detail the SIMPLE recovery model, and the way it works, its advantages and disadvantages.
2011-11-18
7,446 reads
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
213 reads
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
124 reads
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,570 reads
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,532 reads
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
245 reads
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
81 reads
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
257 reads
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
184 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers