Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen
I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server...
2015-07-11
669 reads
COLUMNSTORE INDEX… DEMO
COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...
2015-07-11
2,558 reads
Columnstore Indexes – part 59 (“Aggregate Pushdown”)
Continuation from the previous 58 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
SQL Server 2016 brings a number of...
2015-07-11
838 reads
Do you know about Whatsapp web?
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of distinctively decent competitors they have within the space of...
2015-07-11
14 reads
Do you know about Whatsapp web?
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...
2015-07-11
1,483 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
16 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
829 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
22 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
808 reads
Microsoft Azure Data Catalog
Just announced is the Microsoft Azure Data Catalog, which is an enterprise metadata catalog / portal for the self-service discovery of...
2015-07-10
1,029 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
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...
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