Open Source PowerShell – Play by Play
What’s going on here? So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to?...
2016-09-16
9 reads
Anthony Nocentino Blog
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
477 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
6 reads
Using Extended Events to Visualize Availability Group Replication Internals
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and...
2016-08-29
1,907 reads
Using Extended Events to Visualize Availability Group Replication Internals
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of...
2016-08-29
4 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell?
In Linux systems you’re given options,...
2016-08-20
717 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell? In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove...
2016-08-20
7 reads
Getting Started With PowerShell on Linux
Getting PowerShell on Linux
Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now...
2016-08-29 (first published: 2016-08-18)
1,478 reads
Getting Started With PowerShell on Linux
Getting PowerShell on Linux Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now from GitHub – here!
Installing PowerShell Once you’ve downloaded...
2016-08-18
5 reads
SQL Server, Persistent Memory on NVDIMMs and DAX
Paradigm Shift!
What do I mean by that? Every once in a while a technology comes along and changes the way...
2016-08-18
2,185 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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