New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features
Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]
In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.
Outages can be expensive, and today Steve asks if you know just how expensive they are for your organization.
Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.
SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
Data loss shouldn't come from simple misconfiguration. As Steve notes, if no hacking is involved, you shouldn't lose data.
Learn how to restore sql server database using data management provider Rubrik REST API
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers