T-SQL, SQL Server BI Articles Link List – June 2011

Here’s a quick wrap up of the articles published on SQLServerCurry.com in the month of June 2011

T-SQL Articles

FLOOR a DateTime in SQL Server - Suppose you are given a datetime and want to emulate the FLOOR function on it eg: find first day of year, first day of month etc, you can use the code shown in this post.

Standard Deviation in SQL Server and Aggregation on Aggregates - SQL Server makes calculation of Standard Deviation relatively easy with the STDEV statistical aggregate function. What I learnt recently was that you can either apply this function to all values or can even select distinct values. You can also perform an aggregation on aggregates that can be used in reports

SQL Server: Calculate Summary and Column Summary - This post shows how to show a summary of similar rows as well as column summary for SQL Server table data. Suppose you want to generate the total of a column and display it at the end of the result set.

SQL Server Tutorials on Date Time - One of the most frequently asked question by SQL developers, is on handing Date, Time and other related datetime values in SQL Server. Developers are always looking out for solutions which demand either converting Date Time Values or finding date time ranges and so on. Madhivanan and I have already written a couple of articles on handling DateTime in SQL Server. In this post I will share some of the links with you.

SQL Server: Grouping ID Example - Let us suppose you have used the rollup operator to generate summary information along with the Details information and you now want to differentiate between summary and detail. You can make use of the SQL Server grouping_id function. Let us understand the GROUPING_ID function using some code.

SQL Server BI

SSIS Balanced Data Distributor Transform - The Balanced Data Distributor (BDD) is a new SSIS transform which takes a single input and distributes the rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion.

Dynamic Connection String in SQL Server Reporting Services 2005/2008 - In this post we will see how to generate a report using dynamic connection string in SQL Server Reporting Services 2005/2008. The scenario is if we have different data with the same schemas, spread across different database and different SQL servers and people would like to see the data as per their preferences (like area wise), we can use a Dynamic Connection string.

SQL Azure Migration Wizard - For those who do not know about this tool, the SQL Azure Migration Wizard is an open source tool that helps you migrate your SQL Server 2005/2008 databases to and from SQL Azure. The tools analyzes your database for any compatibility issues and allows you to either fully or partially migrate your database schema and data to SQL Azure.

SQL Server Driver 2.0 for PHP 5 - Microsoft recently released SQL Server Drivers for PHP 2.0 which adds support for PDO with a new PDO_SQLSRV and contains bug fixes for the existing SQLSRV driver. The native APIs present in the PHP Driver for SQL Server 1.1 are still present, there is additional support for the PDO API.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.