Friend of Redgate – 2017
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2017-02-05
4 reads
Friend of Redgate – 2017
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective...
2017-02-05
702 reads
SQLite and the Performance Implications of Indexes
Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes...
2017-02-05
542 reads
Monitoring SLAs with SQL Monitor Reporting
Proactive Reporting for SQL Server If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big...
2017-02-04
17 reads
Monitoring SLAs with SQL Monitor Reporting
Proactive Reporting for SQL Server
If you’re a return reader of this blog you know I write often about monitoring and...
2017-02-09 (first published: 2017-02-04)
2,052 reads
SQL Server on Linux
Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it...
2017-02-04
734 reads
Get Your SQL Server Product Key with Powershell #dbatools
There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.
Get-SqlServerKey is a command that...
2017-02-03
4,556 reads
How the SQL Agent Job schedule_uid broke my heart, and my jobs!
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-08 (first published: 2017-02-03)
9,555 reads
Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))
In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual. This is...
2017-02-07 (first published: 2017-02-03)
1,497 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
13 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers