(Rick Dobson) SQL Server offers three types of user defined functions (udf) and in this tip we will cover examples for each of the three major types of user-defined function types: scalar-valued, table-valued and multi-statement table-valued.

(Pinal Dave) Another day and another win against a difficult SQL Server Problem while I worked with my clients on Comprehensive Database Performance Health Check. The best part of my job is that I get to work with different performance problems every time with new clients.

(Glenn Berry) One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario.

(Haroon Ashraf) As a SQL Server database developer, I need to understand and implement the concept of database code branching particularly in the case of state based database development using SQL Server Data Tools (SSDT).

(Nisarg Upadhyay) In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the

(Marcin Policht) Public cloud offers a wide range of benefits, including scalability, agility, and on-demand resource provisioning. While these benefits apply to majority of cloud services, they are most apparent in the context of serverless computing.

(Pinal Dave) One thing I keep on telling my clients that it is not that always recommended to use the latest feature without proper testing. I was recently hired by clients to help them with tuning a query for SQL Server 2019 Comprehensive Database Performance Health Check.

(Jason Brimhall) In my previous article, I demonstrated some fun ways of locking down access for certain users to ensure they did not have data access while at the same time allowing them to review the database schema.

(Percy Reyes) As SQL Server DBAs we may need to generate a script for the creation of all Primary Keys, Unique and Foreign Key constraints. We know with the SQL Server native tools that there is not a way to meet this need all at the same time.

(Kenneth Fisher) A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure how much it’s been used by anyone other than me but so far it appears to be working correctly.