A Self-Serve System to Refresh Databases (Part 3)
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
2,395 reads
Ben Kubicek
A Self-Serve System that Allows Developers to Refresh Databases (Part 2)
Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.
2019-05-09
3,750 reads
A Self-Serve System that Allows Developers to Refresh Databases (Part 1)
Empower developers to refresh their own test systems with production backups.
2019-05-02
5,553 reads
Who should have Sysadmin rights?
The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.
2019-03-11
101 reads
Two Things I Would Change in SSISDB Setup
I suggest these two changes to the SSISDB setup to prevent issues down the road.
2019-01-11 (first published: 2016-03-29)
4,261 reads
2019-01-07
88 reads
I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2018-12-11
107 reads
2018-11-15
120 reads
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
45 reads
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
694 reads
Blogs
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method
Yesterday in this post I described a method to correct permissions when upgrading a...
Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
One machine is not able to connect to sql server while others connect fine
One of our machines is not able to connect to sql server It gives...
Changing SQL Port from Dynamic to Static
If I have been asked to change the SQL Server port from Dynamic to...
Ask SSC