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

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, 411 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,291 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, 459 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, 310 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, 590 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,207 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, 384 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, 293 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, 253 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,437 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, 396 reads

Posted in SQLSailor.com on 19 April 2013

SQLServer Log Shipping Work File ! What is this all about ?

A short and sweet post for a gorgeous morning -

Have you seen a file with extension .wrk in the log shipping copy folder ?

What is this all about, Curious? Then here is the answer -

When the transaction log backup files are copied from the primary server to… Read more

0 comments, 1,028 reads

Posted in SQLSailor.com on 29 March 2013

CU3 for SQL2012 SP1 – Couple of interesting hotfixes.

Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412

Similar to CU2 there are some interesting hotfixes which are included in this CU release, and its worth testing it out.

The ones which attracted my attention are -

2800013

(http://support.microsoft.com/kb/2800013/…

Read more

2 comments, 751 reads

Posted in SQLSailor.com on 21 March 2013

Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !

CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have found this very much needed for all my SQL2012 SP1 deployments. This CU contains a very important fix(KB2793634).

Note - The choice to deploy CU2 or just the fix (KB2793634)… Read more

2 comments, 1,418 reads

Posted in SQLSailor.com on 15 March 2013

Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !

Adding a linked server is an easy task which can be done at any point of time. I was under this same assumption until I came across a strange scenario.

Here is the scenario for you all.

Use SSMS to create a New Linked Server and choose provider as ‘Oracle… Read more

1 comments, 1,548 reads

Posted in SQLSailor.com on 13 March 2013

Get Database information in mail using PowerShell !

Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would you love to get a report which will help you maintain and manage your large shared SQLServer environments neat and clean?

If your answer is Yes, then powershell is your… Read more

4 comments, 610 reads

Posted in SQLSailor.com on 26 February 2013

Check the version of Windows Installer !

This post is a quick tip to find the version of Windows Installer installed on your box.

You might wonder why I ever need to check this version, so here is my small story -

Today I was installing SQLServer 2008 Upgrade advisor for a Windows Server 2003(SP2) box(Pretty old… Read more

0 comments, 465 reads

Posted in SQLSailor.com on 9 February 2013

Quick alert on servers which are not compliant for policies set using PBM

Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.

Policy based management(PBM) is indeed one of my favorite features. I normally like to play around exploring more and more about it, and eventually end up learning something new(Yay!). Read more

0 comments, 313 reads

Posted in SQLSailor.com on 6 February 2013

Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring

Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new databases which gets created will have page verify = checksum as this option is inherited from the model database.

NOTE – APPLICABLE FROM SQL2005 AND ABOVE.

SELECT name,page_verify_option_desc FROM…

Read more

2 comments, 529 reads

Posted in SQLSailor.com on 17 January 2013

DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts

This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the node Process/System counters.

This is one area to look at under DBCC Memorystatus output to get a quick snap shot of the current state of memory and understand if… Read more

0 comments, 1,186 reads

Posted in SQLSailor.com on 11 January 2013

Newer posts

Older posts