Columnstore Indexes – part 84 (“Practical Dictionary Cases”)
Continuation from the previous 83 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this blog post I wanted to...
2016-06-20
623 reads
Blog Posts
Comparing two query plans
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,365 reads
Implementing Fuzzy Sets in SQL Server, Part 0: The Buzz About Fuzz
By Steve Bolton
…………I originally planned to post a long-delayed series titled Information Measurement with SQL Server next, in which I’d...
2016-06-20 (first published: 2016-06-13)
2,416 reads
LAST_VALUE–The Basics of Framing
I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built...
2016-06-20
783 reads
Monday Morning SQL Break – June 20, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-06-20
884 reads
Using Power BI with Enterprise, On-premises Data
I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for...
2016-06-19
703 reads
Power BI Architecture Diagram v2 is Now Available
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram...
2016-06-18
983 reads
Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
349 reads
Finding File Growths with Extended Events
I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of...
2016-06-17 (first published: 2016-06-13)
6,497 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
792 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
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...
Forums
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Jembatan Lima Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Kh. Moch Mansyur No.15 F, RT.4/RW.1, Duri Sel., Kec. Tambora, Kota...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers