PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015
PASS 2015 continues (and finishes up today!) in Seattle.
Its been an amazing conference this year with a few things really...
2015-10-31
1,031 reads
Blog Posts
PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015
PASS 2015 continues (and finishes up today!) in Seattle. Its been an amazing conference this year with a few things really hitting home; Amazing technology announcements around SQL 2016 CTP3...
2015-10-31
1 reads
Freaky statistics feature
SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a...
2015-10-30
1,545 reads
From PASS Summit to MVP Summit
This was a really great week!
So many sessions by great speakers, lots of community events, parties and fun. I met...
2015-10-30
953 reads
Interview with PernixData on Database Performance Challenges
I recently recorded an interview with PernixData where he discusses some of the largest challenges with virtualized databases, and talks about...
2015-10-30 (first published: 2015-10-21)
982 reads
PASS 2015 Session Report – Understanding Real World Big Data Scenarios
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle House Prices. The background and info on my session...
2015-10-30
7 reads
PASS 2015 Session Report – Understanding Real World Big Data Scenarios
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle...
2015-10-30
974 reads
Scripts and Slide Deck: The Data Loading Performance Presentation at PASS Summit
I have just finished delivering my session, The Data Loading Performance Presentation at PASS Summit 2015. It went very well,...
2015-10-30
1,061 reads
the game
So things are messed up. Bad. I mean, you lost a $2.7 Billion Dollar Secret Blimp or your team accidentally sent...
2015-10-30
1,078 reads
Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
4 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