PASS 2009 Summit Site Open
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
587 reads
Blog Posts
Tips for Submitting Speaking Abstracts to the 2009 PASS Community Summit
As most of you know now, the Call for Speakers for the 2009 PASS Community Summit is open from March...
2009-03-24
967 reads
Data Mining With Google Insights For Search
I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at...
2009-03-23
844 reads
Overload & Stress - Part 1
As I gain more experience I've found that stress comes in three forms; stress that is there that you don't...
2009-03-23
582 reads
Policy Based Management - On Change Prevent, Doesn't
SQL Server 2008 introduces "Policy Based Management" (PBM) as a way to better manage your servers. This was a feature...
2009-03-23
2,515 reads
Heads I win, Tails You Lose
Imagine going to a casino with $100 dollars to gamble. As you enter, you notice a vending machine that sells...
2009-03-22
629 reads
PASS 2009 Summit - Call for Speakers is Open
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard...
2009-03-22
746 reads
Grinding
I've been amazed at the amount of content that I am getting at SQLServerCentral. So far, in 2009, I've received...
2009-03-20
634 reads
Kindle – DCMA Invocation
I’m not sure how I feel about Amazon invoking the DCMA clause to prevent other e-books from being read on...
2009-03-20
990 reads
Audi A4 Production
I found a cool video on the 37 Signals blog that showed the Audi A4 production process. It’s relatively low...
2009-03-19
778 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