Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
459 reads
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
459 reads
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...
2016-11-07 (first published: 2016-11-01)
1,011 reads
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
388 reads
Continuation from the previous 88 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to dedicate this blog...
2016-10-25
522 reads
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
588 reads
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
502 reads
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
537 reads
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
460 reads
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...
2016-09-18
698 reads
I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on...
2016-09-13
528 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers