oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum
The next oPASS meeting is tomorrow night (June 25, 2015):
DBAs do not always have time to work with some of...
2015-06-24
395 reads
SQLAndy
Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015
We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015....
2015-06-24
482 reads
Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
SSC Editorial: Sweat Files and Practice Projects
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
336 reads
Notes from the June 17, 2015 MagicPASS Meeting
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
362 reads
Presenting at the Space Coast SQL Group on August 13, 2015
I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...
2015-06-17
290 reads
Presenting at the Jacksonville SQL Group on September 16, 2015
I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts...
2015-06-17
365 reads
Publicizing Mistakes
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
460 reads
Working With Sponsors
Apologies for the poor photo, the example was trampled a bit on the journey home! This past weekend at SQLSaturday...
2015-06-15
383 reads
Marketing Materials for PASS Chapters
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
412 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