Blog Posts of the Week 2015-07-24 Here’s a collection of blog posts, videos and links that i found useful this week…

The big news this week was definitely the release of PowerBI Desktop and how we will be soon be able to host in house with Microsoft teaming up with Pyramid.

PowerBI

Microsoft Power BI
Microsoft & Pyramid Analytics Strategic Alliance Delivers Accelerated Power BI Desktop
Chris Webbs Power Bi Posts
The new Power BI Desktop is here #powerbi #dax
Thoughts On the Microsoft/Pyramid Power BI Deal
Power BI is Generally Available today

Tech Posts

Deploying ispac files with PowerShell
Change operating modes for SQL Server Database Mirroring
Desired SQL Configuration with #Powershell – Part 2
Updating All Jobs To Check For AG Primary Replica
PSSDiag Configuration Manager – A Companion for SQLNexus
AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover
Keep your environments in-sync and your upgrade scripts fresh
Analyzing I/O Performance for SQL Server
SQL Server 2012 Service Pack 2 Cumulative Update #7
How to pollute your Plan Cache with parameterized SQL statements
DevOps: The Ops Perspective (Free eBook)
Filtered Index restrictions and Kendra Little’s Index Quiz
SQL Server Management Studio – Footloose and Fancy Free
How to close all active database connections in one shot?
Build your own StackExchange Database
SQL Formatting Matters…
WaitForSql (to start)
Obfuscating your data with SQL Server 2016 Dynamic Data Masking
Corruption, corruption, more corruption

Other Interesting Posts

The Science of Stress and How Our Emotions Affect Our Susceptibility to Burnout and Disease
WHAT IT TAKES TO BE A GREAT LEADER: A RECOMMENDED READING LIST
The Cure for Tweak-Boss
Top 150 Career & Leadership Blogs for Your Success in 2014
DiskSpd, PowerShell and storage performance: measuring IOPs, throughput and latency for both local disks and SMB file shares
Preparing for a shark attack
My First Year With Chef — Steven Murawski

Upcoming Events

SQLSaturday #411 – Cambridge 2015
SQLSaturday #467 – Southampton 2015
UK SQL Server User Groups
UK SharePoint User Groups UK Azure User Group
PowerShell User Groups