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.
SQL Server
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.
SQL MCSA Name Changes
The Four new SQL MCSA certifications coming out this fall have had a last minute name change. http://bit.ly/2q8lWPj
Yooper PASS Session
Tonight, I will be speaking remotely for the Yooper SQL Server User Group. I am assuming that Yooper refers to Upper Michigan. You can watch my recorded session on “The PROCESS of Queries” on YouTube.
SQL Server 2017 Released
Announcement from #MSDataAmp SQL Server 2017 is here. Also check out this blog post on AI built into data services. Watch the entire #MSdataAmp webinar as well as a series of deep dive sessions on each of the new SQL Server 2017 features. Available here.