Speaking at SQLSaturday #459, Madrid 2015
Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a...
2015-10-14
398 reads
Niko Neugebauer
- Website: http://www.nikoport.com
Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)
Continuation from the previous 67 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on some...
2015-10-11
453 reads
SQLSaturday Portugal – I am not the principal organiser anymore
Unless you have been sleeping under the rock in the past 5 days, if you are a twitter user, you...
2015-10-06
426 reads
TUGA IT Conference 19-21st of May 2016
Between 19th-21st of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT.
Targeting Microsoft Data...
2015-10-06
546 reads
Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)
Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...
2015-09-22
613 reads
Speaking at SQLSaturday #446, Oregon 2015
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
434 reads
Ryan Adams For PASS 2016-2018 Board
Ladies and Gentlemen, I would love to announce my support for Ryan Adams running for the PASS Board in 2016-2018....
2015-09-16
485 reads
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...
2015-09-15
535 reads
Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 64 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This article is dedicated to the improvements...
2015-09-06
597 reads
Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...
2015-09-02
623 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers