Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and […]
administration / Database / MSSQL / TSQL
An Overview of the tools SQL Server database professionals use
Recently I was asked what tools database professionals use and I wanted to clarify a little bit on the topic so here goes. Previously we used to have […]
Getting all values when input parameter is NULL and still get IX seek behavior!!
Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in […]
Cannot get the column information from OLE DB provider
Cannot get the column information from OLE DB provider “Microsoft.Ace.OLEDB.12.0” for linked server “(null)”. Encountered this little gem while performing a migration today. Turns out the SQL Server […]
administration / Database / MSSQL / TSQL
What do indexes really look like?
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 […]
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 […]