Training and tips to get certified with Microsoft (Part 1)
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...
2017-08-02
9 reads
Blog Posts
Training and tips to get certified with Microsoft (Part 1)
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
156 reads
Are your indexes being thwarted by mismatched datatypes?
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...
2017-08-01
16 reads
Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1
Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...
2017-08-01
496 reads
Manually updating Statistics
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,443 reads
Power BI Custom Visuals Class (Module 60 – Drilldown Player)
In this module you will learn how to use the Drilldown Player Custom Visual. The Drilldown Player acts like a...
2017-08-01 (first published: 2017-07-18)
1,726 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
22 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...
2017-08-01
60,046 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
219 reads
SQL Cruise: Alaska 2017
We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....
2017-08-01 (first published: 2017-07-19)
1,785 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