NY/NJ SQL Saturday Event Details - October 24, 2009
NJSQL/NYCSQL Saturday Event on October, 24th (Registration Required)
Here are the details, of my previously announced SQL Saturday event hosted by...
2009-10-05
1,266 reads
Blog Posts
Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
814 reads
Speaking Engagements This Week
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
982 reads
SQL Lunch Starting at 11:30 AM CST 10/5/2009
TOPIC: SQL Lunch - Memory Management in SQL Server Analysis Services
If you haven’t already, go out and register for today’s SQL...
2009-10-05
730 reads
SQL Saturday #21 – Orlando
Well we are less than two weeks away from SQL Saturday #21 in Orlando, FL. My bags are packed and...
2009-10-05
531 reads
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,379 reads
A Hint For Recruiters (And You!)
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
347 reads
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,024 reads
Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,337 reads
Pitching in at SQL University
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,124 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