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,303 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)
423 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,471 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,819 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,663 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
109 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,383 reads
2019-01-07
94 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
116 reads
2018-11-15
120 reads
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
Transactions/Second
Hello.Does anybody have a way to identify what transactions ran in an interval (i.e....
How to update status with conflict data where chemical temp table have same chem
How to update status with conflict data where chemical temp table have same chemical...
Blob to ADF to Stored proecure
I'm reading file from BLOB through ADF and I would like to pass the...
Ask SSC