The Next Chapter ~ A SQL Journey

The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....

Upcoming Speaking Engagements

The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...

XP_CmdShell isn’t Evil

Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...

Awesome SQL Server Feature

There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life...

Awesome SQL Server Feature

The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...

Implementing Full-Text Indexes

In my previous blog we saw the Full-Text Index architecture. 

http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html

In this blog we shall see its implementation. Before you proceed...

MongoDB – List All the databases

The function getDBs() function returns all the database list
db.getMongo().getDBs()
The runCommand is a special type of query called a database command and...

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+

What is code coverage?
Code coverage is a way to see how...

SSRS 2016 then SQL Jeopardy! tonight at BRSSUG!

See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group...

Build database schema snapshot functionality into your .NET application

If you wish to build your own .NET application that allows the user to take database schema snapshots on demand or schedule them to be taken at certain times,...