The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local speakers. That’s why tomorrow we
Author: devinknight
Visio 2010 Forward Engineer Add-in
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in case anyone else has yet
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It allows you to have some
SSRS – Using Lookup Function for Multiple Column Join
When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple datasets together. Those functions were
Office 2013 Preview – Enabling PowerPivot in Excel
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still a customer preview
Building Your First Power View Report
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog. Fulfilling User Needs Developing a Power View
SQL Lunch #68 – Designing Your First Power View Report
Next week I will be speaking on designing your first Power View report for SQL Lunch. Be sure to join me for the event and
Identifying Long Running SQL Agent Jobs Script
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this case I’d actually like some
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel Macro (.xlsm) enabled workbook. If
Speaking at PASS Summit 2012
Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! This is my favorite of
Command Line Prompts for Checking Active Directory Membership
Using Active Directory groups are a great way to manage and maintain security for a solution. Think about if you had to manually add users
New SSIS 2012 Expressions
SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each. LEFT The LEFT function believe it
SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature called Project Connection Managers. If
Converting to the SSIS 2012 Project Deployment Model
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. Any new packages that are
Devin Knight 