Failing to Overreach
I’m not sure what put this phrase in my head, though I think in part it came from various posts...
2013-04-03
716 reads
Blog Posts
How do I move a SQL login from one server to another without the password?
This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...
2013-04-03 (first published: 2013-03-25)
9,557 reads
Pragmatic Works' Master SSIS Workshop coming to NYC
Pragmatically
speaking, there’s no way you can learn all there is to know about Microsoft’s
native ETL tool, SQL Server Integration Services...
2013-04-03
2,109 reads
Tomorrow: NYC Metro SQL Server User Group Presents Paul Randal and Kimberly Trip
Well, they're baack in the City!Coming this Thursday April 4, 2013 to the Big Apple, hosted by the NYC
Metro SQL...
2013-04-03
940 reads
Total Number Of Records In each Table
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
711 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...
2013-04-02 (first published: 2013-03-25)
3,970 reads
Madison SQL Saturday (#SQLSat206) Is This Weekend
Crack a beer and melt the cheese, the Madison SQL Saturday is this weekend. Don’t wait any longer because you...
2013-04-02
492 reads
Merging SQL Server and Softball Just for Fun
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,283 reads
Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,266 reads
Reminders and Rehearsal
I’ve spoken at quite a few SQL Saturday events. I won’t hit 50 this year, like Kevin Boles, but by...
2013-04-02
791 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