Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
131 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
33 reads
Automatic Tuning Monitoring and Diagnostics
Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic...
2019-01-10 (first published: 2019-01-04)
2,706 reads
How to upload a vagrant file while provision a server
How to upload a vagrant file while provisioning a server
I was recently introduced to vagrant and i found it very interesting. I picked up a task that which is creating...
2019-01-04
17 reads
How to upload a vagrant file while provision a server
How to upload a vagrant file while provisioning a server
I was recently introduced to vagrant and i found it very interesting. I picked up a task that which is creating...
2019-01-04
53 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New Year to our friends, customers and clients.
SQL Server 2008...
2019-01-04
28 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New...
2019-01-04
224 reads
Some of my goals for 2019
In late December 2018 I had a discussion with Amanda Martin the PASS Community Manager around things that I would...
2019-01-03
212 reads
A New PiHole in the Sky
Last year I set up a PiHole server on my RaspberryPi to help block some ads and malicious stuff (tracking,...
2019-01-11 (first published: 2019-01-03)
2,397 reads
Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
402 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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...
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