Monday Coffee 2017-05-29
I’ve always said that this blog is my way of giving back to the SQL Server community but there is...
2017-05-29
344 reads
Blog Posts
Quitting VIM
I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM....
2017-05-29
573 reads
Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-05-29 (first published: 2017-05-17)
4,105 reads
Upgrading to Modern SQL Server eBook with ScaleArc
Recently I contributed my thoughts in a new ebook from ScaleArccalled “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter...
2017-05-29
416 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
13 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
438 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
9 reads
Columnstore Indexes – part 105 (“Performance Counters”)
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
For a very long time I was...
2017-05-27
769 reads
SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after...
2017-05-27
12 reads
SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...
2017-05-27
637 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