Getting Started with Azure Data Studio
Azure Data Studio (ADS) is a cross platform query tool for SQL Server. Learn how to get started using ADS to work with your SQL Server instances.
2024-01-09 (first published: 2019-03-04)
7,999 reads
Articles
Using Azure Data Studio with Git
In this article, we will examine how to use Azure Data Studio with a git repository for storing code.
2024-01-09 (first published: 2019-05-14)
10,394 reads
Always On Availability Groups Troubleshooting and Monitoring Guide
This guide helps you get started on troubleshooting some of the common issues in AlwaysOn Availability Groups and monitoring AlwaysOn Availability Groups. It is intended to provide original content as well as a landing page of useful information that is already published elsewhere.
2024-01-09 (first published: 2021-08-25)
Customizing Statistics Histogram in SQL Server 2019
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL Server engine, though many DBAs and developers know that periodically we might need to update those statistics to ensure good performance of queries. SQL Server 2019 gives us more options.
2024-01-09 (first published: 2019-04-01)
3 reads
Data Saturday #8 - SouthWest US
This Data Saturday Event is being jointly developed by the Albuquerque Data Platform Users Group, Arizona Data Platform Users Group, and the Santa Fe Data Platform Users Groups. This event will include sessions on many Microsoft Data Platform related topics. Join us on May 15, 2021.
2024-01-09 (first published: 2021-05-14)
How to Execute SSIS Packages from SQL Server Agent
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
2024-01-09 (first published: 2020-12-01)
Mental Health and Wellness Day 2022
Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.
2024-01-09 (first published: 2022-04-08)
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
2024-01-09 (first published: 2022-10-10)
SQL Unit Testing reference guide for beginners
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
2024-01-09 (first published: 2023-09-08)
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?