Creating an Azure SQL Database via PowerShell
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,363 reads
Blog Posts
DevOps Basics–Creating a local repo and committing files
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-11
581 reads
Dynamic SQL and the joys of QUOTENAME
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
613 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
45 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
5 reads
PASS Summit Call for Speakers
Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions...
2017-05-11
6 reads
PASS Summit Call for Speakers
Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov...
2017-05-11
547 reads
SQL Server on Linux Series: Why?
As you all have heard, Microsoft is supporting Linux as a supported operating system for the next version of SQL...
2017-05-11
745 reads
SQL Server Wait Types Library – UPGRADED!
Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...
2017-05-11
363 reads
Copying files from/to a container
Last week I was having an issue with a SQL install within a container and to fix I needed to...
2017-05-10
2,097 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