Kerberos Configuration Manager for SQL Server v3
By David Postlethwaite
I’m speaking about Kerberos for the SQL DBA at SQL Saturdays in Oslo, Gothenburg and Utrecht in September...
2015-08-05
2,258 reads
Gethyn Ellis
Creating an Azure SQL Database
By David Postlethwaite
Once you have logged in to the Azure Management Portal you can start to create an Azure SQL...
2015-05-28 (first published: 2015-05-21)
5,802 reads
Microsoft Azure SQL Databases – Power and Performance
By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to...
2015-05-28
1,030 reads
Microsoft Azure SQL Database – Dashboard
By David Postlethwaite
Once you have created your database you can now start to manage and configure it.
There are six...
2015-05-26
848 reads
Getting Started with Microsoft Azure
By David Postlethwaite
The URL for Microsoft Azure is http://azure.microsoft.com.
Make sure you have an up to date browser because parts of...
2015-05-19
551 reads
Putting Your Head in the Clouds - Microsoft Azure
By David Postlethwaite
Microsoft Azure
Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in...
2015-05-14
670 reads
Putting Your Head in the Clouds 3 – Cloud Service Offerings
By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being...
2015-05-12
647 reads
Putting Your Head in the Clouds 2 –Advantages and Disadvantages of Cloud Solutions
By David Postlethwaite
If you are thinking about using Cloud Computing then it’s worth considering the pros and cons.
Advantages of...
2015-05-07
560 reads
Putting Your Head in the Clouds 1 – An introduction to Cloud Computing
By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it...
2015-05-06
728 reads
SQL Server 2016 Preview...Coming this Summer
It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With...
2015-05-05
678 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
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