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

Here is the this week Brain Basher. How many partitions can be created per table or index with SQL Server 2014? 1) 256 2) 1,000 ...

Unlike database restore operation, SQL Server allows us to take a backup of our database while it is being used, placing some insignifican...

SQL Server uses at least two files for maintaining a database: a data file (extension mdf) and a log file (extension ldf). If the database...

It is not something unusual to be seen, most of us, during the installation of SQL Server, most of the components of SQL Server are instal...

All your queries are satisfied using pages in the buffer pool (memory), not pages in the disk. SQL Server loads required pages from the di...

Log truncation is the process of freeing space in the logical log for reusing the space for new transactions. Depend on the database setti...

Here is the question for the week; Can I name my Named Instance as MSSQLServer ? Generally, when we install SQL Server as a named i...

SQL Server Browser Service is one of the services installed when SQL Server is installed. Generally this service is required to be running...

Here is the session I delivered for FITIS, Sri Lanka.

I have seen many ways of formatting a number related to month, day, hour, minute to two digits number. It is all about checking whether th...

I wrote a post on Hive ( What is Hive, What is Hive Database, What is Hive Table? ) discussing key elements of Hive. If you want to try wi...

Here is the Brain Basher of the week. It is related to Database Administrators but even if you are Database Engineer, it is very important...

Microsoft SQL Server Management Studio 2015 June Preview  is available for downloading. This comes as a separate installation, not as a pa...

Installing multiple copies of SQL Server on a single machine is not uncommon but it is not recommended in production environment. The copy...

When I go through Apache Software Foundation, most attractive and most relevant projects I see for me are Hadoop and Hive. Hadoop is an op...

What if you get duplicate values from a dimension that is going to be used for loading a Reporting Services parameter? Generally, you do n...

If we need get Top n  records from a relational database table, we simply use SELECT TOP (n)....  But how do you do the same with Multi-di...

If you have read my previous post " SQL Server: Locking cost, concurrency cost and concurrency issues [Discussion on Transactions - I...

Continuing notes related to the discussion.... Another area that was discussed is, how SQL Server places locks for transactions and wh...

Hadoop is no longer a new word, everyone knows it and everyone knows why we need it. During my last two presentations, I explained Hadoop ...

This is the continuation of the post I made: Understanding transaction properties with Microsoft SQL Server. During the same discussio...

I had a chance to discuss an old topic with few of my colleagues, it was on transactions and isolation levels. Although it is old, well kn...

** The latest article on this based on RC3 is available as  SQL Server 2016 - Manipulating data in Azure Storage using PolyBase . Polyba...