Those who are following me on Twitter and Facebook know that recently I am reenforcing my own concept for SQL Server Analysis Services (SSAS). Like many of us, I worked with Analysis Services in early years. In an earlier job, I got many projects for relational database performance tuning and over time, I lost touch with SSAS. This does not mean that I forgot all of the concepts but the ‘real’ hands-on experience was gathering dust. Looking back at the last five years, I realized that I have deep experience with relational performance tuning but there are a few new things which I have yet to explore and learn.
SQLAuthority News – Latest expressor Data Integration Platform Posts
Here is the quick summary of my recent blog post which I have written while I am experimenting expressor data Integration platform. SQL SERVER – Introduction to expressor 3.4 Lookup Tables In this blog post, I am going to take a closer look at expressor’s new and extremely versatile implementation…
Read More
SQL SERVER 2012 Functions – 14 New Functions – A Quick Guide
Last two weeks I wrote various blog posts on new functions introduced in SQL Server 2012. So many comments and request I have received from various readers that they would like to see everything together. I have put up a quick guide here where I am writing all the 14 new SQL Server 2012 Functions linking them to my blog post as well Book On-Line for a quick reference.
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
In SQL Server Denali, seven new datetime functions have been introduced, namely, DATEFROMPARTS (year, month, day) DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision) DATETIMEFROMPARTS (year, month, day, hour, minute, seconds, milliseconds) DATETIMEOFFSETFROMPARTS (year, month, day, hour, minute, seconds, fractions, hour_offset, minute_offset, precision) SMALLDATETIMEFROMPARTS (year, month, day, hour, minute)…
Read More
SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()
In SQL Server 2012, there are seven new datetime functions being introduced, namely:
DATEFROMPARTS ( year, month, day)
DATETIME2FROMPARTS ( year, month, day, hour, minute, seconds, fractions, precision )
DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )
DATETIMEOFFSETFROMPARTS ( year, month, day, hour, minute, seconds, fractions, hour_offset, minute_offset, precision )
SMALLDATETIMEFROMPARTS ( year, month, day, hour, minute )
TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )
EOMONTH ()
SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach
This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we…
Read MoreSQLAuthority News – Automation of Data Mining Using Integration Services
This article is a walkthrough that illustrates how to build multiple related data models by using the tools that are provided with Microsoft SQL Server Integration Services. In this walkthrough, you will learn how to automatically build and process multiple data mining models based on a single mining structure, how…
Read More
SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction
In SQL Server Denali, there are two new string functions being introduced, namely: CONCAT() FORMAT() Today we will quickly take a look at the FORMAT() function. FORMAT converts the first argument to specified format and returns the string value. This function is locale-aware and it can return the formatting of…
Read More
SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction
In SQL Server 2012, there are two new string functions being introduced, namely: CONCAT(), FORMAT(). In this blog post we are going to learn about String Function CONCAT(). CONCAT takes a minimum of two arguments to concatenate them, resulting to a single string.
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.