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…
Month: February 2016
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 – Part 2/2 (PDF+ FileTable + Full Text Search)
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…
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…
Very large table performance – basic data capture
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…
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…