by Matt Allington | Jun 25, 2018 | Excelerator BI
Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as I do), I...
by Paul Hansen | Jun 25, 2018 | Power BI
It’s almost here, the first-ever Microsoft Business Applications Summit, coming to Seattle July 22 – 24. Don’t miss out! Register today for two info-packed days of amazing sessions, networking opportunities and expert meet-ups. This post first appeared...
by Jeanne Combrinck | Jun 25, 2018 | SQL Girl
Transactions in SQL Server are very useful, however I have come across that not many people use them. Not sure why this could be, so thought I would share how transactions work and the different modes. A transaction is a single unit of work. If a transaction is...
by Jeanne Combrinck | Jun 22, 2018 | SQL Girl
Sometimes you need to automate the upload of a file to an FTP or SFTP. Thought I would share the way that I use the SFTP task in SSIS to upload files. Firstly create the variables to use in the SFTP task. Variables are an easier way to manage things without going into...
by Chris Webb | Jun 21, 2018 | Chris Webb
The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added. The first of the new features I decided to try was the RowsetSerializationLimit server property,...