Finding Next Business Day in T-SQL

Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...

Most Read: My Top 5 SQL Server Articles and Blogs

There has been some really useful blogs and articles posted over the last week or so, this is my top...

Encrypting Connections To SQL Server Using Certificates

Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....

Encrypting Connections To SQL Server Using Certificates

Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...

Populating My DBA Database for Power Bi with PowerShell – Databases

Following my post about using Power Bi with my DBA Database I have been asked if I would share the...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...

DR drill - Part 2: Log Shipping

Welcome back to DR drill series!

In the last post (here), we have highlighted a number of ways to setup disaster...

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...