2009-01-22
573 reads
Articles
2009-01-22
536 reads
SQL Server Integration Services an Introduction - Part 2
This article is part 2 of a 4 part series that introduces SQL Server Integration Services (SSIS). This article shows how to use the Data Flow Task in SSIS.
2009-01-22
3,792 reads
Moving Tables and Indexes to Filegroups En Masse
Longtime author and SQL Server expert David Poole brings us a method to
2009-01-21
8,039 reads
It's minus twenty-five outside and I'm writing about Transaction Log Files
I originally wrote this in French while working at LaCaisse.com "Why do you care, as a DBA (or a developer for that matter), about what is happening in the transaction...
2009-01-21
1,896 reads
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
428 reads
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
501 reads
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
779 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
523 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
66 reads
Blogs
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...
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...
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