Browsed by
Tag: SQL 2008 R2

SQL Saturday #279 – Phoenix

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…

Read More Read More

SharePoint Saturday Phoenix 2013

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

Validating email string without using sp_OACreate in T-SQL

Validating email string without using sp_OACreate in T-SQL

I wanted a way to validate that an email address in a SQL query was well-formed, and found a lot of resources suggesting to create a scalar function that invokes sp_OACreate among others, and return a bit indicating if it was valid or not.  That works great, but not for those of us in heightened security environments, where granting execute permissions to system stored procs and functions is not permitted.  After searching around I came up with the following function:…

Read More Read More

Get the first occurrence of a character in SQL

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…

Read More Read More

Enabling editing of SQL 2000 DTS in SSMS 2008 R2

Enabling editing of SQL 2000 DTS in SSMS 2008 R2

We have some old SQL 2000 DTS Packages that we still maintain, and I’m not continuing to install SQL Enterprise Manager on future versions of my OS just to edit these things, I should be able to edit them in SSMS right?  Well, yes, but it requires a couple of steps, that so far in my Google research is never complete…it’s always a part of the entire solution. (PINTA) Well, here’s the entire solution: First, go to http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988 and download/install the SQLServer2005_BC.msi…

Read More Read More