Weekly reading #24
Hello #SQLFamily! We are packing for the longest trip this year. Next week we will start in Shanghai, then will move to Bangalore for #DPS10 and the last week...
2019-08-06
17 reads
Blog Posts
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-08-05 (first published: 2019-07-11)
523 reads
Off-Topic Origem HS-3 Headphones Review
I’m a big fan of music when I’m moving through life, and I use a lot of headphones. Between the gym, travel, and downtime between volleyball matches, I often...
2019-08-05 (first published: 2019-07-30)
264 reads
Understanding Columnstore Indexes in SQL Server Part 3
My last two blogs were on understanding columnstore and creating columnstore indexes. In this post, I will touch on one last topic, when to use columnstore indexes. As noted...
2019-08-05 (first published: 2019-07-17)
650 reads
PASS.ORG–MS Renews #SQLSat Sponsorship and More…
The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
32 reads
SSMS Keyboard Shortcut Fun
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
57 reads
Getting Downtime
It’s been a crazy year, as are many of my years. I tend to like that, because I prefer to be busy rather than idle. That’s good, but I...
2019-08-02
19 reads
Implement DevOps One Step At a Time
In preparation for my upcoming DevOps training days (see the bottom of this post for details) and for some articles I’m working on, I’ve been building all new automation...
2019-08-02 (first published: 2019-07-15)
355 reads
java.lang.ClassNotFoundException: org.apache.spark.deploy.DotnetRunner with 0.4.0 of spark-dotnet
There was a breaking change with version 0.4.0 that changed the name of the class that is used to load the dotnet driver in Apache Spark.
To fix the issue...
2019-08-02
11 reads
java.lang.ClassNotFoundException: org.apache.spark.deploy.DotnetRunner with 0.4.0 of spark-dotnet
There was a breaking change with version 0.4.0 that changed the name of the class that is used to load the dotnet driver in Apache Spark.
To fix the issue...
2019-08-02
244 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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...
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