SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
954 reads
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
954 reads
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,339 reads
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...
2017-07-20
2,042 reads
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
605 reads
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,114 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
5,033 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Find affordable and reliable medical insurance tailored specifically for truckers with Trucker’s HealthCare. Designed...
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers