Today, I’d like to examine how in-memory OLTP engines to vastly improve performance and scalability of SQL Server databases and to accelerate applications. A very large part of this article focuses specifically on SQL Server 2014 and its new In-Memory OLTP capabilities.
SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk
For any DBA there are three most important resources – CPU, Memory and Disk. Here is a real life story just happened recently which discusses CPU, Memory & Disk along with a new manager and frustrated employee. Well, thanks to Dell Software’s Spotlight on SQL Server Enteprise, the story has a happy ending. Trust me, you will enjoy this mini story, so continue reading.
SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner
There are few feelings which are hard to describe in words as this note is about an amazing event on the C Sharp Corner.
SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP
Earlier this week, I was presenting at Great Indian Developer Summit in Bangalore. Lots of people were interested in the subject of In-Memory OLTP database. Everybody wanted to know how to do, use the new features of In-Memory OLTP feature. Microsoft has recently released two white paper which discusses about…
Read MoreSQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
I have been reading this Whitepaper from a couple of days and I am yet not done reading it completely, but I think it is one of the best white papers I have read in the recent time. First of all, it is written by my friend and SQL Expert…
Read MoreSQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts – Part 2
Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today. If you are not going to attend this event, sign up for the newsletter over here: https://blog.sqlauthority.com/contact-me/sign-up/. I will be sharing my code, demo, slides and all…
Read MoreSQL SERVER – Database File Names and Extentions – Notes from the Field #025
[Notes from Pinal]: People believe Shakespeare’s birth date is on April 26. ” What is there in a name?” – I often hear this statement, which famously quotes from Shakespeare. I think we developer believe in this statement as most of our various are either BAR or FOO. However, this…
Read More
Data Science: A Step Forward from Business Intelligence – Data Scientist
Who can predict which customer is going to cancel a newspaper subscription before it actually happens? It’s a Data Scientist.
SQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts
Today I will be presenting two sessions at Great Indian Developer Summit. Here is the details about where I will be during today. If you are not going to attend this event, sign up for the newsletter over here: https://blog.sqlauthority.com/contact-me/sign-up/. I will be sharing my code, demo, slides and all…
Read MoreSQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest
The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presenting total four sessions at this event and each session is very different from each other. Event Location: J. N. Tata…
Read More