Tags » SQL Tips And Tricks

SQL SERVER - Life of a SQL Query - Query States

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… 532 more words

SQL Authority

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

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. 1,476 more words

SQL Authority

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

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. 156 more words

SQL Authority

SQLAuthority News - Microsoft Whitepaper - Migrating Content Between Report Servers

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. 122 more words

SQL Authority

SQLAuthority News - Microsoft Whitepaper - Idle Connection Resiliency

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. 281 more words

SQL Authority