The Last Day To Save
If you have not registered for the 2005 PASS Summit, today is the day to do so. The conference fee goes up after today, so call your boss and get registered.
2005-06-30
2,866 reads
Press Release
The July SQL Server Standard - Replication
We've just sent the July issue of the SQL Server Standard to the printer and it should be shipping out to you subscribers next week. The e-version should be in your virtual briefcase and it should be at the PASS and MCP sites soon. Read the editorial and see what's in this issue.
2005-06-23
4,577 reads
Help Us Out For A Free Gift
We would like to offer a free copy of the May 2004 SQL Server Standard magazine to everyone who can take a couple minutes to update some demographics for us.
2005-06-08 (first published: 2005-05-25)
6,345 reads
A Look Back at the 2005 PASS European Conference in May
Kurt Windisch, Vice President of the Professional Association for SQL Server, recently returned from their European Conference. He shares a few notes on the event which was held earlier this month in Germany.
2005-05-31
2,879 reads
SQL Server Standard for MCPs
It's back after some negotiating the myriad of groups at Microsoft, the SQL Server Standard is back for Microsoft MCPs.
2005-05-31
6,007 reads
The SQLServerCentral.com IT Research Library
We've partnered with BitPipe and TechTarget to bring a huge collection of white papers and other valuable information to you for free!
2005-05-12
3,665 reads
The BestOf vol. 3 and Stumpers Vol. 2
New books from SQLServerCentral.com. The latest versions of our very popular SQL Server reference materials are now available.
2005-05-11
5,017 reads
SQL Server 2000 Service Pack 4
It's now available!! Find out what's in there and where you can get it.
2005-05-09
21,837 reads
Steel City SQL
If you're in the Birmingham area, a new SQL Server users group, affiliated with PASS is forming. User groups are a great way to meet people and do some networking in your area. The first meeting is later this month, so if you can, drop by.
2005-05-05
3,067 reads
DBxtra Discount
We periodically negotiate a discount withe vendors for the SQLServerCentral.com readers. We've gotten another one from DBxtra for a Professional license if you're interested in this reporting tool.
2005-04-28
2,798 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
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