We all have seen the traditional diagram that represents a B-Tree and I am sure we all resort to it when we try and explain how a B-Tree […]
administration / Database / MSSQL / TSQL
Creating, Configuring and Querying DocumentDB in Azure
DocumentDB is a NOSQL JSON based data store available in MS Azure. In this post we cover how to create a document database followed by a Collection and […]
The jumpy mouse problem solved using XE
I have a mouse (the real one that we connect to our laptops not the fake one that runs around after cheese :-p) that jumps all over my […]
administration / Database / MSSQL / TSQL
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 […]
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 […]
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 […]
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 […]
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 […]
administration / MSSQL / TSQL
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 […]
administration / Database / MSSQL / TSQL
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 […]