JSSUG Speaker Idol 2012 Review
Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what...
2012-08-21
1,163 reads
JSSUG Speaker Idol 2012
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,105 reads
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...
2012-08-08
2,406 reads
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...
2012-07-31
1,911 reads
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...
2012-07-27
4,388 reads
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...
2012-07-18 (first published: 2012-07-17)
3,304 reads
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...
2012-07-16
1,213 reads
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...
2012-07-11
1,137 reads
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...
2012-07-08
4,079 reads
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...
2012-07-05 (first published: 2012-06-29)
6,285 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers