Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...
2017-08-31 (first published: 2017-08-18)
3,814 reads
Blog Posts
Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
700 reads
Creating an SSIS project
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,899 reads
Getting the Hyperlink from Excel
I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base...
2017-08-30
724 reads
Ich werde Deutschland beriesen
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
538 reads
Microsoft Azure – How to create a virtual machine using PowerShell – Part 2
Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40010.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-2.aspx Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Virtual...
2017-08-30
790 reads
Offline Microsoft Documentation? Download it!
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...
2017-08-30
3,160 reads
Running SQL Server in Kubernetes on Azure Container Services
I’ve been meaning to get to grips with Kubernetes for a while now but I have to admit, I was...
2017-08-30
886 reads
Speaking at SQL Saturday Spartanburg (#681)
I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg...
2017-08-30
498 reads
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,266 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