Need an Aircard for a Few Days?
Ran across this, http://daypasswireless.com/, lets you rent an aircard plus service. Don’t know if it’s too late for those of...
2009-10-29
641 reads
Blog Posts
OFF-TOPIC: More about the pregnancy
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
891 reads
Special Events at the PASS Community Summit
If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of...
2009-10-29
466 reads
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,671 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,648 reads
There was a rancher who had a DBA.... (Getting prepped for PASS)
and B-I-N-G-O was his game-o.
Maybe not that funny, but I think that SQL Bingo will be a fun time. If...
2009-10-29
824 reads
What Should PASS Strive To Be?
Steve Jones had a good editorial earlier this week entitled, What Do We Want from PASS?. It didn’t generate as...
2009-10-29
930 reads
Amazon.com Author Central Page
If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The...
2009-10-28
610 reads
Crazy Egg
I know, I should have put more in the title. Crazy Egg is a web page traffic analysis tool that...
2009-10-28
564 reads
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-10-28
1,858 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