Two Blog Series You Don’t Want to Miss
Blogs are a great way to learn new things about SQL Server, and just in case you have missed them,...
2010-05-28
1,581 reads
Blog Posts
Adding Space to a Home Server
I got new drives for my Windows Home Server the other day and decided to add some space to the...
2010-05-27
1,042 reads
Becoming a Part of the SQL Server Twitter Community
There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...
2010-05-27
747 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,441 reads
Challenge 19 – An Explanation of a Query
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...
2010-05-27
1,705 reads
Follow Up On My Keynote Survey
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
621 reads
IndyTechFest 2010 a Big Hit
Jesse Liberty,a Developer Community Program Manager for Microsoft, starts off IndyTechFest 2010 with the keynote presentation.
On Saturday, May 22, 2010,...
2010-05-27
472 reads
North Texas SQL Server User Group Offers Innovative Educational Series
On Thursday, May 20, 2010, I had the opportunity to speak at the North Texas SQL Server Users Group, which...
2010-05-27
480 reads
SQLSaturday #49 Planning Update
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
480 reads
The SSIS Data Flow is Like... an Automotive Assembly Line
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
465 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