Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
795 reads
Niko's blog
Columnstore Indexes – part 99 (“Merge”)
Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on the...
2017-02-26
836 reads
Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
464 reads
SQLPort V2
The new site of SQLPort is finally live. This is not just a redesign of the original site, published in...
2017-02-06
294 reads
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
655 reads
CloudProPT – The New Cloud/Azure Community in Portugal
I am so happy to share the news that as of today, the new community CloudProPT (as in Cloud for...
2017-01-27
457 reads
Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)
Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on a...
2017-01-22
687 reads
The most underrated show on Data Platform – SQL Unplugged
I would like to write a blog post about by far the most underrated online show about Data Platform – SQL...
2017-01-20
701 reads
Columnstore Indexes – part 95 (“Basic Query Patterns”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...
2017-01-07
492 reads
Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
576 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers