VLDB Issues at SQL Server Connections
Kim Tripp is a great speaker, with a wealth of knowledge. This session was talking about some of the issues...
2010-11-03
727 reads
Blog Posts
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
574 reads
Help! I Can’t Connect to Analysis Services in SSMS
A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well....
2010-11-02
1,602 reads
I’m speaking for the Performance Virtual Chapter of PASS
On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides...
2010-11-02
598 reads
Life Without a Net – My comment
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server...
2010-11-02
415 reads
Scripting Guy Guest Blog Post
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off a SQL Server week (Nov 1st 2010) with my guest blog...
2010-11-02
583 reads
SQLSaturday #59 – Speaker Interview #15 with Joseph D’Antoni
SQLSaturday #59 – Speaker Interview #15 with Joseph D’Antoni
Let’s kick off this Tuesday, maestro please, with a little violin music, some...
2010-11-02
837 reads
Sunday Night at PASS-Let’s Meet Up!
I’m a little later than I had hoped getting this announced, but hopefully not too late! For the past couple...
2010-11-02
424 reads
Tips For PASS Summit First Timers
In less than one week the 2010 PASS Summit begins in Seattle and with each day the excitement and anticipation...
2010-11-02
680 reads
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change...
2010-11-02
630 reads
Blogs
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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