SQL Server Security Principals Lightning Round Presentation
Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!
I presented a...
2016-02-10
375 reads
SQL Tact
Easy Installing .NET 3.5 for SQL Admins
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,464 reads
Announcing the Baton Rouge Power BI User Group
Baton Rouge is home to one of the inaugural Power BI User Groups, starting up soon! I'll be serving as its...
2015-11-05
471 reads
Congratulations New 2015-2016 BRSSUG Officers!
We elected new officers tonight for the Baton Rouge SQL Server User Group Official PASS Chapter, the second year in...
2015-10-14
483 reads
Presentation Downloads from SQL Saturday Columbus GA 2015
Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL...
2015-10-03
510 reads
Why I Don't Use the Architect Title
I get nervous when I see the title "architect" in IT job roles.
I've had this title before as an employer's...
2015-09-28
466 reads
I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords
Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at...
2015-09-24
656 reads
Houston TechFest Presentation Downloads
Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and...
2015-09-13
470 reads
SQL Saturday Baton Rouge 2015 Recap
SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee...
2015-08-28
1,202 reads
Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design
Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less...
2015-08-23
436 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...
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...
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