Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
582 reads
DevOps Basics – Ignoring Files in Git
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,519 reads
Quick Model Database Tidbit
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
745 reads
Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
675 reads
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
49 reads
What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,360 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
536 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
714 reads
The #SQLSAT Speaker Goodie Bag
Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and...
2017-10-29
623 reads
A Pretty PowerBi Pester Results Template File
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
606 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