Monthly Archives: February 2016

A few more free e books

By | February 23, 2016

A few more free e-books for the SQL DBA. This from REDGATE and some of the most prolific writers and SQL Experts in the world. I am sure anybody working on SQL for more than 1 years has heard of REDGATE and most are aware of the tools and few about the books too. https://www.red-gate.com/community/books/#sqldev

Video on Memory Optimization for SSIS packages

By | February 12, 2016

Improving RAM Utilization within SSIS packages using data types. In this video we explore the impact of incorrect data types on how SSIS allocates RAM and the simple and easy fix to the problem. This video demonstrates how using the incorrect datatypes causes SSIS to overestimate the amount of RAM needed and as a result… Read More »

Airline On-Time Performance and Other Stats

By | February 9, 2016

Recently I came across the website for the Bureau of Transportation and downloaded the Airline on Time performance data for the last 3 years. Below is a snapshot of some of the information derived using this data? After verifying the data with other sources on the internet I can say that we have got most… Read More »

What is a PK?

By | February 7, 2016

Recently someone posted a question on one of the popular groups on Linkedin about one of the most fundamental structures in RDBMS the PK. It was followed by a number of comments and while all the comments were essentially saying the same old things we all know about the PK , it wasn’t being said… Read More »

Session State request to session state server

By | February 2, 2016

Problem Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.  If the server is on a remote machine, please ensure that it accepts remote requests by checking the value of HKEY_LOCAL_MACHINE|SYSTEM|CurrentControlSet|Services|aspnet_state|Parameters|AllowRemoteConnection.  If the… Read More »