Articles

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

Discuss

Large estate monitoring at BMW

by Additional Articles

Redgate

SQL Monitoring

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

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

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

by Additional Articles

MSSQLTips.com

CPU Usage Data

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

Understanding Outer Joins in SQL

by jonfrisbee

SQLServerCentral

Outer Joins

The basics of outer joins are shown in this short piece that explains how they work.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(13)

You rated this post out of 5. Change rating

2019-11-19

9,648 reads

Discuss

Associating Data Directly with SQL Server Database Objects.

by Additional Articles

SimpleTalk

Database objects

It is easy to attach details and documentation to a SQL Server database using extended properties. In fact, you can add a number of items of information to any database objects such as tables, views, procedures or users.

2019-11-19

SQL Prompt 10: What’s New?

by Additional Articles

Redgate

SQL PROMPT

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

How to make your 2020 monitoring strategy a success

by Press Release

Redgate

Conferences, Classes, Events, and Webinars

Join Redgate’s Arneh Eskandari and BMW’s Tony Maddonna for a free webinar on Nov 20: How to make your 2020 monitoring strategy a success. Learn how to prepare for successful estate growth, expected trends for the year, and the role monitoring plays in engabling growth and stability in your organization.

2019-11-18 (first published: 2019-11-08)

Merging tables in Power BI dataflows with PRO subscription

by Additional Articles

SimpleTalk

Power BI

Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way more expensive than the PRO version and sometimes inaccessible. In this latest blog post Dennes Torres explores the subject.

2019-11-18

Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

by Additional Articles

Redgate

SQL Compare

Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables.

2019-11-18

Articles

How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans

Large estate monitoring at BMW

Redgate’s journey to DevOps

SQL Server Function to Measure CPU Usage Per Database

Understanding Outer Joins in SQL

Associating Data Directly with SQL Server Database Objects.

SQL Prompt 10: What’s New?

How to make your 2020 monitoring strategy a success

Merging tables in Power BI dataflows with PRO subscription

Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

Blogs

Rolling Back a Broken Release

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Forums

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Can You Let Go of Determinism

Question of the Day

Lots of FKs