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 […]
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 […]
administration / Database / MSSQL / TSQL
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, […]
administration / Database / MSSQL / TSQL
How to troubleshoot MS SQL Server – Part 2
In this post we carry one from where we left off in the first part. Since we discussed what the L1 DBA (resident) should try and do when […]
administration / Database / MSSQL / TSQL
Auditing via the T-log
A client of mine recently wanted to find out who deleted all the records from a table being used in production. This is an issue that we have […]
administration / Database / MSSQL / TSQL
How to troubleshoot MS SQL Server
I am sure the title must have piqued the interest of most DBAs since this is what we do every day. It’s also one of the most common […]
administration / MSSQL / TSQL
SQL 2016 – Temporal Tables the way we are most likely to end up using it
In this post I am quickly going show how to convert the existing tables into temporal tables. This is a common requirement I expect we will all encounter […]