Developing Presence

At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to...

SQL Server Monitoring: What to start measuring

So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...

Quick Permissions Audit

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:

Easy Permissions Audit...

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...

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...

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...

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....

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...

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...

MongoDB Replica-Set

The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can...