Power BI Architecture Diagram v4 is now available!
I’ve finally updated my Power BI Architecture Diagram to include some of the new features that are now available and...
2019-02-16
804 reads
SQL Server 2017 Reporting Services: The Basics Part 4
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-16
402 reads
Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC #SQL #Azure #MSDTC
If you have been following my blog, you probably know that I write a lot of step-by-step guides for building...
2019-02-15
1,233 reads
Benchmarking with WorkloadTools
If you ever tried to capture a benchmark on your SQL Server, you probably know that it is a complex...
2019-02-15
532 reads
New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and...
2019-02-15
25 reads
Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
21 reads
Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on...
2019-02-15
102 reads
Achievement Unlocked – SQL Bits
Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email. I had submitted...
2019-02-15
489 reads
Practical Web Scraping–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-15
1,374 reads
Partitioning 4: Finding partitioning in DMVs and Object Explorer
Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to...
2019-02-15
1,961 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