SQL 2008 Schedule Slippage and SQL 2005 SP3
I've read with interest some of Steve's editorials about SQL 2005 SP3 and in large part agree with him that...
2008-03-02
598 reads
Blog Posts
Documentation Value Formula (Part I)
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,066 reads
New DBA type: Test DBA
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,888 reads
New Benchmarks
There are new TPC-E benchmarks available for SQL Server 2008. And it's not even out!!!!
The 3rd place, the IBM entry,...
2008-02-28
1,480 reads
Notes From My Visit with the Charlotte SQL Group
I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my...
2008-02-28
1,296 reads
Snapshots Part 1 Published on SSC
Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In...
2008-02-26
1,249 reads
The Launch
The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be...
2008-02-26
1,392 reads
Using TripIt for Travel Plans
Not a SQL related topic today.
I first noticed Tripit on Joels Blog and so far it solves a problem I've...
2008-02-26
1,288 reads
Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,417 reads
Lessons Learned from SQLSaturday #2 - Tampa 2008
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,477 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