The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.
2014-12-26 (first published: 2009-11-02)
534 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,887 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
563 reads
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
178 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
263 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
156 reads
What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...
2013-10-28
209 reads
We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?
2013-06-24
263 reads
While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.
2013-04-29
60 reads
Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.
2013-04-24
7,493 reads
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
Comments posted to this topic are about the item How to Attach and Detach...
Comments posted to this topic are about the item What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers