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
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
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
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.
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
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.
This whole day event was packed with some cool sessions, and… Read more
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
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
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
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
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
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
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
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
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
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
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
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
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
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