RSS Newsfeed Workbench
Robyn and Phil decide to build an RSS newsfeed in TSQL, using the power of SQL Server's XML.
SQL Server Password Management:
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
Revisit What You Know
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
The July Car Update (2007)
Steve Jones bimonthly car update looks at driving in the UK and the differences in cars between the US and elsewhere.
AJAX Stock Symbol Drop-down List
A web look up of a huge list of stock symbols from an MS SQL database.
10 tips for sorting, grouping, and summarizing SQL data
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
A Discount on SQL Populator
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
CLR: 9 Reusable Parallel Data Structures and Algorithms
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
SQL Server Spotlight on Len Wyatt
Project REAL was an amazing undertaking by Microsoft to put SQL Server 2005 to the test in a real environment. One of the main people working on this was Len Wyatt, who agreed to take a few minutes and share some thoughts with us.
To Wrap or Not to Wrap
It's not a string manipulation article in T-SQL, but it is SQL Server related. Check out what Steve Jones has in store for the PASS 2007 Summit for the SQLServerCentral.com community..
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