Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,770 reads
Blog Posts
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012 Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator) ...
2012-11-21
5 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Bob Hovious
Gail Shaw (sqlinthewild)
Ed Watson...
2012-11-21
1,441 reads
Notes from SQLSaturday #168 in Tampa
I made a quick trip to Tampa for #168 this past weekend. It was a “BI Edition” and it felt...
2012-11-21
944 reads
PASS Summit 2012 Recordings Available
Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy...
2012-11-21
1,242 reads
Top 3 Books on Writing Transact-SQL (TSQL)
This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...
2012-11-21
957 reads
[video] Inside Tempdb - Bob Ward
Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...
2012-11-20
2,474 reads
Blogging for Beginners
Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...
2012-11-20
981 reads
CTEs beyond SELECT
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,980 reads
Explore file physical structure - fixed length row
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
1,060 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers