SQLSaturday #17 - Baton Rouge Session Evaluations
I guess I did a good job, with all 3s and 4s in my eval (meaning good and great) for...
2009-08-13
785 reads
Blog Posts
Upgrading To Windows 7
Well I spent most of this past Saturday upgrading my Laptop to Windows 7 Ultimate, which I have to say...
2009-08-13
751 reads
Upgrading your skills from SQL 2005 to SQL 2008......
Greetings, ALL:
As more and more companies get on board and begin to adapt SQL Server 2008, what is the best...
2009-08-13
674 reads
Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
7,037 reads
Design can be too simple
I've advocated simple design for years, trying to give users less choice, help lead them down paths to get their...
2009-08-12
548 reads
Excellent Blog List
For the one or two you that are not reading Buck Woody’s blog (and why aren’t you), you may not...
2009-08-12
704 reads
Getting Security Vulnerability Information
Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...
2009-08-12
1,161 reads
LinkedIn For Business
Ran across this recently, 33 Ways to Use LinkedIn for Business and thought I’d post it since I’ve talked about...
2009-08-12
319 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
453 reads
No Training Budget Still No Excuse
When I first started by career in IT and SQL Server about 10 years ago I lived in a small...
2009-08-12
458 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