Encryption in Colorado Springs – Encrypting in the Application?
Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I...
2014-11-20
924 reads
Blog Posts
FUD Makes Security Harder
The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported...
2014-11-20
682 reads
How to disable constraints of a table ? TIP #74
You are reading this post just because of two reason
1) You are curious whether it is possible or not...
2014-11-20
281 reads
In-Memory Virtual Chapter Co-Lead
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
275 reads
Nominated for Author of the Year
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at...
2014-11-20
519 reads
Practical Problems with CI
I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more...
2014-11-20
801 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place and you want to add Sql Server tests it...
2014-11-20
6 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
17 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
60 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
52 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers