SQL Server

SQL Server 2016: native support for JSON

A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function(…)

Because SharePoint 2013 has also limitations!

WHAT IS?  Boundaries: are Static limits that cannot be exceeded by design. An example of a boundary is the 2 GB document size limit.  Thresholds: are configurable limits that can be exceeded to accommodate specific  requirements. A good(…)

SQL Server 2014: First Service pack (SP1) is available

May 14th, Microsoft has released the first Service Pack (SP1) for SQL Server 2014. It is more than thirteen months after the RTM version. SQL Server 2014 Service Pack 1 includes all of the CU from 1 to 5.

Variations on 1M rows insert (3): using SQL Server In-Memory features

Let’s continue with this series about inserting 1M rows and let’s perform the same test with a new variation by using SQL Server In-Memory features. For this blog post, I will still use a minimal configuration that consists of only(…)

Using VSS snapshots with SQL Server – part I

  This is probably a series of blog posts about some thoughts concerning VSS snapshots with database servers. Let’s begin with this first story: Some time ago, I implemented a backup strategy at one of my customers based on FULL(…)

Get the main information from SQL Server databases with PowerShell

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a(…)

Get SQL Server Network Configuration with PowerShell

This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get(…)

Variations on 1M insert (2): write commit

In this blog post, I will try to do the same than my colleagues about Oracle and for PostgreSQL. As a reminder, we’ve seen in my previous blog post that SQL Server is designed(…)

When tempdb database may cause indirect issues

A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can’t use his own information I decided to reproduce(…)

In-Memory OLTP: Hash and Range indexes

Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index. These two indexes(…)