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,908 reads
Anthony Nocentino
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
5 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 from GitHub – here!
Installing PowerShell Once you’ve downloaded...
2016-08-18
7 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
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 things are done, moves the bar…well last week...
2016-08-18
6 reads
New Pluralsight Course – LFCE: Advanced Linux Networking
My new course “LFCE: Advanced Linux Networking” in now available on Pluralsight here!
This course targets IT professionals that design and maintain RHEL based...
2016-08-16
580 reads
New Pluralsight Course – LFCE: Advanced Linux Networking
My new course “LFCE: Advanced Linux Networking” in now available on Pluralsight here!
This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with the Linux Foundation Certified System...
2016-08-16
6 reads
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I...
2016-07-31
645 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers