Fewer Seats Make for Better User Group Meetings?
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,333 reads
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,333 reads
Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I...
2007-08-09
1,359 reads
One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.
2007-08-09
20,288 reads
Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty...
2007-08-08
1,440 reads
Ensuring that our careers grow is something that each of us must take charge of and Andy Warren brings us one of the ways in which you can do this: create a plan. Andy talks about how you can structure a plan at different stages of your career.
2007-08-07
5,333 reads
This was fun to write. It's a subject I'm passionate about and that too few in our field seem to...
2007-08-07
532 reads
Big news here in Orlando is that Joe Celko will be presenting two sessions at SQLSaturday on Nov 10. Once...
2007-08-02
469 reads
The article went live earlier this week. Didn't quite accomplish what I had hoped I think, which was to point...
2007-08-02
446 reads
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
2007-07-30
3,540 reads
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,555 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers