This has been replaced with a new updated version of the poster. Click here to visit the new page. >>> 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 the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this …
On Tuesday March 24th at Noon the Bellingham SQL Server Users Group will have its monthly lunch networking meeting at Buffalo Wild Wings at Bellis Fair Mall. This is open to everyone who is a member of the Bellingham SQL Server Users Group (PASS Chapter). See you there! -Steve
In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a result set one row at a time. It may not be the best way to work with a set of data, but if you need to loop row by agonizing row (RBAR) in a T-SQL …
T-SQL: A Listing Databases Example Using a Cursor Read more »
Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s. What amazes me is how many people after the training will tell me that they didn’t know about using the GO command to run a statement multiple times. Here’s how it works. First lets create a table, …
On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, followed by Using String Functions. This is provided free of charge to give back to the SQL community. Here is …
Using Cursors, followed by Using String Functions Read more »
Next week as part of the free SQL Query training that Aaron Buma and I provide, the topic I will be presenting is cursors. How to use them, what they are, everything you ever wanted to know. My concern in this presentation is that cursors have caused me many headaches in regard to performance over time. The main problem that …
As part of our weekly free SQL Query Training, we have split the 70-461 curriculum into 4 sections to prepare everyone to take the certification test later in the year. Today’s session is to review the first 25% of the sessions, or the section 1 review as we are calling it. The review topics we will be covering today are …
Aaron Buma and I, with help from the Professional Association for SQL Server (PASS) have formed an official PASS chapter called the Bellingham SQL Server Users Group. Here is the description of what a PASS Chapter is: PASS Chapters are local user groups that meet regularly in communities around the world to share their passion and knowledge about Microsoft SQL …
Announcing the new Bellingham SQL Server Users Group (PASS Chapter) Read more »
On March 10th, 2015, the first meeting of the Bellingham SQL Server Users Group will be held. This is the first ever meeting of the Bellingham SQL Server Users Group. This week will be our first ever meeting, and I will be presenting on SQL Server Performance Tuning.
We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts every Thursday at 9:00am Pacific time. To celebrate the 25% mark, and to strengthen the training we have decided to do a review session on everything that we have covered so far. Null Expressions Identity …