Using Openrowset to import data from a CSV file

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…

A few more free e books

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

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…

Video on Memory Optimization for SSIS packages

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…

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

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…

What is a PK?

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…

Session State request to session state server

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…

What’s in a name? Mdf = pdf

“What’s in a name? That which we call a mdf file By any other name would work as well.” At a training recently I was asked this question, “How many additional mdf files can a database have?”. We all know that it can have additional (ndf) secondary files and log files but what about the…