Vendors/3rd-party Products

Technical Article

SQL Clone for Unit Testing Databases

  • DatabaseWeekly

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.

You rated this post out of 5. Change rating

2019-05-14

Technical Article

Monitoring your servers and databases with SCOM and SQL Monitor

  • DatabaseWeekly

SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.

You rated this post out of 5. Change rating

2019-05-14

Technical Article

Reporting on the Status of Clones During Database Development

  • DatabaseWeekly

Phil Factor uses SQL Clone, PowerShell and Visio to build a live 'clone network' diagram showing when there was last activity on each clone, and the number of object changes made to each one, alongside useful metadata such as the clone and image sizes, who created them and when.

You rated this post out of 5. Change rating

2019-04-05

Technical Article

How monitoring can help keep your SQL Server estate secure

  • DatabaseWeekly

Using broad SQL Server monitoring can instantly alert you to unusual activity or patterns across your entire estate, letting you can act fast to resolve problems and keep your systems online, secure, and compliant. Read our new SQL Server security white paper today and start using your monitoring to its fullest.

You rated this post out of 5. Change rating

2019-04-05

Technical Article

Simplify and improve your security model with SQL Census

  • DatabaseWeekly

In the R&D division of Redgate, Foundry, we’re working on a new tool, SQL Census, in an effort to make your SQL Server permissions more manageable by seeing who has access to your servers and restructuring existing access rights into a simpler and more compliant format.

You rated this post out of 5. Change rating

2019-03-30

Blogs

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

By

I am excited to host T-SQL Tuesday for the first time. I want to...

A Daily Report from Claude

By

Redgate had some Claude training recently, which I went through as my knowledge has...

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Read the latest Blogs

Forums

ALAMAT BCA KCU JAMBI 082225313145 WA CS

By Layanan_BCA_24jam

WhatsApp 082225313145 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...

Demo Tracking Dropped Objects

By Artur Sanin

Comments posted to this topic are about the item Demo Tracking Dropped Objects

Randomly Selecting Columns and Rows from a Table or View

By Artur Sanin

Comments posted to this topic are about the item Randomly Selecting Columns and Rows...

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers