Database cloning – CLONEDATABASE
Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1...
2017-02-27
720 reads
Queries with optional parameters
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...
2017-03-06 (first published: 2017-02-27)
3,558 reads
SQL VNext sp_configure on Windows and Linux with dbatools
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I...
2017-03-07 (first published: 2017-02-27)
2,112 reads
The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,555 reads
SQL Clone
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...
2017-03-06 (first published: 2017-02-27)
2,153 reads
Monday Coffee 2017-02-27
Ergh, not a fun weekend rugby wise. But anyway…
Last week Microsoft released an image for SQL Server 2016 SP1 Developer...
2017-02-27
594 reads
Installing Windows Server 2016 Nano on a Physical Server
Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard...
2017-02-27
891 reads
Red Gate SQL Clone (#1) - Initial Setup
Note this was during earlier beta usage, so some of the UI and other features will have been updated more....
2017-02-27
722 reads
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
841 reads
I Don’t Understand
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to...
2017-03-03 (first published: 2017-02-24)
3,367 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Anyone have a SQL Server 2014 Developer Edition DVD?
Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers