Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full.
Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.
One of the greatest things that has arisen in the past 10 years or so is a veritable stream of great conferences for people to learn how to write better software, many of them low cost or even free. In the Data Platform community, we have had nearly 800 free SQL Saturday events around the […]
Steve Jones talks a bit about the difference between state based and migrations based approaches for deployment.
In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
What types of sessions are important in a conference schedule? Steve Jones talks a bit about the lack of tuning sessions.
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
Brent shows what Perfmon counter to watch after your SQL Server restarts.
Steve talks about the importance of test data and how to get it in development environments.
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers