All Articles - SQL Authority with Pinal Dave

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

April 20, 2014

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…

SQL SERVER – Idera SQL XEvent Profiler – a Free Tool for XEvent Monitoring

April 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Idera, SQL Extended Events

Download Extended Event Profile FREE We often resist the change, we do not like change and we keep on using the same old technology which we have been using it to resolve the new challenges which we face in our daily life. The Extended Event is such a technology as…

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024

April 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SQL Scripts

[Note from Pinal]: This is a new episode of Notes from the Fields series. AlwaysOn is a very complex subject and not everyone knows many things about this. The matter of the fact is there is very little information available on this subject online and not everyone knows everything about…

SQL SERVER – Life of a SQL Query – Query States

April 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Confio, SQL Wait Stats

This is the guest blog post written by James Davies, Sales Engineer, Confio Software, a SolarWinds company. It is written based on the Database Performance Analyzer. I encourage you to download it for free from here. From the moment a query request is made until the query response is delivered,…

SQL SERVER – Calculating XIRR in SQL Server – Internal Rate of Return Available

April 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Note: Download the XLeratorDB to play along this blog post. XIRR is a widely-used used financial calculation that lends itself to evaluating the rate of return on either historic cash flows or anticipated future cash flows. Thus it is a tool that can be used to measure investment performance or…

SQL SERVER – Three Questions – Do You Know Your Servers? – Book Gift

April 15, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Book Review

It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small group of people. It was very intriguing to see that…

SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized

April 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL DMV

Four years ago, I wrote a blog post SQL SERVER – Finding Last Backup Time for All DatabaseDatabase – Last Full, Differential and Log Backup. Well, in technology, there is always space for improvement and we should always be ready to learn and progress. SQL Expert TheSQLGuru came up with…

SQLAuthority News – Microsoft Whitepaper – Migrating Content Between Report Servers

April 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL White Papers

A very common challenge developer and administrator face when they have to migrate content between SQL Server Reporting Server. This is because SQL Server Reporting Services (SSRS) currently doesn’t include a feature for migrating content items and settings from one Reporting Services report server to another report server. There are…