Sunday, July 17, 2016

SQL Server Brain Basher of the Week #047 - Database diagram

›
This is something I asked during an interview. While we were talking about system databases, I questioned interviewee that how get informa...
Sunday, July 10, 2016

SQL Server Brain Basher of the Week #046 - Default Database Size

›
You may or may not have noticed the initial size of the database at creation but there is a fixed size for both data and log files. Most o...
Friday, July 8, 2016

Conformed dimensions and Stovepipe data marts

›
Long time back, I wrote a small note on Stovepipe data marts, thought make a blog post again on it as it is still unknown to many. The sim...
Thursday, July 7, 2016

Azure SQL Database - Cannot connect to database.windows.net.

›
Are you experience this error when trying to connect with your Azure SQL Database? TITLE: Connect to Server ----------------------------...
Wednesday, July 6, 2016

SQL Server Backup to URL - Now easier than before

›
I made a post on  SQL Server Backup to URL that describes how to take a backup to URL. Earlier, this needs the credential created before ...
Tuesday, July 5, 2016

SQL Server Management Studio July 2016 is available

›
Good thing is we get continuous releases for Management Studio. Microsoft has released the newest version of SQL Server Management Studio ...
Monday, July 4, 2016

SQL Server Query Editor with Query Window

›
Some prefer write the TSQL statement without a help from an editor but some prefer to use an editor because it simply allows us to select ...
Sunday, July 3, 2016

Scaling out the Business Intelligence solution

›
In order to increase the scalability and distribute workload among multiple servers, we can use a scale-out architecture for our DW/BI sol...
Saturday, July 2, 2016

Connecting to the Integration Services - "Access is denied."

›
If required permissions are not configured for Integration Services for your account, you will experience following error when trying to c...
Friday, July 1, 2016

SQL Server 2016 Sample Database - Wide World Importers- Restoring and adding more records

›
We have been using Adventure Works database with almost all versions of SQL Server and no questions, it can be used with SQL Server 2016 a...
2 comments:
Sunday, May 29, 2016

SQL Server Brain Basher of the Week #045 - Stored Procedure or Function

›
A question related to Stored Procedure  is very common during an interview and many get stuck with it when it has to be discussed in detai...
Saturday, May 28, 2016

Browsing internet inside SQL Server Management Studio

›
How often you google or bing on technical issues while developing modules with SQL Server? For me, it is quite often as I always do search...
Friday, May 27, 2016

SET ROWCOUNT overrides TOP?

›
While I was going through an implemented set of codes, I noticed that ROWCOUNT is heavily used (of course, it is an old implementations) a...
Wednesday, May 25, 2016

SQL Server SESSION_CONTEXT function - SQL Server 2016 Enhancements

›
If you are a web developer and have worked with Classic ASP or ASP.Net, then you know that how important it is for maintaining Session Var...
Monday, May 23, 2016

Creating HDInsight Hadoop Cluster using SSIS and processing unstructured data using Hive Task - Azure Feature Pack - Part II

›
With my previous post  Creating HDInsight Hadoop Cluster using SSIS and processing unstructured data using Hive Task - Azure Feature Pack ...
Sunday, May 22, 2016

SQL Server Brain Basher of the Week #044 - Reporting Services

›
Let's talk about something related to Reporting Services. You are asked to install and configure Reporting Services in one of the serv...
Saturday, May 21, 2016

Creating HDInsight Hadoop Cluster using SSIS and processing unstructured data using Hive Task - Azure Feature Pack - Part I

›
A fully-fledged Business Intelligence system never ignore unstructured data. The reason is, you can never get the true insight without con...