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

SQL Player Blog

My name is Kamil Nowinski and I'm the founder & owner of SQLPlayer blog. I'm Microsoft Data Platform MVP, MCSE. Senior Data Engineer, data geek and friend of Redgate. I speak at user groups and conferences across Europe. Love #SQLfamily and Community around Microsoft Data Platform - that's why my podcast is called "Ask SQL Family" where I talk to well-known and valued specialists in the industry (including Microsoft employees).

ASF 017: Alex Whittles interview

Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.Alex has an… Read more

0 comments, 96 reads

Posted in SQL Player Blog on 14 December 2018

ASF 017 video invitation

What wasn’t really designed for people of guest’s stature? From who his every good decision does come from? New podcast episode is coming (next Friday) and in the meantime you can watch trailer. Simply click PLAY button above or move to the YouTube: https://youtu.be/hbs01wbEcHI Enjoy!

Source Read more

0 comments, 113 reads

Posted in SQL Player Blog on 7 December 2018

Speaking at SQL Saturday #782 Slovenia

In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it again, third time in a row. If you’ve been there you already know that it special event. Not only because its the last SQL Saturday in a year in Europe,… Read more

0 comments, 142 reads

Posted in SQL Player Blog on 6 December 2018

Azure Data Factory v2 and its available components in Data Flows

Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to ADF? How can I reflect current SSIS Data Flow business logic in Azure Data Factory? And turned out that new feature in ADF: Data Flow – comes with help. Further… Read more

0 comments, 152 reads

Posted in SQL Player Blog on 5 December 2018

Last week reading (2018-12-02)

Hello folks, This is a quick roundup of Internet posts from last week. Have a good reading! Create and configure a self-hosted integration runtime This solution allows you integrate your Azure environments with on-premises (or VM) machines. Understanding log buffer flushes Itzik Ben-Gan (T) explains what techniques worth to use… Read more

0 comments, 114 reads

Posted in SQL Player Blog on 2 December 2018

ASF 016: Chris Webb interview

Introduction Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in general. He has been blogging about Microsoft BI for over 10 years, and racked up over 1000 posts on his blog! Also he speaks at a number of conferences including… Read more

0 comments, 159 reads

Posted in SQL Player Blog on 23 November 2018

Last week reading (2018-11-18)

No, you don’t need a blockchain Thomas LaRock (T) says: “Don’t buy a blockchain solution unless you know for certain you need one.” Anatomy of a spool Hugo (T) collected all (undocumented) details about all kind of spools in one place. Creating a data hub for your analytics with PolyBase… Read more

0 comments, 132 reads

Posted in SQL Player Blog on 18 November 2018

ASF 016 video invitation

“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch the video trailer and guess who is the next guest.

Source Read more

0 comments, 127 reads

Posted in SQL Player Blog on 16 November 2018

T-SQL Tuesday #108 – Non SQL Server Technologies

It’s T-SQL Tuesday #108. This month’s topic is hosted by Malathi Mahadevan (B|T) and she asks us to… “pick one thing you want to learn that is not SQL Server. Write down ways and means to learn it and add it as another skill to your resume. If you are… Read more

0 comments, 143 reads

Posted in SQL Player Blog on 13 November 2018

Last week reading (2018-11-11)

Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after PASS Summit. As always, PASS Summit is the event where you can hear many announcements. This post, predominantly, base on them. Unfortunately, I did attend the event this year, but… Read more

0 comments, 29 reads

Posted in SQL Player Blog on 11 November 2018

SQL Relay became Data Relay 2018

It was very long and hard-working week (8.10-12.10). I was with my data-geek #SQLfamily and friends at the (SQL) Data Relay conference. This is kind of log of that journey. Do expect various past and present tenses because I have written it during the event. Or wrote it icon-smile-o Old-New… Read more

0 comments, 21 reads

Posted in SQL Player Blog on 7 November 2018

Last week reading (2018-11-04)

Good morning folks! I wish you very good week at work, at home or wherever you are/will be. Last week brought super-exciting news to me. What it was? Check at the bottom. In the meantime – bunch of news: What is Azure Data Factory Data Flow? You should find all… Read more

0 comments, 21 reads

Posted in SQL Player Blog on 4 November 2018

How to create DACPAC file?

In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps series I described how to create new, empty database project in Visual Studio. One of the ways how to import an existing database (from a server) was import database from… Read more

0 comments, 27 reads

Posted in SQL Player Blog on 31 October 2018

ASF 015: Kalen Delaney interview

Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California. Kalen has an independent international trainer and consultant since 1992. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen… Read more

0 comments, 22 reads

Posted in SQL Player Blog on 22 October 2018

Last week reading (2018-10-21)

DevOps Terms – and Why They Matter to Database Specialists Find out what is Scrum, Continuous Deployment, TDD and others from Kendra Little [T]. Seamless access to management insights for SQL Data Warehouse with Data Studio Check potential physical data skew in your Azure SQL Data Warehouse (SQL DW) using… Read more

0 comments, 23 reads

Posted in SQL Player Blog on 21 October 2018

ASF 015 video invitation

“This was in Dallas, we had our MVP Summit in Dallas and there were only maybe like less than 10 SQL Server MVPs.” Do you want to know who has said that and why we have the #SQLFamily so great? Watch the video trailer and guess who is the next… Read more

0 comments, 21 reads

Posted in SQL Player Blog on 15 October 2018

Last week reading (2018-10-14)

Hi guys! Not too much this week as I was very busy on #DataRelay tour across UK whole week (relation soon). Azure Data Factory – Data Flow Monitoring Check what you can do in terms of monitoring and execution plan in ADF. Get cloud-scale analytics of Office 365 data with… Read more

0 comments, 21 reads

Posted in SQL Player Blog on 14 October 2018

Setting up Code Repository for Azure Data Factory v2

In this blog post I want to quick go through one of useful capabilities that Microsoft provided with version 2 of Azure Data Factory. As a developer I always want to use code repository to keep all my changes, to manage tasks, branches, share the code with a team and… Read more

0 comments, 21 reads

Posted in SQL Player Blog on 5 October 2018