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
947 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
947 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,328 reads
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...
2017-07-20
1,874 reads
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
554 reads
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
1,971 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
4,451 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers