Types of SQL Server Indexes
In this tip we will go through each type of index that is available in SQL Server and give an overview as well as advice on which index types fit each particular use case.
2020-01-21
Additional Articles
Using Aliases in SQL Prompt
Phil Factor explores the role of table aliases, explaining when they are required, and their general purpose otherwise, the need for sensible naming of aliases, and how SQL Prompt handles them.
2020-01-20
Using Calendars and Dates in Power BI
You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages and average opening and closing balances. In this article, Andy Brown shows how to model various scenarios with calendars and dates, and how to get around some of the issues you may encounter.
2020-01-20
A simple use case for Columnstore Indexes in SQL Server
In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.
2020-01-17
Data Categorization for AdventureWorks using SQL Data Catalog
Josh Smith shows how to use SQL Data Catalog to perform a 'first cut' data classification for one your SQL Server databases, identifying all columns that are likely to hold personal or otherwise sensitive data.
2020-01-17
How to Complain Bitterly using SQL Data Generator
How to use reverse regex expressions in SQL Data Generator to fill a text column in SQL Server with fake, but very realistic complaints.
2020-01-16
Introduction to Gaps and Islands Analysis
T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.
2020-01-16
Monitoring your Servers and Databases with New Relic Infrastructure and SQL Monitor
New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.
2020-01-15
The 2020 Data Professional Salary Survey Results Are In.
We asked what you make, and 1,734 of you in 63 countries answered. Altogether, you made $170,753,936 this year. Damn, y’all are bringing home the bacon!
2020-01-15
Going Serverless with Azure SQL Database
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
2020-01-14
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers