As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.
2022-04-27 (first published: 2013-03-15)
11,033 reads
SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
2020-03-20
This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.
2017-05-26
4,474 reads
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
1,915 reads
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
2014-02-03
311 reads
You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?
2014-01-06
174 reads
Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.
2012-01-23
69 reads
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
2011-12-19
112 reads
Earlier this week, Jeff Atwood suffered the sort of misfortune we all dread: hard drive failure and no backups. Tony Davis discusses what can be learned from this in terms of the chain of responsibility for an organization's data.
2009-12-21
142 reads
2009-08-10
180 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers