As promised here is a short video to start of the series on SQL Server partitioning. The video covers the difference between simply placing files in Filegroups with […]
MS SQL Performance tuning: – Partitioning explained
Today I am going to do a quick one hour session explaining partitioning. We will cover the difference between partitioning and placing tables in Filegroups, How to implement […]
In Memory OLTP – New feature in SQL 2014
We saw this coming with the demand for highly transaction database becoming more frequent clubbed with the need to store data in very large sets. Naturally one precludes […]
Downloading the SQL 2014 product guide
Today we are going to do a quick post on where you can download the SQL 2104 product guide. http://www.microsoft.com/en-in/download/details.aspx?id=39269 The above link takes you directly to the […]
Installing SQL Server 2014
Today we are going to look at the different steps involved in installing SQL Server 2014. The important thing to keep in mind here is that while the […]
Downloading SQL 2014
In this part of the series we are going over the step by step how to download MS SQL Server 2014. You can download the trail version of […]
SQL 2014 licensing
As with any installation of SQL server we start with the licensing of SQL Server 2014. Most DBAs are unaware of the implications of licensing costs on the […]
SQL 2014 Series
Starting today we are launching a new series on topics related to SQL Server 2014. Free videos and tutorials on key new features as well as some interesting […]
SQL Server Replication Series: – Server is not configured as a distributor.
When setting up a distribution database using the wizard, if you select the second radio button from the below screen you need to already have configured the distribution […]
SQL Server Replication Series: – Configuring the distributor
In this blog we will look at how to configure the distribution database for SQL Server replication. The distribution database is a very important database in replication as […]