SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
2009-10-23
1,608 reads
Blogs
Transparency and PASS
I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...
2009-10-22
1,151 reads
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
2009-10-21
1,724 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-20
2,666 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-19
3,076 reads
Work on a Strength or Weakness?
When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness? I think many people focus mostly on their strengths because they have a goal of really standing out in something. They perhaps want to avoid being..
2009-10-16
1,577 reads
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
2009-10-15
1,219 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-14
1,825 reads
Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-13
6,074 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