Wednesday, October 28, 2015

Loading data from Microsoft SQL Server to DocumentDB in Azure

›
WIth my previous post ( How to create a DocumentDB in Azure ), I mentioned that there are multiple ways of loading documents into Document...
Tuesday, October 27, 2015

How to create a DocumentDB in Azure

›
Microsoft implementation of NoSQL database, documentDB is a cloud based, fully managed, massively scalable service for managing semi-struc...
Thursday, October 15, 2015

What is NoSQL Document Database? What is Azure DocumentDB?

›
NoSQL databases are not something recently introduced, it was another type of model that was discussed with relational database management...
2 comments:
Tuesday, October 13, 2015

Reporting Services report does not show all lables in X-Axis

›
Assume that you have a dataset and you have configured a clustered bar chart with it using Reporting Services. Based on number of elements...
Monday, October 12, 2015

SQL Server Brain Basher of the Week #033 - Cartesian Product

›
SQL statements produce various types of results and forming the result is based on the way the query has been written. This week brain bas...
Sunday, October 11, 2015

SQL Server 2016 CTP 2.4 is available for downloading

›
Microsoft has released SQL Server 2016 Community Technology Preview 2.4 and we can try this in our test environment. Many new great featur...
Saturday, October 10, 2015

History of Database Management Sysytems

›
No doubt, we all are familiar with relational database management systems, structure and components of it. But do you know how this was st...
Friday, October 9, 2015

Types of Database End Users

›
There are distinct types of people who engage with database management system and End Users   are well known. However, when referring End ...
Monday, October 5, 2015

SQL Server Brain Basher of the Week #032 - TSQL - Converting from one value to another

›
With T-SQL queries, converting data between data types is very common. Conversion can happen automatically (implicitly) or we can take the...
Sunday, October 4, 2015

SQL Server Error Severity Levels

›
Have you ever read the Severity Level  indicated with an error occurred? Or just tried to find out the problematic code exist in your code ...
Saturday, October 3, 2015

Getting an email notification when a deadlock is occured

›
If you are administering a heavy transactional database and often facing an issue with incomplete transactions, deadlocks might be the iss...
Wednesday, September 30, 2015

SQL Server 2014 and 2012 new releases

›
Microsoft SQL Server team has done few releases related SQL Server 2014 and 2012 in last few months. You can download and upgrade your inst...

SQL Server Management Studio - September 2015 Release

›
The latest Preview of Microsoft SQL Server Management Studio is release and it can be downloaded from; https://msdn.microsoft.com/en-...
Monday, September 28, 2015

SQL Server Brain Basher of the Week #031 - SQL Server Editions

›
Many have been working with Microsoft SQL Server for years and most have worked with either Enterprise or Standard edition. Here is a ques...
Saturday, September 26, 2015

Configuring HDInsight Hadoop Cluster and running a sample MapReduce Job

›
Apache Hadoop is an open source solution for distributed data processing and storage that consists a cluster of servers for holding data, ...
Tuesday, September 22, 2015

Loading Power Query data to Power Pivot: Power Query Default Query Load Setting

›
This concern can be seen everywhere, why my Power Query data sometime appears in Power Pivot but sometime does not appear in Power Pivot? ...