25 Years Later: What SQLServerCentral Meant to Me
A look back at SQL Server Central after 25 years from founder Brian Knight.
2026-02-20
1,292 reads
Brian Knight
Formatting SSAS Measures - SQL School Video
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
2009-03-05
3,676 reads
Running A Basic DMX Query - SQL School Video
This SQL School video introduces us to the data mining queries that you can run from BIDS in an Analysis Services project.
2009-02-26
4,771 reads
Running Singleton Queries Against a DMX Data Mining Model - SQL School Videos
Learn how you can run a singleton data mining query against a cube with a mining model.
2009-02-24
1,846 reads
Installing & Congfiguring DM Add-in for Excel - SQL School Video
This SQL School video explains how to use the Data Mining add-in for Excel 2007. The installation and configuration are covered.
2009-02-19
3,109 reads
Creating Mining Structure - SQL School Video
In this SQLSchool video, MVP Brian Knight shows us how to create a simple data mining model in Analysis Services.
2009-02-17
2,880 reads
Data Mining in Excel 2007 Pt.2 - SQL School Video
In this video MVP Brian Knight continues on with more advanced data mining using Excel.
2009-02-12
3,372 reads
Data Mining in Excel 2007 Pt.1 - SQL School Video
Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.
2009-02-10
5,216 reads
Mining Model Viewers - SQL School Video
In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.
2009-02-05
2,052 reads
Installing Sample 2008 Databases - SQL School Videos
Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.
2009-02-03
3,925 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