T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Everything about SQL Server temporary tables: local (#temp), global (##temp), table variables, and when to use each. Includes creation syntax,... 01 August 2020 23 min read
SQL Server Greg Larsen in SQL Server Learn T-SQL: a free guidebook to SQL Server programming Free from Redgate: a beginner's guide to T-SQL covering SELECT statements, joins, GROUP BY, and more. Download the PDF and... 20 July 2020 2 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Tools: Vulnerability Assessment & Config How to use SQL Server Configuration Manager, sp_configure, Vulnerability Assessment, and Data Discovery & Classification to harden an instance.… 29 May 2019 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Catalog Views, DMVs & Functions The key SQL Server catalog views, DMVs, and system functions for auditing permissions, encryption, and logins — with T-SQL query... 23 April 2019 21 min read
SQL Server Robert Sheldon in SQL Server SQL Server Built-In Accounts: sa, dbo, guest & sys What SQL Server's built-in principals (sa, public, dbo, guest, sys, INFORMATION_SCHEMA) do by default, and how to check or change... 26 March 2019 18 min read
Other Louis Davidson in Other Discovering Three or Four Part Names in SQL Server Database Code I am in the middle of a project to enable our corporate databases to work with continuous integration using RedGate... 08 March 2019 6 min read
Databases Robert Sheldon in Databases SQL Server Contained Databases: Users & Portability How SQL Server's partially contained databases work — creating contained users, duplicating them across databases, and unlinking users from logins.… 25 February 2019 15 min read
SQL Server Robert Sheldon in SQL Server SQL Server Access Control: Logins, Roles & Permissions How to create SQL Server logins, roles, and database users, then grant, deny, and revoke permissions on them with T-SQL... 28 January 2019 24 min read
SQL Server Robert Sheldon in SQL Server SQL Server Security Overview: Authentication to Encryption An overview of SQL Server's security toolkit — authentication modes, principals/permissions, encryption, auditing, and vulnerability tools.… 31 December 2018 15 min read
Other Dennes Torres in Other Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Other Louis Davidson in Other I Have an Exclusive Lock, My Row Is Safe, Right? Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was... 06 December 2018 7 min read
Other John Paul Cook in Other Simulating Bad Networks to Test SQL Server Replication SQL Server replication works well on a low latency, high bandwidth network. When actual networks have high latency or limited... 02 January 2018 8 min read
Kalen Delaney SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered... 07 December 2017 2 min read
SQL Server Nat Sundar in SQL Server Automating SSIS Project Deployment with PowerShell: ispac Files, SSISDB Catalog, and Multi-Project Scripts Automating SSIS project deployment with PowerShell - deploying .ispac files to the SSISDB catalog, iterating across multiple projects in a... 27 February 2017 30 min read
SQL Server Robert Sheldon in SQL Server SQL Server Permissions: Principals, Securables & Roles How SQL Server principals, securables, and permissions work together — logins, users, roles, and GRANT/DENY/REVOKE — with T-SQL examples.… 02 August 2016 18 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as... 31 March 2016 22 min read
Enrico van de Laar The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries,... 16 March 2016 7 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either... 15 March 2016 23 min read
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need... 09 March 2016 21 min read
