Monthly Archives: February 2016

Using Openrowset to import data from a CSV file

By | February 25, 2016

If you are using a 64 bit edition of Windows then you are most likely using a 64 bit edition of Office and as a result of Access too. If you however have a 32 bit version of Office installed you will face issues when trying to create an openrowset connection to a csv file… Read More »

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

Loading Resumes and searching them using SQL Server – Part 2/2 (PDF+ FileTable + Full Text Search)

By | February 21, 2016

In this post we continue after creating our file table and posting some pdf documents into it. For the previous post please click here. Apparently there is very few content about how to achieve this so I am going to be as thorough as possible here. First we need to download the filters that help… Read More »

Loading Resumes and searching them using SQL Server

By | February 12, 2016

Recently I came across a requirement where we needed to load Resumes into SQL server and then search these documents for specific keywords. Important things to keep in mind included the use of SQL 2014, the resumes were in PDF format and the IO needed to be efficient. In this series of blogs I will… Read More »

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 »

Chinese Hackers(Cracker) and Azure, have I hit the bigtime??

By | February 11, 2016

I have a website hosted on Azure which I use for my trainings. Today I received a number of alerts from Azure showing High CPU usage for the Service in question. After investigating the error logs it seems it was Brute for attack for the database. The IP address of the attack is Chinese but… 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 »

Very large table performance – basic data capture

By | February 5, 2016

Every once in a while I see a post on the forums that is similar to the one below:- Hi Can anybody provide tips on how to improve performance on a very large table, the table has 20 million rows in it. Thanks Most of the first 10 replies are basically just people asking for… 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 »