A ran into a problem where I needed to set certain...

Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.

Create a Feedback Loop between Devs and DBA Teams with Monitoring

by Additional Articles

Redgate

Vendors/3rd-party Products

With remote working still encouraged around the world, there is a need to ensure that operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. Find out how to keep communication flowing between DBA and development teams in this free whitepaper. Read the whitepaper here.

Lean Coffee

by Steve Jones

SQLServerCentral

Meetings

Lean Coffee is a way of organizing a meeting that might not have an agenda.

Stairway to SSAS Tabular Level 11: Partitioning

by Thomas LeBlanc

SQLServerCentral

Analysis Services (SSAS)

In this next level, we cover partitioning for SSAS.

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

by Press Release

Redgate

Transaction Log

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

Why choose Oracle?

by Additional Articles

SimpleTalk

Oracle

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.

Recovering Databases From a Master Backup

by Steve Jones

SQLServerCentral

Losing your instance might result in the need to get information from what you have. Steve Jones looks at a way to get the proper version and patch, and database list, from what limited resources you might have.