Common Tempdb Trace Flags – Back to Basics
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
558 reads
Blog Posts
Vertical Scroll Bar Map Mode (Day 6)
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
564 reads
Changing Default Logs Directory – Back to Basics
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used...
2018-01-05
39 reads
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
858 reads
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,692 reads
Meltdown and Spectre exploits, they can affect your SQL Server instances
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
58 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
96 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
705 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
421 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
576 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers