Latest Blog Posts
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just one example: migrating SQL Server Instances takes a massive amount of work. You need to backup and restore every database, write down instance… Read more
In the next few months I will be speaking at some awesome events around Europe.
I’ll be speaking at Visual Studio Live – Austin in May 2017. I was fortunate to be selected to speak again, after my first two VS Lives last year in DC and Orlando. I’m excited to go back, as the conference is a lot of fun, and Austin is a… Read more
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or a city. Simple enough, until you notice that or. We might only get a first name, or a state and the query still needs to work. These queries are… Read more
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group.
IMPORTANT NOTE :- The names of dbatools commands with a Sql prefix WILL CHANGE in a later release of dbatools. dbatools… Read more
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning of statistics and basic concepts, and illustrate them to the best of my ability using R and T-SQL where appropriate.
For this week I have chosen a statistical concept called… Read more
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing.
Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I’m so excited about SQL Clone and why… Read more
Ergh, not a fun weekend rugby wise. But anyway…
Last week Microsoft released an image for SQL Server 2016 SP1 Developer Edition in containers. Previously the only edition available was vNext Enterprise Evaluation which was a real problem in making containers a viable option for many businesses.
There’s no… Read more
Note this was during earlier beta usage, so some of the UI and other features will have been updated more. I plan on writing more on this promising tool as I get a chance to dive into it more, especially the powershell cmdlets for database cloning automation. In the meantime,… Read more
End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem and then continue with their work. This restarting activity works for two to three weeks and after that, a point comes where the system gets… Read more
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 MERGE statement for the Columnstore Indexes, or as I call it – the worst enemy of the Columnstore Indexes. It is extremely difficult to imagine some statement or… Read more
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to go through my contacts and put together calls with some technologists for a series of discussions. OK. I thought about what we’d need, compared it to a mental list… Read more
The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises apps were the clear standard for database apps. However, with the numerous advantages of building in or migrating to managed services, the cloud isn’t just a niche anymore. Managed services… Read more
But here is a story of a client that may have too many backups after all.
Our monitoring system found that the backups on a client server had suddenly started running very long. When…
Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck
Buck Woody goes through how he learns on the move (great article)
I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade went.
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know were still in elementary school. So please understand that when I write the rest of this little… rant.
I read… Read more
They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the message, there isn’t much detail in it. Take a look at this (slightly edited) email… Read more
Today at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.
Here’s what I’ll be covering:
You’re building a new application using SQL Server as a back-end and you… Read more