SQL Saturday 203 Boston, Deck and Demos Live!
Hello Dear Reader!
A quick note I'm presenting today at 1:30 pm for SQL Saturday Boston #203.
I'll be giving my...
2013-04-06
472 reads
Blog Posts
Don't Alienate Your Customer
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,030 reads
Remembering Alan Weber, @Aauugold
We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...
2013-04-05
840 reads
Security: People Are the Weakest Link
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,328 reads
The Great Laptop Search of 2013
It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a...
2013-04-05 (first published: 2013-03-28)
3,914 reads
Use delegated session configuration in Powershell 3.0
Powershell 3.0 has many new feature, and they are useful in some circumstance.
let's say User A log in server A,...
2013-04-05
1,197 reads
Weekly Links – 05/04/2013
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,026 reads
Ask the Expert Panel: NJ Special Event
Ever wanted to know all there is to know about SQL Server, and afraid to ask? Have questions about how...
2013-04-04
1,206 reads
How I prepared myself for the MCSE certification
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,482 reads
Is BETWEEN faster than GTE and LTE?
I know I have been light on blog posting this year. They always say that life tends to get in...
2013-04-04 (first published: 2013-03-29)
32,653 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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