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
24 reads
Great Access to Data with Google Fi
I’ve been a subscriber to the Google Fi (formerly Project Fi) network for a couple years now. Like many of you, I depend on my mobile device for lots...
2019-07-12
31 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 1
This blog post is part one in a three-part series that will address how to
use Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks.
2019-07-12
30 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 1
This blog post is part one in a three-part series that will address how to
use Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks.
2019-07-12
20 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 1
This blog post is part one in a three-part series that will address how to
use Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks.
2019-07-12
180 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
14 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-08-05 (first published: 2019-07-11)
530 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
102 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,219 reads
Learning Powershell with Show-Command
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
872 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers