Using Microsoft DiskSpd to Test Your Storage Subsystem
Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.
Live Query Statistics in SQL Server 2016
SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active query, giving a fantastic opportunity for troubleshooting and debugging.
Your Portfolio
Putting together a portfolio allows you the chance to showcase what you're good at doing. Steve Jones thinks this might be a good thing for technical people.
Getting the Measure of Your Application
The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers that developers seem to resent the idea that applications should be designed and developed so as to be measurable. Tony Davis looks at the issue.
Mission Critical Deployments
Is a software deployment responsible for a plane crash? That's a scary thought.
Nope to NoOps, No way to NoDBA
Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.
MySQL Error Handling using the Signal and Resignal Statements
MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.
How many environments?
This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Lab's Leading FSSAI Third Party Auditing Services
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers