Azure SQL Database Compatibility with SQL Server
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
2,178 reads
Custom deployment parameters in Azure Data Factory - Forget Me Not
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an error that it couldn’t find some of the deployment parameters that I try to override,...
2020-10-05 (first published: 2020-09-26)
768 reads
VMworld 2020 – Top 10 Database Sessions (Part 2)
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member of IT managing SQL Servers in a virtualized environment, you should already be registered for...
2020-10-02 (first published: 2020-09-25)
365 reads
Daily Coping 25 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-25
46 reads
VMworld 2020 – Top 10 Database Sessions (Part 1)
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member of IT managing SQL Servers in a virtualized environment, you should already be registered for...
2020-10-01 (first published: 2020-09-24)
259 reads
Daily Coping 24 Sep 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-24
16 reads
Confounding Variables from Historical Bias
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...
2020-09-23
30 reads
VMworld 2020 SQL Server session preview
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview of my session at VMworld 2020 called Hybrid Cloud Architecture for SQL Server Workloads: Deep...
2020-09-23
91 reads
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can...
2020-09-23
394 reads
Azure Synapse Analytics overlooked features
There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and...
2020-09-29 (first published: 2020-09-23)
444 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
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