Doing a Full Outer Join in Power Query
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,554 reads
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,554 reads
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
526 reads
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
368 reads
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...
2015-07-03
2,573 reads
A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent...
2015-06-29
1,458 reads
Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and...
2015-06-29
1,215 reads
ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the...
2015-06-16
640 reads
For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means...
2015-06-01 (first published: 2015-05-28)
3,261 reads
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT...
2015-05-27
422 reads
Here is an overview of the articles I published in the first quarter of 2015.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-04-22
531 reads
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );See possible answers