Dinesh's Blog :::: Being Compiled ::::

In a continuous running SQL Server environment, it is not uncommon to see a large error log related to SQL Server that is continuously gro...

Last year, I wrote a post on number of data files on tempdb, whether we want multiple files, then how many files should be added, what wou...

This is something I noticed during installation of SQL Server 2016 CTP 3.2. Not sure whether this was available with all the versions of C...

This is not about reports created with Matrix data region, so no column headers. And this may not relevant to latest version such as Repo...

This post is written by  Olek Nilson . Database disaster prevention is one of the greatest pains in life of every DBA. Data from databas...

This is not a new issue, it has been there for long time but it still appears in the forum and we still experience it. One of the issues I...

Let's talk about accounts that can be assigned to the services related to SQL Server and how they can be assigned or changed later. Si...

Data Mining or Machine Learning is not something new, it has been there for years and many have used it for various types of analysis and ...

If the development tool does not support creating the connection via an interface, if it needs manual entry for the connection string, and...

This is nothing new or related to latest which is SQL Server 2016 Reporting Services. But I think it is still important to blog on it as t...

This week's Interview question is based on SQL Server Reporting Services. Just like other applications hosted, Reporting Services requ...

Have you ever come across a situation where you cannot see/find the  rsreportserver.config file related to Reporting Services? You are...

A database server without a backup strategy is a disaster and if you have no strategy implemented, you invite for troubles. However this t...

SQL Server Reporting Services allows us to export the opened report into different formats such as Excel and Word. When exporting into Exc...

One of the greatest searching facility provides by database management system is full-text search.  This was available even with Microsoft...

Reporting Services allows us to author reports consuming heterogeneous data sources and one which is optimized for data retrievals; Data M...

Big Data is not a new term for anyone now and the definition of it with widely-known 3 Vs or 3 main attributes has already been discussed ...

Here is the first question of the year and this something related quotes we used with TSQL. Have a look on below query. It refers Person.P...

The most friendly database tool, Management Studio was released with SQL Server 2005 and it has become the right-hand for both database ad...

There are many ways of collecting statistics of SQL Server such as CPU usage, IO made, reads and writes. One facility given by SQL Server ...

We either author or consume reports which makes us a part of some Reporting Scenario . Regardless of the activities users perform, users c...

This is based on a question I was asked today on concurrent connections. For running some procedures and making sure that no one can access...

While I was writing some Hive queries for getting words from a lengthy string, I came across a useful extended stored procedure that allo...

My first post related to GUID discussed the main issue we face when using GUID as the key, specifically as the Clustered Key . Here is ano...

Deleting records is a very common activity performed against databases and everyone is familiar with DELETE statement. Here is a question b...