Modulo!

I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...

MongoDB – How to Copy Database

Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...

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...