Load Testing Your Storage Subsystem with Diskspd – Part III
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output...
2015-10-04
3,644 reads
Anthony Nocentino
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...
2015-09-29
12 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...
2015-09-22
7,217 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....
2015-09-22
6 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On...
2015-09-15
2,830 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On a new system this is critical because I want...
2015-09-15
8 reads
Pluralsight Authoring – Upcoming Course
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on...
2015-08-29
1,264 reads
Pluralsight Authoring – Upcoming Course
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the...
2015-08-29
4 reads
Monitoring Availability Groups with Redgate SQL Monitor
Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.
2015-07-07
2,913 reads
Monitoring Availability Groups with Redgate SQL Monitor
In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the...
2015-06-17
5,066 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