Additional Articles

All authors

External Article

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

External Article

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

External Article

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

External Article

SQL Prompt 10: What’s New?

Tony Davis reviews the major new features of SQL Prompt 10, included improved 'ranking' of its code auto-completion suggestions, tab history improvements to make it easier to find 'lost' code, and auto-fixing of code that breaks code analysis rules.

2019-11-19

External Article

New release: SQL Prompt 10

In the latest version of SQL Prompt, we’ve made improvements to all the most popular features. Our new ranked suggestions algorithm prioritizes the suggestions most relevant to you, tab history improvements let you find old tabs easily and star favorites, and new auto-fixes help you resolve code issues quickly. With support for key features of SQL Server 2019, which was made available this week at Microsoft Ignite, SQL Prompt 10 gives you the latest tools to develop faster, improve code quality, and boost team productivity.

2019-11-15

All authors

Blogs

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

By

I’ve often done some analysis of my year in different ways. Last year I...

The Book of Redgate: Spread across the world

By

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Read the latest Blogs

Forums

Finding Motivation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Motivation

The Last Binary Value of the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Binary Value of...

SQL Art, Part 2: New Year Fireworks in SSMS

By tedo

Comments posted to this topic are about the item SQL Art, Part 2: New...

Visit the forum

Question of the Day

The Last Binary Value of the Year

What does this code return? 

SELECT cast(0x2025 AS NVARCHAR(20))
Image 1: Image 2: Image 3: Image 4:

See possible answers