2020-10-29
2,321 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
Who is the best person for the job?
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
2020-04-09
103 reads
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,378 reads
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)
430 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,606 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,925 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,916 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
227 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,722 reads
2019-01-07
105 reads
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
How can I exclude records from this table?
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Disable Package Expression
Hi SSC, I've got 2 Project Variables which I use to control wether a...
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
Ask SSC