SQL Tips and Tricks Archives - Page 183 of 536 - SQL Authority with Pinal Dave

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

April 17, 2014

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…

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…