Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
531 reads
The Scary DBA
Database Fundamentals
One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to...
2017-06-15 (first published: 2017-05-31)
2,787 reads
Technology Gender Gap By State
This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...
2017-06-02 (first published: 2017-05-22)
1,418 reads
MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
596 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,169 reads
Redgate Alexa Contest Winners!
A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...
2017-05-05
476 reads
Food On Your Table
I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially...
2017-04-25
389 reads
Query Hash Values, Plan Guides and the Query Store
I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does...
2017-05-08 (first published: 2017-04-24)
1,305 reads
The Age of Data and Software Development
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
400 reads
Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
623 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers