Gatekeeping and why language matters
This is the second in a series of posts about gatekeeping in Information Technology and other fields. Negative terminology The language we use matters. In the first post I...
2019-08-07
30 reads
July 2019 – New Microsoft security update for Spectre variant
If you remember the flurry of news from the beginning of 2018 about side channel attacks called Spectre and Meltdown, Microsoft has included in its July update a patch...
2019-08-20 (first published: 2019-08-07)
364 reads
All Day Seminar on DevOps in Oslo
In just a couple of weeks, I’ll be presenting an all day session on DevOps for databases. It takes place on Friday, August 30th. You can click here now...
2019-08-07
12 reads
Temporary stored procedures
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
921 reads
Microsoft Azure and Oracle Cloud
Microsoft and Oracle recently announced a joint cloud partnership (I have seen the word multi/cross-cloud to explain this) which I found very fascinating to read. It is currently in...
2019-08-07
35 reads
Expose Multiple Docker Ports
I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication....
2019-08-21 (first published: 2019-08-07)
404 reads
Weekly reading #24
Hello #SQLFamily! We are packing for the longest trip this year. Next week we will start in Shanghai, then will move to Bangalore for #DPS10 and the last week...
2019-08-06
20 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week’s episode on YouTube. 5 Things You Need To Know When Reading SQL Server Execution Plans In the first part of this series I explained what an execution...
2019-08-19 (first published: 2019-08-06)
1,316 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
In the...
2019-08-06
11 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
In the...
2019-08-06
18 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