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

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, 541 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, 484 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, 720 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, 541 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, 644 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, 593 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, 836 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, 865 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, 599 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, 541 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,632 reads

Posted in SQLSailor.com on 25 June 2013

Moving a database from on-premise to the cloud – Step by Step Walkthrough

Cloud is the future and moving there is now as easy as few mouse clicks.

Today we will see how an On-premise database can be moved to a SQL Server instance running up on a Windows Azure Virtual Machine.There are multiple ways to accomplish this and in this post… Read more

0 comments, 591 reads

Posted in SQLSailor.com on 21 June 2013

Windows Azure pay per minute – Time is money !

One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing model for Windows Azure is going to be per minute basis from now on, then there was a great cheer from the crowd.

This is indeed a game… Read more

3 comments, 359 reads

Posted in SQLSailor.com on 4 June 2013

SQL Server 2014 – A new and exciting journey !!! “Into the cloud”

Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.

This version of SQLServer is indeed a reflection of Microsoft’s vision towards the future computing. A bright and colorful ”In to the Cloud” future !

The journey of SQLServer from SQL2000 –… Read more

0 comments, 691 reads

Posted in SQLSailor.com on 3 June 2013

Have you configured Database Mail to utilize multiple SMTP Accounts ?

Lets start discussing about this subject by closely looking at the term Redundancy.  What is redundancy all about ?

Wikipedia defines redundancy as “In engineering, redundancy is the duplication of critical components or functions of a system with the intention of increasing reliability of the system, usually… Read more

0 comments, 1,330 reads

Posted in SQLSailor.com on 24 May 2013

Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Today I will talk about a book  titled  ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

When I first heard that Ed Wilson is writing a book on Windows PowerShell I was greatly excited. I am a great fan of PowerShell and by all means… Read more

0 comments, 437 reads

Posted in SQLSailor.com on 23 May 2013

SQLSaturday Redmond(SQLSat212) – A quick recap !

That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds and learned something new.

It all started with a wonderful keynote by Buck Woody(B/T),and he delivered quite an interesting talk on SQLServer history. A journey… Read more

0 comments, 326 reads

Posted in SQLSailor.com on 20 May 2013

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting, and shake hands with those people who are really passionate about SQLServer.

SQLSat212 has got some good sessions and I’m looking forward to have a great time… Read more

0 comments, 292 reads

Posted in SQLSailor.com on 16 May 2013

The Activity Monitor is unable to execute queries against the server !

I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check some processes details and opened Activity Monitor after a long long time.

Straight away I was struck with this error.

By using the ‘Show Technical Details’ button I tried to… Read more

2 comments, 1,657 reads

Posted in SQLSailor.com on 2 May 2013

Linked Server created using a script is missing Product name and Data source fields !

Today I will discuss about an issue which was observed while creating a linked server via script.

The existing linked server was scripted out from a SQL2005 instance and the same script was used to create a linked server under a SQL2012(SP1/CU2) instance.

This a common procedure to follow… Read more

0 comments, 529 reads

Posted in SQLSailor.com on 19 April 2013

Newer posts

Older posts