MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.
References and links to get you started in backing up your database to the Azure blob storage.
Can you deploy your database changes without any downtime? Steve Jones has a few notes.
The challenges of getting enough resources for our projects aren't always apparent.
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
The poll this week looks to the future and artificial intelligence. Steve Jones wonders if we'll ever really see this.
Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.
A short explanation and infographic of what SQL is. For the non-SQL people in your life.
Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the post-war decades. In this article Joe Celko looks at the history of mainframes, FORTRAN I and COBOL.
What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers