sqldusty.com
PowerPivot | SQL with Dustin Ryan
https://sqldusty.com/category/powerpivot
SQL with Dustin Ryan. Power BI Desktop Designer. 10 DAX Calculations for your Tabular or Power Pivot Model (Part 2). October 21, 2015. This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations you may find useful in your Power Pivot, Tabular or Power BI model. So if you missed part one, I would encourage you to check that out. Read 10 DAX Calculations for your Tabular or Power Pivot Model (Part 1). To do this we can use the USERELATIONSHIP. So when...
sqldusty.com
Excel | SQL with Dustin Ryan
https://sqldusty.com/category/excel
SQL with Dustin Ryan. Power BI Desktop Designer. Power BI Architecture Diagram v2 is Now Available. June 18, 2016. I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram. Click here to download a .zip file with the .pdf and .png files. I’ve included a few new things to make the diagram up to date with the latest changes to Power BI, SQL Server Reporting Services, and Excel. This document includes components to illustrate:.
scarydba.wordpress.com
PASS Summit 2010, Day 3 Key Note | Home of the Scary DBA
https://scarydba.wordpress.com/2010/11/11/pass-summit-2010-day-3-key-note-part-1
Home of the Scary DBA. PASS Summit 2010, Day 3 Key Note. November 11, 2010 at 11:48 am ( PASS. Today is Dr. Dewitt. The ballroom, where the keynotes are held, is filled with extra chairs. The Summit organizers expect extra attendance today, and well they should. Dr. Dewitt was amazing last year. I suspect this year will be more of the same. This is great because I was going to miss it next year. Oct 11-15 will be the dates in 2011. Of course, it’ll be at Seattle. So there are equivalence rules, such as s...
sqlavenger.blogspot.com
SQL Avenger: Review - SQL Saturday #57 Houston
http://sqlavenger.blogspot.com/2011/02/review-sql-saturday-57-houston.html
Tuesday, February 1, 2011. Review - SQL Saturday #57 Houston. I attended my first SQL Saturday this past weekend in Houston. SQL Saturday is a free event sponsored by PASS. The local SQL Server user group ( HASSUG. And some vendors. Well, it was almost free. I did have to pay ten dollars for lunch. It was a delicious selection of eats from Hinze's BBQ. Schwag:The real reason we come. From all the content that has been thrown at you. Each session I attended was full of great information that I can take ba...
agilebi.com
BI Thoughts and Theories » Blog Archive » Where’s John These Days?
http://agilebi.com/jwelch/2012/02/20/wheres-john-these-days
BI Thoughts and Theories. Laquo; Checking Whether a Character is Numeric. Q and A From “Unit Tests for SSIS Packages”. Where’s John These Days? February 20, 2012, 9:47 pm. Apologies for the lack of updates to the blog recently. It’s been a very busy time, but hopefully things will settle down a bit now. Exciting news today (for me at least)! It was my first day as a Pragmatic Works. Employee. I’ve joined their product group, and will be helping manage the development of their BI tools. Last, but definite...
sqlavenger.blogspot.com
SQL Avenger: February 2011
http://sqlavenger.blogspot.com/2011_02_01_archive.html
Tuesday, February 1, 2011. Review - SQL Saturday #57 Houston. I attended my first SQL Saturday this past weekend in Houston. SQL Saturday is a free event sponsored by PASS. The local SQL Server user group ( HASSUG. And some vendors. Well, it was almost free. I did have to pay ten dollars for lunch. It was a delicious selection of eats from Hinze's BBQ. Schwag:The real reason we come. From all the content that has been thrown at you. Each session I attended was full of great information that I can take ba...
markvsql.com
TARDIS – Time And Relative Distribution In SSIS | Mark V SQL
http://markvsql.com/2015/06/tardis-time-and-relative-distribution-in-ssis-2
Mark Vaillancourt: Data Nerd. TARDIS – Time And Relative Distribution In SSIS. 16 June, 2015 (10:00) SSIS. Fans of Dr. Who. Note: I have included the SSIS solution as well as script that creates all necessary database objects and rows right here. The TARDIS Child Package. I created a table called StoredProcedure with the following rows shown in Figure . I created Table1 thru Table6 with this exact same pattern. My child package is pretty simple, as shown in Figure 2. The task is configured to pass the va...
mikefal.net
PASS | Art of the DBA
http://www.mikefal.net/tag/pass
Art of the DBA. Blending the right and left sides of SQL Server Database Administration. Skip to Content ↓. SQLPASS 2015 Board of Director’s Elections. Sep 1st, 2015. Apologies for the unplanned blogging hiatus, but I’m back. While I’ve got a few technical post ideas bouncing around in my head, some events over the past two weeks have arisen that I want to blog on. If you’re hoping for more Powershell posts, do not despair! They will be along shortly. Is a current board member. Is a current board member.
sqlinthewild.co.za
On burnout and recovery | SQL in the Wild
http://sqlinthewild.co.za/index.php/2010/12/09/on-burnout-and-recovery
SQL in the Wild. A discussion on SQL Server. On burnout and recovery. SQL in the Wild. On burnout and recovery. I suspect for a fair number burnout is something that they believe happens to others. People with less fulfilling jobs, people who don’t love their work, people in poorly managed companies. Other people. The biggest mistake (I think) was in how I handled it. Instead of taking a break (and work was quiet around that time so I could), I took on more commitments, thinking that it would help mo...
brssug.org
Useful Links - Baton Rouge SQL Server User Group
http://www.brssug.org/useful-links
Http:/ cajunsql.blogspot.com/. DBA Blogging With a Smile. Http:/ thesmilingdba.blogspot.com/. Http:/ www.jonathanagardner.com/. Http:/ www.sqltigers.com/. Acadiana SQL Server UG. Http:/ www.barcampnola.com/. Baton Rouge Agile Group. Baton Rouge Bluemix Developers. Http:/ www.meetup.com/Bluemix-Developers-in-Baton-Rouge/. Baton Rouge IT Pro User Group. Http:/ www.britug.org. Baton Rouge .net User Group. Http:/ www.brdnug.org. Baton Rouge Power BI User Group. Baton Rouge SharePoint User Group. Http:/ www&#...