SQL MCM Training – Day 2
Today's day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered
the following 3 modules, and he can speak...
2011-08-10
1,038 reads
Klaus Aschenbrenner
SQL MCM Training – Day 1
Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am
and now (05:30pm) Kimberly is...
2011-08-09
1,698 reads
SQL MCM Training – Day 0
For the next 3 weeks I'm in Bellevue/WA for the SQL MCM training provided by Paul
Randal, Kimberly Tripp, and Bob...
2011-08-08
646 reads
My SQLbits sessions
Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool
(http://www.sqlbits.com) from September 30 –
October 1. Here...
2011-08-03
862 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
785 reads
How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
822 reads
The mystery of the NULL bitmap mask
In today's weblog post I want to talk about the NULL bitmap mask and some mysteries
that you can encounter with...
2011-06-29
4,845 reads
Replaying workloads with the RML Utilities
In today's weblog posting I want to talk about replaying SQL Server workloads with
the RML Utilities. RML Utilities stands for...
2011-06-21
4,191 reads
My SQLPASS session
Yesterday we got confirmation from SQLPASS if our submitted sessions for the upcoming SQLPASSS
summit in Seattle (October 11 – 14) were...
2011-06-16
707 reads
SQLcruise review
The most amazing journey that I have done in the past years was definitely SQLcruise
(see http://www.sqlcruise.com) – a SQL Server
event organized...
2011-06-12
557 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