Daily Coping 1 Apr 2022
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...
2022-04-01
20 reads
Blog Posts
Power Automate – Returning the Last Day of the Month
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
393 reads
Starting LocalDB–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Lots of people have never worked with LocalDB,...
2022-04-01 (first published: 2022-03-28)
204 reads
Daily Coping 31 Mar 2022
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...
2022-03-31
9 reads
KQL Series – Big Data Analytics with Azure Data Explorer
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
32 reads
KQL Series – create a database in our ADX cluster
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
57 reads
KQL Series – create an Azure Data Explorer cluster
I have written a lot about the magic of KQL and the brilliance of Azure Data Explorer. Now we should create a cluster of our own that hosts Azure...
2022-03-31
10 reads
KQL Series – creating KQL queries
Basically when we are writing KQL we are asking the following questions: Does it exist? Where does it exist? Why does it exist? What shall we do with the...
2022-03-31
13 reads
KQL Series – KQL usage with Advanced Hunting (this is huge)
This blog post is about another use of KQL that will definitely help your organisation and make you very popular. First of all check out this video here which...
2022-03-31
220 reads
KQL Series – Security Monitoring with Azure Data Explorer
This blog post demonstrates a hybrid end-to-end monitoring solution integrated with Microsoft Sentinel and Azure Monitor for ingesting streamed and batched logs from diverse sources, on-premises, or any cloud,...
2022-03-31
24 reads
Blogs
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Forums
Pull mssql to Postgres
Does anyone have a script\example that would connect to SQL server instance run a...
Fill in missing hours for each VisitID during the day
create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID,...
Database copy for report work load
Hi Team, I am looking for a an help, Please see my problem below....
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers