SQL Server 2016 really represents a drastic change for the better in regards to general performance. And the proof is that, thanks to the engine changes, this is the first SQL Server version where Microsoft actively provides a widespread increase in performance levels by simply upgrading. But what impact can it have in your daily loads if you use columnstore indexes in SQL server 2014 datawarehouse? There was already an amazing increase in performance levels with SQL Server 2014 and the columnstore indexes. Is it worth upgrading to SQL 2016? (more…)
Below is a comparison table between ETL tools: SQL Server Integration Services aka SSIS vs PowerCenter. What tool should I choose? What are the differences? What are the advantages and disadvantages? Do they meet my requirements and particular needs? These are some of the questions that you may have asked yourself at the start of any new project, and we will aim to answer them in this post by providing you with some key facts regarding two very potent tools: SQL Server Integration Services a.k.a. SSIS versus Informatica PowerCenter.
How to bulk copy Azure ML Experiments from a Workspace to another one or do a Backup of them in Physical Files
today I want to tackle the issue of bulk copying more than one Azure ML experiment at once between different workspaces.
May be you already know that you can partially solve this task by copying an experiment one at a time. But you have to access to both the workspaces with your user. If not, you can simply share a workspace in this way:
Once you can see both the workspaces in your Azure Machine Learning Studio, you can simply select an experiment and than “Copy to workspace”:
and than you can choose the destination workspace:
A you can imagine… you can’t simply select more than one experiment and than copy all them:
Now suppose you have dozens of experiments and simply you don’t want to waste your time coping them all manually, or moreover you can’t have access to a shared workspace for security reasons. Is there a way to bulk copy your experiments? I’ll show you how to do that using few rows of PowerShell.
I just returned from a meeting with some of my peers at SolidQ and we were talking about the value of blogging and publishing articles. A few days ago, another one of my peers asked me to review his first-ever blog post before it was published. Douglas McDowell, CEO of SolidQ North America, shared a … Continue reading
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to mention the business owners, marketers, sales campaign planners and scientists, IT Pros and common folk. Power BI is all the rage and can be used to analyze everything under the sun – oh, and that … Continue reading
Choosing the right visualization control for a set of data can sometimes be challenging. I find some aspects of designing dashboard solutions in Datazen on the surface to be very simple but it’s easy to get stuck in the details and fine points. The purpose of this guide to help simplify and categorize visual control … Continue reading
SQL Server Pro Magazine is hosting my 3-part series, Designing a Mobile Dashboard Solution with Microsoft DataZen on Thursday. The first one hour session begins at 11 AM Pacific, 3 PM Eastern Time. There are three sessions in the series which include: Session 1: Introducing DataZen and Building a Server – 11am EDT Session 2: … Continue reading
Power BI is due to be released to the masses this week and I’m very excited to see this powerful product made available to so many for so little. We’ve had some of the capabilities of Power BI in other Microsoft products for a few years so why is this this different and what does … Continue reading
I’ve just finished a series of four articles for SQL Server Pro Magazine, along with sample projects and hands-on exercises. The series will take you through SSAS Tabular model design from start to finish, using the Adventure Works sample data in SQL Server 2012 or 2014. Follow these links to each article in the series:
Part 1 – Getting Started with SSAS Tabular
Part 2 – Easy DAX – Getting Started with Data Analysis Expressions
Part 3 – Tabular Model Administration
Part 4 – Deep Dive DAX – Solving Complex Business Problems with Data Analysis Expressions
This topic has been a recurring theme for a very long time and one that I have encountered many times using SSRS. What are the capabilities & limits of exporting reports to Excel? Read the entire post on my blog here.