#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,057 reads
Tim Radney
Managing Geeks – A journey of leading by doing
I am proud to share that my good friend Andy Leonard has just released a new book. This is also...
2014-10-29
1,882 reads
SQL Server 2014 Backup and Recovery
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...
2014-10-29
1,877 reads
SQL Server 2008 SP4 Released
On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates...
2014-10-01
1,392 reads
What PASS is to me #sqlpass
I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL...
2014-09-29
1,632 reads
4 Things I Wish I Knew Sooner
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,327 reads
An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,491 reads
Microsoft SQL Server “Most Valuable Professional” MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award. An excerpt from Microsoft’s...
2014-07-01
1,361 reads
I am speaking at the PASS Summit 2014
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,227 reads
SQL Server High Availability and Disaster Recovery Options
Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the...
2014-06-11 (first published: 2014-06-10)
3,378 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