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 many statements in your database code have been...

MongoDB – Drop database

The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database

Method 1:
1. select the database...

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

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...

MDF File Password Confusion

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...

MongoDB -Get Size, RowCount, CollectionSize

There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...

SSC Editorial: Would You Move for a Job?

I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...

FIND OBJECTS BEING REFERRED BY SSRS REPORT

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...