Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.
In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.
In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
Today, Kendra Little explains why a query may run faster the second time you run it.
If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.
Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands. However, there are some additional considerations that should be considered when using them in the context of Azure SQL Database deployments.
Learn how to correctly fix your SSISDB without using Trustworthy.
In this article author Joe Gavin covers how to transfer files using SFTP with a SQL Server Agent job.
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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