Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted colour. Please use the format #RRGGBB for all colours.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologise for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double-check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Post code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Cheque.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Job titles must be less than 50 characters.
Please enter a donation amount.
Please select an attendee for donation.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organiser email address.
Your order was cancelled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
This session takes you through 50 of the most challenging and commonplace patterns and anti-patterns when writing SQL and Transact-SQL code and shows how to deal withthem all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful
Kevin Kline (blog | twitter) is the Director of Engineering Services at SQL Sentry, and a founding board member & former President of the international Professional Association for SQL Server (PASS).
A top rated speaker, Kevin appears at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, SQL Connections, and the Best Practices Conference.
When Kevin isn't working on technology issues, he enjoys spending time with his wife Rachel, his four kids, his three stepkids, and his Basset Hound and Ginger Kitty.
What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.
In this session, you’ll learn:
Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags.
Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability.
A varietyof patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers.
With these 50 tricks and techniques in your coding toolkit, you’ll be able to write T-SQL code that consumes less system CPU, memory, and IO, while being easier to maintain and offering faster performance.
Prerequisites: Intermediate competence in SQL and Transact-SQL syntax, such as coding with DML, DDL, and DCL transactions, using cursors and variables, and invoking functions and procedures. Basic familiarity with reading execution plans.
Goal 1: Learn how to build credibility and influence within your IT team.
Goal 2:Discover the interpersonal and communication skills that enable you to survive and bounce back quickly from hard times.
Goal 3:Explore key organizational concepts that enable you to ensure your job is always safe.
The SQL Server Ireland User Group was founded in 2006 to foster & grow the Irish SQL Server community while providing networking opportunities & sharing experiences using SQL Server.
This group is a local chapter of PASS - The Professional Assosciation for SQL Server (www.sqlpass.org)
Meetings are held most months, usually in the evening of the first Tuesday of the month. We do collaborate with others to support larger conference events from time to time; including the highly successful SQL Saturdays.
Loading your connections...
Share 50 Things All SQL Server Developers Need to Know
Share Tweet