MSSQLFUN – Year 2012 Review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of...
2013-01-03
718 reads
Blog Posts
SQL Saturday #194 Exeter
I have read much about SQL Saturday’s but I have yet to attend one, that is about to change. I...
2013-01-03
833 reads
SQLBits XI: Need Your Vote
SQLBits XI: Need Your Vote
SQL Bits XI
SQLBits XI is in Nottingham, U.K., May 2 – 4, 2013, and I am attending....
2013-01-03 (first published: 2013-01-02)
1,033 reads
The Great Blog Move of 2013
For at least a year, I’ve been considering changing blog platforms. I set up my blog on TimMitchell.net using BlogEngine.NET...
2013-01-03
905 reads
Vote for my SQL Bits sessions
“Rob? Tsk tsk tsk. That’s a naughty word. We never rob. We just sort of borrow a bit from those...
2013-01-03 (first published: 2013-01-02)
1,601 reads
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...
2013-01-02
1,757 reads
Free SQL Server Learning Resources - Jan'2013
Database Normalization (some useful links)
http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples
SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm
SQL Server Database Administration
DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/
DBA Best Practices
http://www.bradmcgehee.com/presentations/
Free eBooks (to...
2013-01-02
3,393 reads
Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
3,978 reads
Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,188 reads
sp_spaceused system-stored procedure
You can use the sp_spaceused system-stored procedure to return space usage information about a database or a table within a...
2013-01-02
1,512 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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