Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
23 reads
Daily Coping 30 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-30
11 reads
Error handling protip: @@Error resets after the next command
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading
2020-04-06 (first published: 2020-03-30)
386 reads
Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions
Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different...
2020-04-07 (first published: 2020-03-30)
1,003 reads
Extracting data from Common Data Services (Microsoft Dynamics 365) using Azure Data Factory
(2020-Mar-30) Little did I know that I can use Azure Data Factory (ADF) to extract data from the Common Data Services (CDS). This data platform enables you to securely store...
2020-04-07 (first published: 2020-03-30)
7,536 reads
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore indexes, on a transactional (OLTP) workload, for real-time analytics.
We'll cover examples from each of...
2020-03-29
50 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-03-29
25 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-04-06 (first published: 2020-03-29)
2,930 reads
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me a whole new percepective of the life. Kaal (Time) is mightiest of everyone and everything....
2020-03-28
43 reads
ASF 030: Benni De Jagere interview
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus on the Microsoft (BI) Stack. On a daily basis, he turns (large amounts) of coffee...
2020-03-27
21 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
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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