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
1,800 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,291 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
4,928 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
81 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)
3,741 reads
2019-01-07
68 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
105 reads
2018-11-15
118 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
43 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
577 reads
Blogs
Keynotes in Australia and New Zealand
By Steve Jones
I get to do the SQL in the City Summit keynotes in Australia and...
Event Log File Paths
How does one consistently find the correct path to the Extended Event Log file...
Clearing an Email from the Microsoft Directory
By Steve Jones
Years ago I was working on a demo with Microsoft and someone added me...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
DBA Walkthrough – Adding space on IBM AIX Power Machines
Comments posted to this topic are about the item DBA Walkthrough – Adding space...
The Datatimeoffset Value
Comments posted to this topic are about the item The Datatimeoffset Value
Ask SSC