Using the INSERT Statement
How to use an INSERT statement to add records to a table in SQL Server. We will begin with just a simple INSERT statement that will add one row into the table.
SQL
IDENTITY Columns
How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.
Delete vs Truncate vs Drop
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
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…
MCSA: BI Reporting
Finally! You can see by the dates below, I took these two beta exams last fall. Well, today they were finally graded. I took both of these without studying and just went in cold. So I am a little surpised that I passed both of them on the first try….
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…
Free SQL Performance Scripts
This is why I love Twitter to keep up with the #SQLFamily. A question was asked by Chrissy LeMaire about scripts that Microsoft PFEs use on the job. David Peter Hansen responded with this great list of tools for Performance Troubleshooting. I’m definitley adding it to my suggested links.
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.
Lincoln SQL User Group
I will be speaking tonight at 7pm EST for the Lincoln, Nebraska SQL User Group. Here is a link to my powerpoint presentaion. You can also watch my YouTube version of this presentation here.
SQL Workbooks
So Kendra Little is starting a SQL Workbooks website where she will be helping people learn SQL Server by solving problems. I have always enjoyed her presentations and hope she is very successful in this new adventure.Visit her website and check out the courses.