Microsoft Business Intelligence Materials from Discussion at Jacksonville University
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the...
2017-04-10
101 reads
SQL with Dustin Ryan
Another 5 Power BI Tips
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...
2017-01-31
1,128 reads
2016-11-14
487 reads
Why Can’t I View My Power BI Content Pack?
I had a call with a customer this morning discussing different ways to publish Power BI content and how to...
2016-10-20 (first published: 2016-10-12)
1,115 reads
Power BI NFL Fantasy Football 2016 Reports
If you have followed my blog for the past year or so you may remember when I posted a Power...
2016-09-01 (first published: 2016-08-23)
3,098 reads
Introduction to Power BI Desktop – Session Materials Available
For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison...
2016-08-19
579 reads
SQL Server 2016 Rundown – Session Materials Available
Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the...
2016-08-18
432 reads
Introduction to Power BI Desktop – Recording Now Available
Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop....
2016-07-15
607 reads
June 2016 Release of Power BI Desktop is Here!
Last night at approximately 9:28 PM EST the June 2016 release of Power BI Desktop dropped, which you can download...
2016-07-01
680 reads
5 More Power BI Tips
I’ve had this blog post in my mind to write for the past month or so and I’m finally just...
2016-07-07 (first published: 2016-06-29)
3,615 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers