Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)
In this module you will learn how to use the Beyondsoft Calendar Custom Visual. The Beyondsoft Calendar displays a single...
2017-08-22 (first published: 2017-07-31)
1,591 reads
Blog Posts
Runtime Metrics In Execution Plans
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-08-22
252 reads
SELECT…INTO in SQL Server 2017
One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...
2017-08-22 (first published: 2017-08-02)
3,283 reads
SQL Saturday Charlotte (#683)
I am so excited to be helping out with SQL Saturday Charlotte again this year. This is the 6th year...
2017-08-22
410 reads
SQLpassion Online Trainings in September 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-22
234 reads
Using the SSIS Script Component With Multiple Outputs
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
484 reads
Adding a New Default to a Column
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21
496 reads
Automatic Seeding in Always On Availability Groups in SQL Server 2016
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-21
992 reads
Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
973 reads
Backup Log to Nul– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21 (first published: 2017-07-31)
1,727 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
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...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers