Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
192 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
146 reads
SQL in the City 2019 in London
We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April...
2019-02-20
777 reads
Optimize for ad hoc VS single use plans
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
367 reads
Creating custom SQL Server Helm charts
In my previous post I went through how to deploy SQL Server to Kubernetes using Helm in which I used...
2019-03-07 (first published: 2019-02-20)
3,036 reads
Odd Behavior With LOB/Overflow Data
In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...
2019-02-20
174 reads
7 more ways to Query Always on Availability groups
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
398 reads
SQLTreeo Add-In guide
SQLTreeo Add-In Plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide on how to use the SQLTreeo...
2019-02-19
137 reads
SQLTreeo Add-In guide
SQLTreeo Add-In Plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide...
2019-02-19
302 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
117 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