Additional Articles

What’s New in SQL Monitor 10?

by Additional Articles

Redgate

SQL Monitor

New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features

2020-03-23

Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins

by Additional Articles

Brent Ozar Blog

Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.

2020-03-20

Verifying Object Exists and Dropping Object with One Statement

by Additional Articles

SQLServerCentral

For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-03-19

Securely Manage Database Credentials Using Visual Studio Manage User Secrets

by Additional Articles

MSSQLTips.com

In this tip we cover how to manage application secrets in a development environment to securely store database credentials.

2020-03-18

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

by Additional Articles

SimpleTalk

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.

2020-03-17

Overview of Azure Cache for Redis

by Additional Articles

SimpleTalk

Caching data is one way to improve application performance. In this article, Chandra Kudumla explains a service for caching data found in Azure called Azure Cache for Redis.

2020-03-16

Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY

by Additional Articles

Brent Ozar Blog

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. To make that easier, I’m running the Fundamentals of Index Tuning class this week on the blog.

2020-03-13

Enterprise Insights from the 2020 State of Database DevOps report

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.

2020-03-12

Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause

by Additional Articles

Brent Ozar Blog

2020-03-12

SQL Server Machine Learning 2019: Working with Security Changes

by Additional Articles

SimpleTalk

SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.

2020-03-11

All authors

Additional Articles

What’s New in SQL Monitor 10?

Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins

Verifying Object Exists and Dropping Object with One Statement

Securely Manage Database Credentials Using Visual Studio Manage User Secrets

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Overview of Azure Cache for Redis

Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY

Enterprise Insights from the 2020 State of Database DevOps report

Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause

SQL Server Machine Learning 2019: Working with Security Changes

Blogs

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

The Book of Redgate: Evidence

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

Forums

The New World Of AI Robots

Logic question in a WHERE clause using IIF?

Execute as failure

Question of the Day

BIT_COUNT() V