Introduction to Query history and server reports i...
The post Query History and Server Reports in Azure Data Studio appeared first on SQLServerCentral.

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?
The post Populate a SQL Server column with a sequential number not using an identity appeared first on SQLServerCentral.

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 […]
The post Exploring Knowledge Center in Azure Synapse Analytics appeared first on SQLServerCentral.

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.
The post SQL Prompt ALT S Magic appeared first on SQLServerCentral.

To return detail data using DAX, use the table functions. Adam Aspin covers UNION, EXCEPT, INTERSECT, and CALCULATETABLE in this article.
The post DAX table functions for paginated reports: Part 2 appeared first on SQLServerCentral.

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.
The post Demo webinar: SQL Monitor appeared first on SQLServerCentral.

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.
The post Moving to Team-Based Database Development with Flyway appeared first on SQLServerCentral.

In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
The post Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data appeared first on SQLServerCentral.