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
505 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
64 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
593 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,551 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
324 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,365 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 SQL Server 2016/2017, Azure ML, Spark, Hadoop, & R....
2017-08-04
18 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
485 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers