What is SQL?
What is SQL? What is the difference between SQL the language and SQL the server?
SQL Server
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Table Constraints
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
What is a Schema?
The term schema could mean several different things. What are the different meanings and how are schemas are used in SQL Server.
70-765 SQL Admin Exam
I finally passed the 70-765 exam. This finished up the MCSA: SQL 2016 Database Administration certification and also re-earned the MCSE: Data Management and Analytics certification for 2018. I will say that this exam was not easy. The questions themselves are not that bad, but just the sheer amount of…
In-Memory OLTP
Free ebook: 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 in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications…
SQL Operations Studio
Introducing Microsoft SQL Operations Studio, which is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines. To find out more click here or to download it click here.
Ignite – SQL 2017
This video is from Microsoft Ignite where Bob Ward demonstrated The Fast and Furious of SQL Server 2017. Also, check out this interview of Bob from our friend Cathrine Wilhelmsen.