Management Studio Database Diagram Owners
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...
2012-12-10 (first published: 2012-12-03)
3,280 reads
SQL Tact
PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."
Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded. The Managed Add-in Loader failed...
2012-11-30
6,439 reads
Database Design Contest at the 2012 AITP Region 3 Student Conference
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
Performance Tuning Presentation from October 2012 BRSSUG Meeting
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
756 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,753 reads
SQL Server Best Practices for DMV's - Houston Tech Fest 2012
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
943 reads
SQL Agent Alerts - Severity Condition is NOT "greater than or equal to"
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,267 reads
Actual Emails: The Customer Doesn't Want Full Recovery Mode
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
685 reads
SQL Saturday #150 Baton Rouge 2012
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
775 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,069 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