Upcoming Presentation for Professional Development Chapter
I’ll be presenting “Building a Comprehensive Professional Development Plan” on May 13th via Livemeeting to members of the PASS Professional...
2010-05-03
693 reads
Blog Posts
What is a Good Way to Get the SQL Server Log Directory?
Introduction
Today’s post is going to be a quick one to get back in the saddle again. I have been on...
2010-05-03
415 reads
When Did SQL Server Restart?
I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something...
2010-05-03
451 reads
SQL Server 2008(R2) and Win Server 2008 R2 Core Edition
The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008...
2010-05-02
1,513 reads
SQLSaturday #39 NYC Presentations available online....
SQLSaturday #39 NYC Presentations available online....
If you were at SQLSaturday in NYC and want to see it again, or, you...
2010-05-02
957 reads
With Great Advice Comes Great Responsibility
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
572 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,160 reads
SSIS : Data Flow paths
I had a very interesting bug that had me running around for over a week. Turns out the bug was...
2010-05-01
875 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,860 reads
A DMV A Day – Day 30
The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:
Returns information about all the data pages that...
2010-04-30
3,263 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
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
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...
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