Power BI World Tour 2019 Tampa
In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour...
2019-01-10
361 reads
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...
2019-01-10
176 reads
SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16
I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...
2019-01-10
14,926 reads
Why is the query hash so useful?
An example of how I use the query hash
I wrote a blog on what the query hash is, right here....
2019-01-10
6,714 reads
Donating Hair Again
There are several organizations which take hair donations, but the one I prefer to donate to is Wigs for Kids,...
2019-01-10
197 reads
Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easily
Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...
2019-01-09
22 reads
Pro SQL Server on Linux–Install
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-09
359 reads
TICK TOCK…6 MONTHS UNTIL SQL SERVER 2008/2008 R2 SUPPORT EXPIRES UNLESS YOU TAKE ACTION
If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...
2019-01-09
59 reads
Back to the future
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
235 reads
Source Control using Azure Data Studio and GitHub
You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...
2019-01-09
3,502 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