BI Robert Sheldon in BI SQL Server R Services: Working with Data Frames Although you can get started with R in SQL Server without understanding data frames, they are a key structure of... 06 September 2017 29 min read
Dennes Torres Thoughts about submitting a new Power BI Quick Measure ‘Quick Measures’ is a feature included in Power BI Desktop April update. It’s still in preview, so you need to... 25 August 2017 5 min read
BI Robert Sheldon in BI SQL Server R Services: Working with ggplot2 Statistical Graphics It is when you use R in SQL Server with one of the huge range of packages that comes with... 11 August 2017 21 min read
Phil Factor Pseudonymization and the Inference Attack It is surprising that so much can be identified by deduction from data. You may assume that you can safely... 01 August 2017 10 min read
BI Saurabh Desai in BI The Best of Both Worlds: Using Excel and Power BI Together Excel and Power BI work well together. This allows you to use the two tools together to provide for many... 17 July 2017 12 min read
BI Robert Sheldon in BI SQL Server R Services: Digging into the R Language It is not just the analytic power of R that you get from using SQL Server R Services, but also... 17 July 2017 16 min read
BI Robert Sheldon in BI SQL Server R Services: The Basics It is possible to do a great deal with R within SQL Server, but it is best to start by... 19 June 2017 18 min read
BI Amarendra Reddy Thummeti in BI Developing Metadata Design Patterns in BIML You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a... 06 June 2017 22 min read
BI Saurabh Desai in BI Deploying, Securing, and Updating Power BI Reports Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly... 19 May 2017 13 min read
Blogs Phil Factor in Blogs Statistics in SQL: Simple Linear Regressions Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is... 13 April 2017 4 min read
Blogs Phil Factor in Blogs Statistics in SQL: Kendall’s Tau Rank Correlation Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating... 10 April 2017 6 min read
BI Krzysztof Stanaszek in BI Scala and Apache Spark in Tandem as a Next-Generation ETL Framework Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering... 06 April 2017 14 min read
Blogs Phil Factor in Blogs Statistics in SQL: Pearson’s Correlation Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a... 06 April 2017 3 min read
Nat Sundar Comparing SSIS Catalog Contents Using DBFit Framework When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have... 06 April 2017 16 min read
Database DevOps Phil Factor in Database DevOps Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot When you are automating a number of tasks, or performing a batch of tests, you want a way of automating... 27 March 2017 12 min read
BI Saurabh Desai in BI Using an R Package within SQL Server with Real time analysis in Power BI We all know how easy it is to run R, together with dependent packages, from SQL Server on order to... 28 February 2017 14 min read
BI Nat Sundar in BI Deploying Multiple SSIS Projects via PowerShell When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as... 27 February 2017 29 min read
BI Rodney Landrum in BI Scaling out SSRS on SQL Server Standard Edition The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is... 14 February 2017 16 min read
BI Nat Sundar in BI Deployment Automation for SQL Server Integration Services (SSIS) SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages... 12 January 2017 16 min read
BI Rahul Gupta in BI Reconciling Data Across Systems Using a Reconciliation Hub In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task... 01 December 2016 13 min read
