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's blog
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
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
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
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
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers