Introduction to DevOps: 10 Guidelines for Implementing DevOps
In this last article in the series, Robert Sheldon discusses ten guidelines that will help organisactions implement DevOps successfully.
2019-11-27
Additional Articles
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
2019-11-26
Making the switch to SQL Monitor
Australia and New Zealand’s leading cloud account software provider Xero needed a cost-effective monitoring solution with better features and coverage. Read Xero’s story about how they switched from their old monitoring tool to Redgate’s SQL Monitor.
2019-11-26
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
2019-11-25
Recover SQL Server Resource Database
SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.
2019-11-22
SQL Clone PowerShell Scripting: The Basics
Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs.
2019-11-22
How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans
Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.
2019-11-21
Large estate monitoring at BMW
Managing 100s of business-critical servers across multiple continents became a struggle for BMW. SQL Monitor provided a fast and powerful solution that allowed them to scale to their business needs. Availability has since increased to 100% and doubled the speed of delivery. Learn how here.
2019-11-21
Redgate’s journey to DevOps
At Redgate, we research DevOps, write articles, whitepapers and other content about DevOps, and talk a lot about DevOps. We actively encourage our customers to introduce database DevOps too, using our portfolio of database development solutions. But here’s the thing. We don’t do it to sell software. We do it because we believe in it. Reda on to find out why.
2019-11-20
SQL Server Function to Measure CPU Usage Per Database
Performance | CPU Usage | T-SQL Script - In this article we look at a script that can be used to show CPU usage by SQL Server database to get an idea which databases are consuming the most CPU on your server.
2019-11-20
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers