-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLSailor.com

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (http://www.expedia.com/), having IT experience of more than 9 years. Anup is an active blogger with SQLSailor.com, and can also be found on MSDN SQLServer forums and BeyondRelational.com. He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

SQL Server 2017 running on Windows Containers!

One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on containers?

Here is what Microsoft has to say:

“Windows Containers are an isolated, resource controlled, and portable operating environment. An application…

Read more

0 comments, 1,013 reads

Posted in SQLSailor.com on 10 May 2017

Google Cloud Spanner – Next big thing in the database world?

Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this since it’s a big news!

So, what exactly is Cloud Spanner and why it’s a big deal? Here is how Google Summarizes its importance:

“A globally distributed relational database service…

Read more

0 comments, 448 reads

Posted in SQLSailor.com on 14 March 2017

Windows Server 2016 and SQL Server 2016 – A match made in heaven!

For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this!

With Windows Server 2016, you can now create a Windows Cluster with nodes in multiple domains. Or even without a domain (Workgroup).

With… Read more

0 comments, 618 reads

Posted in SQLSailor.com on 22 December 2016

When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config

Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of normal happened during the stress window.

In one of the asynchronous replicas, I started noticing a series of messages related… Read more

2 comments, 647 reads

Posted in SQLSailor.com on 7 November 2016

AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016

SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements based on some of my test cases(A detailed blog post on that will follow soon). In this blog post we will look at another key improvement, ie Database Level Health… Read more

2 comments, 4,930 reads

Posted in SQLSailor.com on 30 June 2016

Why you should think about upgrading to SQL Server 2016!

SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading to SQL Server 2014? If yes, then wait! SQL Server 2016 is packed with great features and mainly, there is plenty… Read more

0 comments, 2,271 reads

Posted in SQLSailor.com on 1 May 2016

Curious case of SYS.MESSAGES

A strange error struck me last week, and this post is all about that.

What you normally expect when you run SELECT * FROM sys.messages? The query will return a row for each message_id or language_id of the error messages in the system, for both system-defined and user-defined messages. Read more

3 comments, 1,304 reads

Posted in SQLSailor.com on 7 March 2016

Encrypting AlwaysOn Availability Group Transport- Some thoughts!

Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.

The transport security involves encryption of packets exchanged between the servers involved, and for AlwaysOn AG the encryption is made possible on the Hadr_endpoint.

By default, its encrypted using AES Read more

0 comments, 713 reads

Posted in SQLSailor.com on 28 January 2016

SQL Server 2016 CTP 3 Setup – UI Improvements

There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters.

My earlier post on setup UI changes for CTP 2 is available here.

The 1st change is… Read more

0 comments, 493 reads

Posted in SQLSailor.com on 11 November 2015

Azure Virtual Machine Blog Series – Changing the size of a VM

I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –

“Changing the size of a VM”

When creating an Azure VM to host your SQL Server, you have an… Read more

2 comments, 1,960 reads

Posted in SQLSailor.com on 24 September 2015

SQL Server Data Tools is now a separate installer – Things to know!

Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I had previously used SQL Server Data Tools, and I tried to search for it under Programs. To my surprise, it was missing.

I thought I might have missed adding it… Read more

0 comments, 803 reads

Posted in SQLSailor.com on 8 September 2015

Why I won’t be running SQL Server Standard Edition on Business Critical Servers!

I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a need to install Enterprise edition for business critical systems.Here are my top features which are missing in standard edition –

Scale limits

Memory – Standard only supports 128 GB memory. Read more

0 comments, 955 reads

Posted in SQLSailor.com on 9 July 2015

Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No, not a Production DB !) and go and get it from here.

This post is based on the UI changes/additions which I observed while I installed this specific… Read more

1 comments, 2,229 reads

Posted in SQLSailor.com on 29 May 2015

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –

ERROR:

Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.

My first reaction was to… Read more

1 comments, 1,129 reads

Posted in SQLSailor.com on 26 May 2015

SQL Server 2016 Announced, and it stretches to the Cloud!

Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of SQL Server, and its SQL Server 2016.

Satya started the Ignite keynote, and he looked really pumped when he announced SQL 2016.

“SQL 2016 perhaps is the biggest breakthrough…

Read more

0 comments, 812 reads

Posted in SQLSailor.com on 10 May 2015

Exploring AlwaysOn Availability Group Template in Azure

This is one of those posts which is due for a long time. I was really excited when Microsoft announced the release of an AlwaysOn AG template for the Azure Portal back in August 2014.

I had decided to explore this AG template soon after the launch, and this post… Read more

0 comments, 6,105 reads

Posted in SQLSailor.com on 1 April 2015

This one enhancement makes AlwaysOn Availability Group better in SQL Server 2014 !

I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in SQL 2014. In this blog post  I would like to talk about one major enhancement around the increased readable secondaries availability in SQL Server 2014.

In SQL Server 2012… Read more

0 comments, 7,673 reads

Posted in SQLSailor.com on 19 February 2015

SELECT INTO Improvements in SQL Server 2014 !

SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.

These features still remains as the top favorite and the most compelling reasons for organizations to do an upgrade, However SQL Server 2014 also includes very small but very relevant… Read more

8 comments, 9,600 reads

Posted in SQLSailor.com on 13 January 2015

SQLCMD and SET QUOTED_IDENTIFIER

Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then this post will definitely help you.

I was working on requirement wherein I had to simulate a workload which will do massive inserts to a table which had computed column.… Read more

6 comments, 7,172 reads

Posted in SQLSailor.com on 14 November 2014

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on  Cloud Databases 101.

Rimma Nehme is one of those super smart people who works for Microsoft Gray… Read more

1 comments, 624 reads

Posted in SQLSailor.com on 10 November 2014

Older posts