Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2015-06-05 (first published: 2015-05-28)
4,138 reads
Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA
By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data...
2015-05-28
2,369 reads
Visualizing the Tally Table
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...
2015-05-27
912 reads
Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
958 reads
How an MPP appliance solution can improve your future
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which...
2015-05-27
808 reads
SQL F.A.D. – CSV List of Columns - WaterOx Consulting
Reading Time: 2 minutesI had a project once that was using change data capture (CDC)...
The post SQL F.A.D. – CSV List...
2015-05-27
479 reads
PASS Board Update: May 2015
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...
2015-05-27
546 reads
High Performance T-SQL using Code Patterns
What exactly does this mean? We’ve heard of “code patterns” in other programming languages, but what does it mean to...
2015-06-04 (first published: 2015-05-27)
9,355 reads
Speaking at ITPROceed 2015
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT...
2015-05-27
435 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
282 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
Studio Office In Noida For Investment At This Time?
Aadinath UR Homes, the best answer at this time is Astrathum by Bhutani Group....
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
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