SQL Server 2008 R2
The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May...
2010-04-16
624 reads
Blog Posts
SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
On Aprill 2010 is available the SQL Server 2008 R2 Update for Developers Training Kit. This training kit inlcudes:
Presentations (22)Demos...
2010-04-16
718 reads
Visiting Chicago
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
954 reads
A DMV a Day – Day 15
The DMV for Day 15 is sys.dm_os_performance_counters, which is described by BOL as:
Returns a row per performance counter maintained by...
2010-04-15
1,476 reads
Checklist for having a Remote Presenter at your User Group
After having a bit of a tough time in the April OPASS meeting (read about it here), due to not...
2010-04-15
297 reads
Editing Saved Packages
During my last SQLLunch, Introduction to SSIS, I was asked an interesting question by one of the attendees. He asked,...
2010-04-15
951 reads
It’s a Start
One of my 2010 goals is to really increase my SSRS knowledge. I’ve used SSRS in a cursory manner over...
2010-04-15
694 reads
LinkedIn for Blackberry
I’ve been waiting on this for a while, and missed the announcement that it was available, happened to see that...
2010-04-15
545 reads
PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,037 reads
Schedule Published for SQLSaturday #38 in Jacksonville
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
492 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