Today marks the end of life of SQL Server 2005, originally release in November of 2005, this product has finally come to its end of life point. One of my favorite features that was introduced in SQL Server 2005 was Common Table Expressions. Another big item that was added to SQL Server 2005 was the SQL Server Management Studio. Its …

SQL Server 2005 End of Life – End of Support Today Read more »

The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server, it is not turned on by default. What Optimize for Ad Hoc Workloads Changes. Without the Optimize for Ad Hoc …

Optimize for Ad Hoc Workloads Read more »

IF you are browsing your error log and come across an error message stating that “1 transactions rolled forward in database ‘msdb’”, or “X transactions rolled back in database ‘msdb’” you might be a bit alarmed. You might also notice similar error messages for master, tempdb or user databases.   How can this be a good thing? Why are transactions …

Transactions Rolled Back in Database Read more »

Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at the following link: https://www.youtube.com/steveStedman   Most of the focus has been around training people for the 70-461 exam certification. Full Length Free SQL Server Training Videos Some of these are full length at around an …

Free SQL Server Training Videos Read more »

Its not always quick and easy in SQL Server to get a full list of the jobs that have been run, when they were run and how long they took. I created the following script to quickly check on the status and run time of SQL Server maintenance plans and jobs. Display Job History Just run the script in SQL …

SQL Server Script to Display Job History Read more »

Yesterday I was asked by a client about consulting questions and for my help without the typical minimum hourly commitment. He pointed out that he has things that he could use help with that don’t require a multi-hour type project. After thinking it over a bit, I decided to add a SQL Server coaching program to my consulting business, I …

SQL Server Mentoring – Now Available Read more »

You have a need to keep track of all insert, update and delete actions on a table, or multiple tables. As you consider solutions, you might think about using a trigger, however triggers have their own baggage. You consider using the OUTPUT clause to log to a changes table, but then realize that the output clause cant be enforced. Then the …

TSQL – Change Data Capture Read more »

>>> Try our JOIN Types Course Today! Today’s training will be on JOINs.  Here is the outline for the training. —Basic SELECT —INNER JOIN —LEFT OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN with exclusion —RIGHT OUTER JOIN with exclusion —SEMI JOIN —ANTI SEMI JOIN —CROSS JOIN —FULL OUTER JOIN —FULL OUTER JOIN with exclusion —CROSS APPLY —OUTER APPLY —Multiple …

TSQL Training: JOINs Read more »

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given month, or a future or past month by using the second parameter of offset. EOMONTH was introduced in SQL Server …

Using The TSQL EOMONTH Function Read more »

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the DATEADD video tutorial: See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 exam preparation