SQL Bits IV - Call for Presentations
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
2008-12-30
925 reads
Articles
Scripting INSERTs
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,650 reads
Calculations Made Outside of the Data Warehouse
At first glance, a client appeared to be violating a cardinal rule of data warehousing. However, Bill Inmon's further investigation revealed that perhaps their actions were acceptable.
2008-12-29
2,789 reads
The Year in Review 2008
Steve Jones looks back at the past year and database news that has occurred.
2008-12-29
70 reads
The Year in Review 2008
Steve Jones looks back at the past year and database news that has occurred.
2008-12-29
71 reads
The Year in Review 2008
Steve Jones looks back at the past year and database news that has occurred.
2008-12-29
68 reads
Using OPENROWSET to read large files into SQL Server
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
2008-12-29
6,687 reads
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
729 reads
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
719 reads
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
945 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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