DirectQuery for Power BI datasets and Azure Analysis Services (preview) from Blog Posts –...
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power...
Basic Cursors in T-SQL–#SQLNewBlogger from Blog Posts – SQLServerCentral
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Cursors are not efficient,...
Goodbye PASS from Blog Posts – SQLServerCentral
“It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness,...
Daily Coping 23 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Daily Coping 22 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Top 3 Upgrade & Migration Mistakes from Blog Posts – SQLServerCentral
This is a guest post by another friend of Dallas DBAs – Brendan Mason (L|T) Upgrading and migrating databases can be a daunting exercise...
End of an Era – SQL PASS and Lessons learned from Blog Posts –...
Most of my blog is filled with posts related to PASS in some way. Events, various volunteering opportunities, keynote blogging, this or that…With the...
Using Azure Durable Functions with Azure Data Factory – HTTP Long Polling from Blog...
(2020-Dec-21) While working with Azure Functions that provide a serverless environment to run my computer program code, I’m still struggling to understand how it actually...
Daily Coping 21 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Estimating the storage savings by removing columns with NULL value across the table or...
In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with...
Must Read in Cloud & Networking
Top life hacks for prepping for your IT certification exam
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed up for a class that lasted one week, per...
Must Read in Data
Learn Transformers for Natural Language Processing with Denis Rothman
Key takeaways
The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today.
Artificial intelligence is...
