SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Archives: March 2013

Count Weekdays in MDX

I recently implemented an MDX expression to count the number of weekdays in a given timeframe.  This logic is likely easier to implement in SQL, but in this instance it was necessary to implement in MDX.  I thought I’d share the MDX since it may prove to be useful to… Read more

0 comments, 2,507 reads

Posted in Salvo(z) SQL on 25 March 2013

Implementing a ‘Time Calculations’ Dimension in Tabular via DAX

A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube.  For example, users may wish to compare current year sales with the prior year or calculate sales year-to-date.  DAX includes a wide range of time intelligence functions to perform these types of calculations.  We can create… Read more

0 comments, 5,601 reads

Posted in Salvo(z) SQL on 11 March 2013

Introduction to the SQL BCP Utility

SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files.  Data can be imported into SQL Server tables or exported to a data file.  The BCP utility can also be used to generate format files which specify the number and… Read more

0 comments, 21,588 reads

Posted in Salvo(z) SQL on 4 March 2013