Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,899 reads
SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...
2019-01-14
731 reads
Data Warehousing Tip #4 – Trust your instinct
My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...
2019-01-21 (first published: 2019-01-14)
2,910 reads
Dodging Deadlocks With Indexes
A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....
2019-01-23 (first published: 2019-01-14)
6,513 reads
WordPress's Block Editor and the Publicize Feature
Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...
2019-01-14
16 reads
Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
202 reads
MongoDB Replica-Set
The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can...
2019-01-13
176 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out...
2019-01-12
8 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you...
2019-01-12
249 reads
MongoDB – Storage
MongoDB has a Storage Wired Tiger by default MongoDB generated some standard wt (WiredTiger extension) files, WiredTiger uses MultiVersion Concurrency Control...
2019-01-12
175 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