Goals for 2011
Last week I wrote about my goals for last year and some frustration at having to make some trade offs...
2011-01-06
572 reads
Blog Posts
PASSMN January Meeting Update
Thought I would drop a quick note on the January PASSMN meeting. We’re running a bit behind getting things ramped...
2011-01-06
474 reads
Rebuilding the W510 – DVD Driver Issues with x64
I backed up my machine, copied a bunch of data to both a thumb drive as well as the second...
2011-01-06
753 reads
SQLSaturday #62 - Tampa
Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa. If you haven't...
2011-01-06
641 reads
31 Days of SSIS – One Variable to Rule Them All (5/31)
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I am writing. Today...
2011-01-05
462 reads
Ben Nevis Nov 2010
Ben Nevis – November 2010
Last major training trek before Kili !!
Was pretty cold up in Scotland………
2011-01-05
398 reads
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source,
write a SQL query, optimize the...
2011-01-05
946 reads
Can You Dig It? – Find Estimated RowCounts
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I took a few days off...
2011-01-05
383 reads
Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
589 reads
Free e-books
I had stumbled across the free(!) Microsoft SQL Server 2008 R2 ebook, but I was also pointed in the direction...
2011-01-05
743 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