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
4 reads
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
6,886 reads
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
2 reads
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On...
2015-09-15
2,762 reads
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
1 reads
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,256 reads
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
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,034 reads
In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the send_queue and redo_queue. In this post I’m going to...
2015-06-17
5 reads
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup...
2015-06-10
1,285 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
I am using the following script to import data from a json file. This...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers