Introduction to SharePoint BI Webinar Tomorrow
Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...
2012-03-06
624 reads
Blog Posts
Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned
I was very surprised to see the results of my latest poll, which asked “When was the last time you...
2012-03-06 (first published: 2012-02-27)
4,815 reads
Moving MSDB to new location
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...
2012-03-06
869 reads
Notes from the February 2012 MagicPASS Meeting
I was back at MagicPASS last week to do a presentation, my first time with the group at the new...
2012-03-06
561 reads
Second Chances for Plagiarism
I had an exchange with someone that had plagiarized some work recently. That’s nothing new, and I run into plagiarism...
2012-03-06
1,203 reads
SQL Server 2005 to SQL Server 2008 R2 upgrade considerations
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped...
2012-03-06
1,167 reads
SQL Server 2012 has released to manufacturing (RTM) - Hot MS News!
All, wanted to immediately share the news today from Microsoft regarding SQL Server: This just in from the MVP/MS Newsroom. I'm...
2012-03-06
1,630 reads
SQL Server 2012 released!
Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an...
2012-03-06
1,641 reads
SQL Server 2012 RTM Today
So it looks like today is the day.
SQL Server 2012 has been RTM’d today.
General Release 1st April 2012
http://www.microsoft.com/Presspass/press/2012/mar12/03-06SQLServer12PR.mspx
2012-03-06
2,032 reads
SQL Server 2012 RTM. Translation: SQL 12 is out now! (Virtual Launch event update)
Originally published March 6, now with Post-launch updates.
Just a quick note for you today: Microsoft announced that SQL Server 2012...
2012-03-06
988 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