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

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

0 comments, 342 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

0 comments, 542 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, 238 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, 5,137 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, 6,662 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, 8,551 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

0 comments, 6,347 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, 232 reads

Posted in SQLSailor.com on 10 November 2014

#SQLPASS #Summit14 Day 1 Keynote Highlights !

PASS President Thomas LaRock on stage !

PASS President Thomas LaRock kicked off the summit keynote.

 

Tom talked about the history of PASS and its growth curve. Positive numbers all over the place !

One of the key things to note is that PASS has delivered 1.3 million hours… Read more

1 comments, 257 reads

Posted in SQLSailor.com on 5 November 2014

My 1st SQL in the City Experience !

I attended my 1st #SQLinthecity event hosted by RedGate yesterday. This is one of those events which I wanted to attend for a long time, and I’m glad I could make it this year.

Attendees registering for the event

This whole day event was packed with some cool sessions, and… Read more

3 comments, 422 reads

Posted in SQLSailor.com on 5 November 2014

SQLPASS Summit 2014 is here, The largest SQLServer Conference !

November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when #SQLPASS Summit happens.

SQLPASS Summit is the largest SQLServer conference in the world, and this year the number seems pretty huge with over 5000 attendees !

#Summit14 will be my… Read more

5 comments, 180 reads

Posted in SQLSailor.com on 3 November 2014

Checking out Windows Server Technical Preview on Azure !

I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to push the latest and greatest windows server builds along with latest SQLServer builds because of many reasons (That can be a whole different post altogether).

I was all excited when… Read more

0 comments, 5,593 reads

Posted in SQLSailor.com on 4 October 2014

SQLServer 2008 R2 SP3 released, Now its testing and deployment time!

As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and patch all the existing SQLServer 2008 R2 to this latest build.

SP3 will be the last and final service pack for SQL Server 2008 R2 ,and it will be a… Read more

0 comments, 352 reads

Posted in SQLSailor.com on 29 September 2014

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, 6,951 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, 265 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,367 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, 2,017 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

6 comments, 8,874 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,438 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

2 comments, 731 reads

Posted in SQLSailor.com on 6 February 2014

Older posts