T-SQL Tuesday #116 – SQL on Linux Installation
Hey look who is hosting T-SQL Tuesday, it is me, and I’m late. Sorry I broke my demo machines for Linux and had to set up everything again so...
2019-07-12
7 reads
Blog Posts
T-SQL Tuesday #116 – SQL on Linux Installation
Hey look who is hosting T-SQL Tuesday, it is me, and I’m late. Sorry I broke my demo machines for Linux and had to set up everything again so...
2019-07-12
21 reads
Azure SQL Elastic Jobs
The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases. Targets can be in...
2019-07-11
179 reads
Finding Data Gaps
Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...
2019-07-11
9 reads
Get email alert when number of queries waiting for CPU exceeds thresold
You may have situations where the CPU % usage is well below the alert threshold but still queries are running slow because they are waiting for CPU to be...
2019-07-11
97 reads
Introducing sp_AzSQLDBPermissions (Beta)
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough ... Continue reading
2019-07-11 (first published: 2019-06-27)
397 reads
Powershell one liner to export data directly from SQL Server to Excel
Most of the times I use the CSV files whenever I need to import or export SQL Server data. And then if I need to do further analysis on...
2019-07-11
4,213 reads
Spark and dotnet in a single docker container
I really like the new dotnet driver for Spark because I think it makes spark more accesable to devs who might not know pythpn or scala.
If you want to...
2019-07-11
5 reads
Spark and dotnet in a single docker container
I really like the new dotnet driver for Spark because I think it makes spark more accesable to devs who might not know pythpn or scala.
If you want to...
2019-07-11
27 reads
Understanding Columnstore Indexes in SQL Server Part 1
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...
2019-07-11 (first published: 2019-06-26)
1,280 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers