All Articles - SQL Authority with Pinal Dave

SQL SERVER – Life of a SQL Query – Query States

April 17, 2014

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…

SQLAuthority News – Microsoft Whitepaper – Idle Connection Resiliency

April 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL White Papers

Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but it’s not executing a command or waiting for data. It is very important to understand how idle connection is reconnecting back in the .NET framework…

SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database

April 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Earlier I wrote a blog post about how to Disable and Enable all the Foreign Key Constraint in the Database. It is a very popular article. However, there are some scenarios when user needs to drop and recreate the foreign constraints. Here is a fantastic blog comment by SQL Expert…

SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023

April 10, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database, SQL Backup and Restore

[Notes from Pinal]: Search on the internet about ‘Shrinking Database’, you will find plenty of advice why it is bad and it should not be done. If you do not believe me, just try it yourself. Even I have blogged about it before that it is an absolutely bad thing…

MySQL – Finding First day and Last day of a Month

April 9, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL DateTime

MySQL supports a lot of DATE and TIME related functions. If you want to find out last day of a month, you can make use of an inbuilt function named LAST_DAY. SET @date:='2012-07-11'; SELECT LAST_DAY(@date) AS last_day; The above code returns the value 2012-07-31 However, there is no inbuilt function…

SQL SERVER – What is SSAS Tabular Data Model and Why to Use it

April 8, 2014

Pinal Dave

SQL

SQL Analysis Services, SSAS

Analysis services in SQL Server 2012 can be either deployed in multi-dimensional mode or tabular mode or power pivot for SharePoint as well. Tabular mode is a new enhancement in SQL Server 2012 analysis service database structure. It is a columnar database capable of incredible performance and compression ratio. At this point, there is a lot of confusion in users on why to use the tabular model when we already have multidimensional model.So, let’s discuss these points first before creating a tabular model project. Let us learn about the SSAS Tabular Data Model.