Making A SQLPS Module
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL...
2010-07-10
3,247 reads
Blog Posts
Windows Search Enable Your Script Files
At the July 8th Tampa PowerShell User Group meeting, Ed Wilson (blog|twitter) gave a presentation on “PowerShell Best Practices.” One...
2010-07-10
648 reads
Another Update on Goals
I was querying the SQLServerCentral database for something else today, and I decided to take a minute and double check...
2010-07-09
406 reads
Delivering the Bad News
It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week,...
2010-07-09
718 reads
Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)
Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts...
2010-07-09
1,552 reads
Is my SQL Server Pre-Release
I get to work with a lot of different clients and client environments and like many companies they are often...
2010-07-09
312 reads
Last Book Chapter Submitted
Whew, I just got my last chapter submitted to the editorial team for our newest book. I still have to...
2010-07-09
341 reads
PASS Sessions Submitted
Hey guys, I’m preparing a few new article series for you but in the meantime I wanted to let you...
2010-07-09
318 reads
PASS Summit 2010 Sessions Accepted
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
412 reads
PASS Update #36
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,151 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