SQL Azure Reporting.
SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF
Most of us use those statements while creating stored procedures and functions. most of us don’t know what is the significance of those statements and how they are useful.
SET QUOTED_IDENTIFIER ON/OFF
Understand Response Time vs. Total Time in SQL
Response time is the time it takes for a query to return the first record. Total time is the time it takes for the query to return all records. For an interactive application, response time is important because it is the perceived time for the user to receive visual affirmation that a query is being processed. For a batch application, total time reflects the overall throughput. You have to determine what the performance criteria are for your application and queries, and then design accordingly.
Get a comma separated list in SQL & MDX.
Sequence Vs Identity – SQL Server 2012
What is sequence?
Sequence is a newly introduced database object in Sql Server 2012, Sequence is used to generate a sequence of numeric values in either ascending or descending order, along with an option to have the minimum and maximum values and also allows to cycle and cache for better performance.
Change the Look & Feel of the Report Manager.
Why we need to change the Look & Feel of the Report Manager?
Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager. Read more…
Introduction and Installation of Data Quality Services for Denali
Data Quality Services (DQS) enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling
DQS is not installed automatically with Microsoft SQL Server Denali CTP3. You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…
SQL Azure Database Take Offline
As everyone knows that database administrator can take SQL Server Database offline for maintenance purpose with following command Read more…
SQL+MDX in one Apartment (Hybrid Query).
Powershell – Powershell Script to backup all user DBs in SQL Server
Powershell is Microsoft’s task automation framework.
The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 