August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
853 reads
Blog Posts
Buck Woody Joins SQLSaturday Advisory Council
Just announced at http://blog.sqlsaturday.com/2009/08/sqlsaturday-advisory-council-newest.html, Buck makes three – one more to go coming up soon!
2009-08-19
543 reads
Don’t Use USE (in SSIS, at least)
I ran into a situation this week that brought to light a subtle syntactical error I’d made in creating an...
2009-08-19
756 reads
I/O You a followup - More about I/O, Performance Tuning & Troubleshooting....
Yesterday, I blogged about basic I/O usage with some useful scripts, DMVs, and links to more in-depth details on examining...
2009-08-19
1,635 reads
Looking for SQL Speakers Near Wheeling, WV
I had a great call with John Sterrett last week about the possibility of having a SQLSaturday in Wheeling and...
2009-08-19
919 reads
Partitioning Strangeness
Ran across this in a recent class while covering partitioning. Start by creating a standard partitioning function and the scheme,...
2009-08-19
2,487 reads
Tampabay SQL Server User Group Presentation
I presented a one-hour session for Tampabay SQL Server User Group on Powershell and SQL Server. I've previously delivered this session for the...
2009-08-19
827 reads
Updated Blog List
I added a new blogger to my list. I was surfing around for a few good examples to use in...
2009-08-19
730 reads
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-18
4,628 reads
Comparing Settings Entreprise-Wide with SQL admin toolset’s Server Configuration app.
In the Spring of 2008 Idera launched its SQL admin toolset at a super low deal of around two hundred...
2009-08-18
1,803 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