If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
887 reads
2019-03-22
62 reads
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
2019-03-18
67 reads
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
90 reads
2019-03-15
112 reads
2020-02-19 (first published: 2019-03-14)
444 reads
Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.
2019-03-13
61 reads
Technical debt can cripple software development, much like financial debt hurts individuals and organizations. Steve wants to know if you measure your debt today.
2019-03-12
91 reads
Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.
2019-03-11
138 reads
The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.
2019-03-11
949 reads
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Comments posted to this topic are about the item Building Bonds with Entertainment
Comments posted to this topic are about the item Closing a Symmetric Key
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...
Ask SSC