(Jason Brimhall) The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that provides the execution environment for all .NET Framework code. One may sometimes refer to CLR code as managed code.

(Sergio Govoni) SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex.

Workloads that rely on auto-commit (each operation like an INSERT has an implied, corresponding begin and commit transaction) and perform a large number of small transactions may take significantly longer to complete when run against availability group databases configured for synchronous commit.

(Pinal Dave) A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value?

(Jack Vamvas) Question: I’m trying to figure out how to calculate when SQL Server wait statistics were last cleared.

(Tim Radney) If you’ve been considering moving your SQL Server environment to Azure, you’ve only had a couple of options. First you could utilize the PaaS solution of Azure SQL Database and move a single database or use an elastic pool. Your other option has been an IaaS solution using Azure Virtual

(Greg Larsen) Security of data is a hot topic these days. One of the security concerns auditors have is whether or not your SQL Server data is encrypted when stored At-Rest–meaning auditors would like to see all data encrypted on the actual disk platters that store the data.

(Rajendra Gupta) SQL Server 2017 has just been released and with most releases there are changes that you need to be aware of. One of the changes in SQL Server 2017 is that the SQL Server Reporting Services (SSRS) installation is not part of the regular SQL Server installation. In this tip, we will

(Michael J. Swart) It’s been frowned on for a while, but SHA1 is definitely broken for security purposes.

(RDORR) SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication activities. Thus, Kerberos is the path for success for AD authentication and just in case you have to troubleshoot a problem I have a few tips.