Simplified Session Backups
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...
2015-10-12
484 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
36 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
39 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
1,412 reads
Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)
Continuation from the previous 67 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on some...
2015-10-11
461 reads
Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV
Continuing from previous post , this post will discuss a few scenarios on hash collisions.
The following "in memory" table with a hash...
2015-10-11
607 reads
SQL Saturday #453–Minnesota 2015–A Window Into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2015-10-10
469 reads
Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
13 reads
Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
199 reads
Indexed views on any core SQL server edition–The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
462 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers