SQL Saturday 370 – Phoenix
Thank you to everyone who attended my session – Make Your DBA Happy: 5 Habits Developers Can Implement Today. If you missed the session you can watch the pre-recorded video (from a prior SQL Saturday) here. The slide deck is available here. Enjoy!
SQL Saturday #279 – Phoenix
Here is the video from my SQL Saturday #279 session on developer best practices & good habits to help DBAs keep the server healthy and secure. Please excuse the fact I was dealing with a sinus & chest infection during the presentation, then halfway through the camera died & we had to switch to Lauri’s Windows Phone…such a superior product! You’ll notice halfway through the presentation the resolution changes, and I apologize. Next time I do a speaking engagement I…
SharePoint Saturday Phoenix 2013
If you attended my session on Connecting a SharePoint list to a SQL table for CRUD ops, thank you for coming! If you missed it, or if you wanted to review it again, my girlfriend was kind enough to record it for everyone! The projector can be difficult to see due to room lighting, but you can always follow along with the slide deck. Both are included in this post: Slide deck
Get the first occurrence of a character in SQL
(Originally posted September 2, 2009) When I need to know the first (or any) occurrence of a character, I’m used to saying something like InStr() for VB or ASP, or String.IndexOf() in .Net, but when I tried to do something like this in SQL for a substring portion of a query I was creating, those obviously aren’t available. In Oracle InStr is available, but we`re talking about SQL. To get the first occurrence of a character in a TEXT field (emphasis…
Get first occurance of a character in SQL
When I need to know the first (or any) occurrence of a character, I’m used to saying something like InStr() for VB or ASP, or String.IndexOf() in .Net, but when I tried to do something like this today (Sept 2009) in SQL for a substring portion of a query I was creating, those obviously aren’t available. Well, in Oracle InStr is available I understand, but we`re talking about SQL. To get the first occurrence of a character in a TEXT field…