A tale of updating a legacy system bug
Even simple changes that don't look like they will affect anything often do.
2020-01-07
2,341 reads
Ben Kubicek
How Do You Act When You Need to Learn New Technology?
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
426 reads
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,492 reads
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,835 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,705 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
130 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,471 reads
2019-01-07
96 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
118 reads
2018-11-15
121 reads
Blogs
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore...
Understanding Disk Performance and IOPS in cloud platform
By nelsonaloor
In the past many years, apart from working as DBA, I was working with...
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...
Forums
How to make join to teams display without join all teams ?
problem How to make left join to only teams displayed dynamically depend on fields...
sql server memory buffer cache building up question
question for DB Gurus when sql server is restarted, it will be slow at...
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Ask SSC