Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...
2017-08-18
11 reads
Blog Posts
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with...
2017-08-17
39 reads
Change RegisterAllProvidersIP setting on an existing Availability Group
Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
21,499 reads
Countdown to Denver SQL Saturday: Register and Attend
My First Presentation was on Database Security. Those slides are still available for nostalgia sake 66 to 673 in N...
2017-08-17
166 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package viewer with one goal to allow a developer...
2017-08-17
7 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package...
2017-08-17
91 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package...
2017-08-17
68 reads
Power BI NFL Football Stats Comparisons and Analysis Report is now available!
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-08-17 (first published: 2017-07-28)
3,478 reads
Session Resources for: Visual Design Tips for Power BI & SSRS 2016+
Yesterday I did a session for Idera’s Geek Sync series called “Visual Design Tips for Power BI & SSRS 2016+”. In...
2017-08-17
432 reads
Session Resources for: Visual Design Tips for Power BI & SSRS 2016+
Yesterday I did a session for Idera’s Geek Sync series called “Visual Design Tips for Power BI & SSRS 2016+”. In the session, I called out a bunch of...
2017-08-17
19 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