The TSQL DATEPART Function
You can use the TSQL DATEPART function to extract individual parts of the date from a date or time item. For instance: Will return the… Read More »The TSQL DATEPART Function
SteveStedman
MySQL JOIN Types Poster
So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between… Read More »MySQL JOIN Types Poster
Help Support The Database Health Project
Due to the increased demand on my time to complete the next beta of Database Health Monitor, I have created an IndieGoGo campaign to help… Read More »Help Support The Database Health Project
SQL Server Join Types Poster (Version 2)
Try our JOIN types course today! So many times I have been asked for help with a query, where the question really comes down to… Read More »SQL Server Join Types Poster (Version 2)
Epic Life Quest Level 1 – partially completed today.
After being inspired by reading about Brent Ozar’s Epic Life Quest, I created my own Epic Life Quest list, and for level 1 one of… Read More »Epic Life Quest Level 1 – partially completed today.
Simple Introduction to TSQL Cursors
A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a… Read More »Simple Introduction to TSQL Cursors
Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461… Read More »Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
Today’s Live Training: Using Cursors and TSQL String Functions
Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free.… Read More »Today’s Live Training: Using Cursors and TSQL String Functions
Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD
Here is our simple cursor example showing both FAST_FORWARD and FORWARD_ONLY cursors. A FAST_FORWARD cursor in SQL Server is a type of forward-only, read-only cursor… Read More »Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD