All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP

April 27, 2014

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…

SQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

April 26, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Statistics

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…

SQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts – Part 2

April 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

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: http://bit.ly/sqllearn. I will be sharing my code, demo, slides and all…

SQL SERVER – Database File Names and Extentions – Notes from the Field #025

April 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[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…

Data Science: A Step Forward from Business Intelligence – Data Scientist

April 23, 2014

Pinal Dave

Big Data

Business Intelligence

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

April 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

SQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest

April 21, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

GIDS, MySQL

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…

SQL SERVER – Download SQL Server 2014 Developer Edition at USD 59.59

April 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database

Since the release of the SQL Server 2014 earlier this year, lots of people have been asking if people can download the full version of SQL Server 2014. SQL Server 2014 full version is not available for FREE. You have to either get standard version or enterprise version. You can…

SQL Authority News – Microsoft Whitepaper – SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

April 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Download, SQL White Papers

Microsoft has released SQL Server 2014 earlier this month and now have released very long but interesting white paper on Windows Azure Blog Storage Services. SQL Server Data Files in Windows Azure feature is available in all editions of SQL Server 2014. This feature is enabled by default and at…

Developers – Drive by Daniel Pink – Book Review

April 19, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

MySQL, SQLAuthority Book Review

I have been an avid reader of books. I read pretty much one or two books every week. I believe reading helps me a lot in my day job as well as well writing blog post. I am an evangelist and my primary responsibility is to spread the love for…