Three Operating System (Windows) patches due on Tuesday
Microsoft's advance security bulletin has come out and it looks like they are planning on releasing 3 security bulletins on...
2009-03-06
690 reads
Blog Posts
Voice Your Opinion on Topics to be Included at the 2009 PASS Summit
If you are thinking about, or planning to attend the 2009 PASS Community Summit, here is your opportunity to tell...
2009-03-06
449 reads
Book Review: Just Culture
I just finished reading Just Culture, which talks about the challenges of building a system that encourages people to report...
2009-03-05
339 reads
Tagged again
Once again I was tagged to answer a question. This time by Chris Shaw http://chrisshaw.wordpress.com .
Here is the question: Do...
2009-03-05
575 reads
The MVP Summit Wrapup
This week I've been at the Microsoft MVP Summit in Washington State. This is my second summit, and I was...
2009-03-05
1,108 reads
[Off Topic] Get Fit in February – Wrap Up
During the month of February, I participated in the Get Fit in February challenge last month. Along with a few...
2009-03-04
629 reads
Book Review - Naked Conversations
This was one of the first books that I grabbed on my Kindle at the Business of Software Conference in...
2009-03-04
383 reads
Book Review: eBoot Camp, Proven Internet Marketing Techniques to Grow Your Business
My friend Chris loaned me his copy of eBoot Camp as I'm trying to strengthen what I consider to be...
2009-03-04
365 reads
Database Mirroring FAQ: How do we handle transaction log maintenance for a mirrored database?
Question: How do we handle transaction log maintenance for a mirrored database?
This question was asked on a technical discussion group....
2009-03-04
23,486 reads
Owning an Object in SQL Server 2005/2008
One of the things that we have to re-learn when going from SQL Server 2000 to 2005/2008 is that objects...
2009-03-04
6,663 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
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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;See possible answers