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.
2019-07-03 (first published: 2019-06-28)
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 […]
2019-07-02
135,067 reads
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.
2019-07-02
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!
2019-07-02
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
2019-07-01
2,659 reads
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.
2019-07-01
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.
2019-07-01
This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.
2019-06-28 (first published: 2017-10-17)
9,168 reads
In this article, we discuss how to load large partition tables incrementally.
2019-06-28 (first published: 2017-10-13)
2,516 reads
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
2019-06-28
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers