SQL Server authentication vs. Windows authentication: Which to use and when
Authentication is a critical component of security. Learn how SQL Server authentication works and how it differs from Windows authentication.
When and how to use the SQL PARTITION BY clause
Learn when and how to use the SQL PARTITION BY clause in SQL Server and how it differs from the GROUP by clause.
Exploring Postgres date formats and their different functions
Learn how to use multiple Postgres date functions to convert a date type to the required time zone, format or specific information.
Exploring the different constraints in SQL Server
Find out about the various types of constraints in SQL Server and understand the advantages they offer when implemented.
A beginner’s guide to SQL tables
Explore this guide to learn about SQL Server tables and best practices to consider when creating user-defined tables in SQL Server.
Using database schemas in SQL Server
Dive into what database schemas are, their advantages and what is needed to create and employ SQL Server schemas.
13 SQL Server security best practices
Explore 13 SQL server security best practices to create a more secure and non-disruptive database service for your business.
How to use UPDATE from SELECT in SQL Server
Learn the different methods for using the UPDATE from SELECT statement in SQL Server and explore their performance comparison.
Various ways to use the SQL CONVERT date function
Learn how to use the SQL CONVERT date function to get the specific date format you need, as they can vary between different countries.
An overview of SQL Join types with examples
Learn all about the different SQL join types and important best practices to remember and apply when using SQL joins.
Demystifying CXPACKET and CXCONSUMER wait types in SQL Server
CXPACKET and CXCONSUMER wait types in SQL Server are common occurrences when managing database performance. Learn how to fix them.
Avoiding SQL deadlocks with query tuning: Advice from Brent Ozar
Learn more about the ways to fix concurrency issues like SQL deadlocks or blocks from Brent Ozar, Microsoft Certified Master.