Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL Developers for the 70-461 certification exam. Here is the basic abstract for the presentation: This will be a free training …
Next Week’s Free SQL Training: MERGE Statement and Recursive Queries Read more »
I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is the video: It’s a very short video with the basics of what a CTE is. Take a look. Other …
Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of the OUTPUT clause with UPDATE statements. Generally when you do an UPDATE statement you only get a row count returned, you don’t generally get a result set showing what was changed. With the OUTPUT clause …
I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification, Aaron Buma and I we have worked out a plan to get everyone on the development team through this training. …
I released Database Health Monitor Beta version 9.2 today. No new features, just lots of bug fixing. I don’t want to make it sound like database health reports is unstable, it is very stable, however with any software there are occasionally unexpected things that cause a crash. My goal is to get Database Health monitor as close to zero crash …
Uzility is introducing the new board background images. Anyone using Uzility can set a custom background image on any of their boards. This is a new per user setting, allowing for the personalization of the agile board that everyone should have access to. Some competitors offer the ability to set the background image only in their premium package. This new …
I have worked with some agile product owners who when the write user stories, the like to go epic on the acceptance criteria, in fact when you read their acceptance criteria it almost looks like a complete functional specification crammed in to acceptance criteria. Other product owners simply write a user story and expect that all acceptance criteria will …
For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls. This presentation is a lot …
What a great time at Startup Weekend Bellingham this wekend. Now that I have had a chance to catch up on sleep and get back into my normal routine, I figured its a great time to write a summary. How it all worked, the brief summary: Friday night we pitched ideas to the group of about 70 people. The pitches …
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on the line up that I am looking forward to learning from. I will be presenting 2 sessions on Common Table …