Don't Forget the Network
A few weeks ago I was looking at a query and got tripped up by the network and my own forgetfulness. It was a pretty simple query with a...
2017-06-12
4 reads
Blog Posts
GroupBy Conference – SQL Server & Containers
Morning all, busy week last week as I was lucky enough to have my session on SQL Server & Containers in...
2017-06-12
280 reads
I’m Speaking! Capital Area SSUG
I like it when I get referred to speak at various functions. Whether it’s a user group, conference or just...
2017-06-12
311 reads
I’m Speaking! Capital Area SSUG
I like it when I get referred to speak at various functions. Whether it’s a user group, conference or just...
2017-06-12
99 reads
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-06-12 (first published: 2017-05-30)
3,898 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In this post, we’re going to leverage that configuration and...
2017-06-12
3 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In...
2017-06-12
745 reads
Setting up Cross Database Queries in Azure SQL Database
A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL...
2017-06-12 (first published: 2017-05-30)
3,450 reads
SQL Server 2017 – DMF – sys.dm_db_log_info
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...
2017-06-12
963 reads
SQL Server 2017 Graph Data Features In Action
The Wikipedia Graph Database page has the following definition…
In computing, a graph database is a database that uses graph structures...
2017-06-12
109 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
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...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers