Parens (Really) Matter for Unions
In the course of testing a major upgrade, one of my users in Accounting happened upon a problem with one of her scenarios. The web app we were working...
2017-11-22
7 reads
SQLpassion Black Friday Deal
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-11-21
541 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...
2017-11-21
446 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition ( .vsts-ci.yml ) and you want to use one...
2017-11-21
7 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...
2017-11-21
42 reads
How do I use VSTS variables in YAML CI Build definitions?
Hey, VSTS YAML builds are my new favorite thing, by like a million miles.
If you have a yaml build definition...
2017-11-21
44 reads
SQL Server 2017 : Data Transformation and Interpolation using Python
As a continuation to my previous article, How to use Python in SQL Server 2017 to obtain advanced data analytics,...
2017-11-21
667 reads
Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)
In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data...
2017-11-28 (first published: 2017-11-21)
1,429 reads
Microsoft Professional Program in Data Science – The Finish Line
In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this...
2017-12-01 (first published: 2017-11-21)
3,155 reads
Does The Join Order of My Tables Matter?
Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...
2017-11-21
434 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers