Redgate's second annual State of SQL Server Monitoring survey provides new insights into how the world of SQL Server monitoring is adjusting and adapting to emerging challenges, such as compliance regulations and cloud technologies, while keeping on-top of the usual issues such as deployments, availability, and capacity.
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
Today Steve talks about the soft skills and why these might be important as you advance in your career and grow into a senior role.
Phil Factor demonstrates the basics of how to automate database builds into a Linux SQL Server container running on Windows, and then backup the containerized database and restore it into dedicated containerized development copies for each developer and tester.
Need to know how to use the “Filter” item in the SSMS Object Explorer Details window to show a specific list of tables that contain a specific string of characters? If so, then read on!
The California Consumer Privacy Act takes effect in a year and there is lots of work to be done. One firm is trying to help companies get ready.
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.
In this article, Kellyn Pot’Vin-Gorman continues teaching SQL Server DBAs how to navigate Linux. She demonstrates usings aliases, setting up environment variables, and examining processes.
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Wa:0817-866-887 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
Telp Cs: (0821)8200174 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan,...
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers