Articles

We've released a minor version of SQL Monitor, v12.1, that includes two exciting new features: ‘Tagging’ and a ‘Current Activity’ page. In a nutshell: tags allow you to record aspects of a server so that you have information at your fingertips, and the Current Activity page directly queries the monitored server when you open it to get the most up-to-date information possible. It’s all part of our commitment to making SQL Monitor the best monitoring tool out there!

2022-03-14

2 reads

Discuss

Exploring Knowledge Center in Azure Synapse Analytics

by Arindam

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big data systems together. It provides SQL for enterprise data warehousing, Spark technologies for big data, Data explorer for analytics, Pipeline for data integration and ETL and ELT, and other popular Azure services including Power BI, CosmosDB, and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2022-03-11

1,413 reads

Discuss

Populate a SQL Server column with a sequential number not using an identity

by Additional Articles

MSSQLTips.com

IDENTITY

I have a database table that has a lot of data already in the table and I need to add a new column to this table to include a new sequential number. In addition to adding the column I also need to populate the existing records with an incremental counter what options are there to do this?

2022-03-11

SQL Prompt ALT S Magic

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Prompt's new command palette provides a fast way to navigate the tool's functionality via a single keyboard shortcut: ALT+S. Phil Factor explains how you can use the command palette to find and execute SQL Prompt functionality and common SSMS commands, as well as search for database objects.

2022-03-11

DAX table functions for paginated reports: Part 2

by Additional Articles

SimpleTalk

To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.

2022-03-09

Demo webinar: SQL Monitor

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Managing your entire SQL Server estate, on premises, in the cloud or a hybrid, with instant problem diagnosis, intelligent and customizable alerting has never been more vital. Discover how Redgate’s SQL Monitor enables all this from a single pane of glass.

2022-03-09

The Central Management Servers Extension in Azure Data Studio

by Daniel Calbimonte

SQLServerCentral

Learn how to use Azure Data Studio to access a Central Management Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2022-03-07

2,653 reads

Discuss

Moving to Team-Based Database Development with Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

Describing a route from a basic, 'managed' system of database development to use of branching and merging and CI, using Flyway. By taking these steps, you'll reduce development conflicts, lift testing restrictions, and the organization will have much more flexibility on the release of features and bugfixes.

2022-03-07