Common Tempdb Trace Flags – Back to Basics
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
26 reads
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
564 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
870 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
377 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
65 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
98 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
712 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
582 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
423 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
46 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers