For Hire: Data Analytics/Business Intelligence Expert
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
496 reads
Blog Posts
InfluxDB and Annotations
This post assumes you've already setup InfluxDB and have Grafana running.
Inserting annotations Annotations are not a special type of resource, instead it's just another metric that you query with...
2017-08-07
62 reads
Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1
Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a...
2017-08-07
592 reads
Power BI and Data Security – App Workspaces and Power BI Apps
Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and...
2017-08-07
849 reads
SQL Server Agent and Daylight Saving time
There was a bit of chat today on the SQL Community slack about UTC and Daylight Saving Time. It reminded...
2017-08-07 (first published: 2017-07-19)
2,549 reads
SQL Server vs Oracle: Date formatting
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
317 reads
SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,363 reads
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
294 reads
A Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R
Hello Dear Reader! Next week in Jacksonville, Friday August 11th, I will be presenting a Day of Data Science: With...
2017-08-04
484 reads
A Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R
Hello Dear Reader! Next week in Jacksonville, Friday August 11th, I will be presenting a Day of Data Science: With SQL Server 2016/2017, Azure ML, Spark, Hadoop, & R....
2017-08-04
16 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