Microsoft GeoFlow new Excel 2013 add-in
Hi
Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...
2013-04-15
711 reads
Katie and Emil
70-461 Test SQL Ranking Functions
I created a post-webinar SQL Ranking Functions interactive test which relates to 70-461 Exam and thought I will share it....
2013-02-25
1,826 reads
Vote of our next SSIS Webinar
Our sessions were not chosen for neither SQLSaturday nor SQLBits but if you were interested; nothing is lost as now...
2013-02-18
710 reads
SSIS Webinar Satisfaction Score
Our first free SSIS Webinar is over and the overall satisfaction score we got was 9.2 out of 10 so...
2013-02-11
1,003 reads
SSIS Webinar in 3 days... 6 seats left
Our first SSIS 1h Free webinar will take place in 3 days (Thursday) and has only 6 seats left (out...
2013-02-04
643 reads
I hate Windows 8 and Microsoft Top 3 Mistakes
What do you think about Microsoft new Operating System? I hate Windows 8! This is the answer that many people...
2013-02-04
995 reads
SSIS 6 Million Rows in 30 Seconds using standard laptop
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,753 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,143 reads
SQL Server Non Clustered Index Tutorial for Beginners
In the past I have come across comments like SQL Server is slow (small tables) or interviews where someone had...
2013-01-25
2,403 reads
SSIS Top 10 Best Practices Basics
Best Practice is a difficult one... It generally depends on many factors. In my opinion SSIS Best practice is a...
2013-01-16
1,802 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