Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

Building a Virtual Machine within Azure (IaSS) – Improvements !

Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows azure portal over the last couple of months.

I had to create a VM in Azure to do some testing, and this time I decided to try out the… Read more

0 comments, 5,842 reads

Posted in SQLSailor.com on 12 August 2014

Microsoft Azure Portal Preview looks promising !

This is one of those posts which is pending for a very long time. I was pretty excited when Azure Portal Preview was announced during BUILD2014. This portal will deeply enhance developer experience.

As a SQLServer person I was interested to explore more within the portal to see what in… Read more

0 comments, 120 reads

Posted in SQLSailor.com on 26 June 2014

Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!

SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM is much easier and seamless now.

This post talks about the journey of a database named “MoveMeToCloud” which is hosted on SQLServer 2014 RTM on-prem instance to a SQL Instance… Read more

0 comments, 1,096 reads

Posted in SQLSailor.com on 16 April 2014

Data Collector in SQLServer 2014 – What’s New !

Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting up Data Collector in SQL2014. In the walk-through if there is a new feature or change which is specific to SQL2014,then I will highlight that.

As soon… Read more

0 comments, 1,608 reads

Posted in SQLSailor.com on 4 April 2014

SQL Server 2014 Install – Step by Step

Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh copy to start testing it.

I will be writing a separate post on the features I love about SQLServer 2014,but here is the step by step install process for a… Read more

4 comments, 2,309 reads

Posted in SQLSailor.com on 1 April 2014

Folks,Know your Outbound Data Transfer Costs – Windows Azure

The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.

Yes, when I said cost I indeed meant the $ amount which is involved. The good news however is that all the Inbound Data sent to Azure is free. The… Read more

0 comments, 1,190 reads

Posted in SQLSailor.com on 19 March 2014

Rollback DBCC CHECKDB REPAIR !

I learned something new today while I was listening to one of the courses on corruption authored by the master, Paul Randal(B/T).

In the course Paul mentioned that you can actually rollback DBCC CHECKDB REPAIR by using it within a Transaction.

This is something which is… Read more

0 comments, 511 reads

Posted in SQLSailor.com on 6 February 2014

One error which you don’t want to see while doing upgrades – Missing MSI !

The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are trying to do a service pack upgrade or a CU update during a critical change window.  Here is what the error looks like  -

If you are hit with… Read more

0 comments, 191 reads

Posted in SQLSailor.com on 14 January 2014

Setting up the Min and Max Memory options on the fly – Word of caution !

Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left out with the default settings.But here is a quick word of caution around this -

Do you want to change these numbers on the fly randomly when there is good… Read more

0 comments, 206 reads

Posted in SQLSailor.com on 2 January 2014

Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !

I got motivated to write this post as there was a question on twitter which was like  -

The user was checking if there was a way to prevent procedures which are created with RECOMPILE hint.

I was pretty sure that Policy Based Management did provide us a Stored Procedure Read more

0 comments, 331 reads

Posted in SQLSailor.com on 12 November 2013

Memory Optimization Advisor – SQL Server 2014 CTP2

SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal tables to memory optimized tables.

Where can I find this tool ?

All you need to do is right click the table you want to migrate, and choose the option… Read more

0 comments, 317 reads

Posted in SQLSailor.com on 23 October 2013

Database Backup Encryption – SQLServer 2014 CTP2

SQL Server 2014 CTP2(All new,shiny shiny !) availability was announced yesterday at #SQLPASS Summit.

Native backup encryption is one of the key features which was announced with this release, and I’m sure this feature will be widely used.

Native backup encryption will encrypt the data while creating the backup, and… Read more

0 comments, 432 reads

Posted in SQLSailor.com on 17 October 2013

Microsoft + Oracle = New opportunity…Windows Azure is a happening place !

Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the cloud.

It was almost clear that Oracle was going to be available in Windows Azure under the IaSS platform(Virtual Machines’),and today during one of the Oracle Open World keynotes this… Read more

0 comments, 481 reads

Posted in SQLSailor.com on 24 September 2013

Windows Azure Service Dashboard – Checkout the health of Azure Services

Windows Azure Service Dashboard is an excellent way to know the health/availability of your Windows Azure Services.

You might always want to know if any of the service is down or having some performance degradation, and with windows azure service dashboard this information is just few clicks away.

All you… Read more

0 comments, 476 reads

Posted in SQLSailor.com on 13 September 2013

High Availability within Windows Azure VMs – An exciting opportunity !

Windows Azure Virtual Machines is a real game changer as it gives us ability to spin up VMs in no time to setup a full blown SQL Server.

The topic of High Availability(HA) will come to your mind in case you are planning to deploy a mission critical SQLServer on… Read more

1 comments, 419 reads

Posted in SQLSailor.com on 9 September 2013

Backup your Windows Azure SQL Databases – Yes,you should !

Care about RPO’s and RTO’s?  Then you should be backing up your Windows Azure SQL Databases(Formerly SQLAzure).

Windows Azure SQL Database is highly available and data is redundant(3 copies of your database is stored elsewhere),however that doesn’t help you to recover from the below situation  -

“Hey…

Read more

0 comments, 630 reads

Posted in SQLSailor.com on 19 August 2013

Deleting a Storage Account from Windows Azure – The right way !

I like to clean up things after I’m done with my testing and this morning I decided to clean up my VM’s, Databases which were created under Windows Azure.

Everything went smooth till I tried to delete my storage account. As soon as I tried a delete there was an… Read more

0 comments, 689 reads

Posted in SQLSailor.com on 11 July 2013

Monitoring Memory Usage of Memory Optimized Objects – SQL Server 2014

Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t run out of memory and cause real bad situations.

One way of ensuring that the memory optimized objects wont utilize a certain amount of memory is by setting up resource… Read more

0 comments, 438 reads

Posted in SQLSailor.com on 1 July 2013

Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud

You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.

If your on-premise desktop computer/laptop is running low on resources and if you don’t want to take the pain of handling multiple VMs locally,then you have an option to test… Read more

0 comments, 390 reads

Posted in SQLSailor.com on 26 June 2013

Installing SQL Server 2014 CTP1 – Step by Step

Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your fresh copy from here.

Here is the official announcement with some high level details.

In this post we will do a quick step by step walk through… Read more

6 comments, 1,209 reads

Posted in SQLSailor.com on 25 June 2013

Older posts