Skip to Content

Uncategorized Posts

SQLblog is Moving to a New Hosting Provider

Posted July 14, 2017

By

After a long run on our current hosting provider, SQLblog will be moving to a new hosting provider. During this process, starting later this evening, SQLblog... more »
0

SQL Server Dump Analyzer

Posted July 11, 2017

By

Recently Microsoft released a preview version of the SQL Server Diagnostics extension to SSMS. You can read more about it here. I downloaded it from here and... more »
0

Azure Data Lake Store encryption using Azure Key Vault for key management

Posted July 11, 2017

By

Case You want to create an encrypted Azure Data Lake Store (ADLS) with a master encryption key that is stored and managed in your own existing Azure Key Vault.... more »
0

PASS SQL Saturday #687 Slovenia 2017

Posted July 11, 2017

By

Here we go for the fifth time! The leading event dedicated to Microsoft SQL Server in Slovenia, PASS SQL Saturday #687, will take place on Saturday, December... more »
0

T-SQL Window Functions

Posted July 10, 2017

By

I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which... more »
0

What’s in a name? How should SQL Server 2017 Graph Edge tables be named?

Posted July 09, 2017

By

Dennes Torres recently wrote a really excellent article introducing Graph Objects in SQL Server 2017. You’ll find it here:... more »
0

SQL Down Under Show 71–Joe Sack and Shreya Verma on Adaptive Query Plans and Graph API

Posted June 28, 2017

By

Hi Folks, I had the pleasure recently to record a podcast with an old friend Joe Sack who is working with Adaptive Query Plans in SQL Server 2017. Joining us... more »
0

BI Beginner: Using R Forecasting Visualization

Posted June 25, 2017

By

There are new HTML 5 enabled custom visualization for making interactive R visualizations in Power BI Desktop. Read the documentation and find the download... more »
0

24 Hours of PASS (July 2017) – Summit Preview

Posted June 24, 2017

By

Which topics can you expect to see at the PASS Summit 2017 ? Find it out from July 19 to 20, 2017 at the 24 Hours of PASS Summit Preview edition. Register... more »
0

How to calculate barcode check-digit using T-SQL language

Posted June 23, 2017

By

Introduction In order to scale, it’s imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to... more »
0