Browse by Tags

• Ad-hoc
• Code
• iPod
• Performance
• Policy-Based Management
• SQL Server 2008
• SSIS
• Stored Procedures
• XML

• Policy Based Management Evaluation Modes

  Dan Jones wrote a great post about Facets from the new Policy-Based Management feature of SQL Server 2008. At one point in the post, he listed all of the available facets and their supported evaluation modes. Since SQL Server 2008 is not RTM, and since Read More... Posted Monday, June 16, 2008 4:36 PM by Peter DeBetta | 1 Comments Filed under: T-SQL, SQL Server 2008, Policy-Based Management

• Yet Another Stored Procedure vs. Ad-hoc Query Discussion?

  Earlier today, Will Sullivan posted a blog entry, My Statement on Stored Procedures , in which he emphatically states his official opinion of stored procedures as: "I prefer not to use them." He then goes about dismissing most of the misinformation about Read More... Posted Thursday, April 03, 2008 12:44 AM by Peter DeBetta | 8 Comments Filed under: T-SQL, Code, Ad-hoc, Stored Procedures

• T-SQL Convert Hex String to Varbinary

  One last post before I go on vacation next week... SQL Server 2005 includes an undocumented function, sys.fn_varbintohexstr, that converts a hex value to a string representation of that hex value (0x3a becomes '0x3a'), but there is no function to go back Read More... Posted Friday, March 09, 2007 3:38 PM by Peter DeBetta | 11 Comments Filed under: T-SQL

• T-SQL UrlDecode

  While I'm at it, here is the counterpart to the UrlEncode function – UrlDecode: CREATE FUNCTION dbo . UrlDecode ( @url varchar ( 3072 )) RETURNS varchar ( 3072 ) AS BEGIN DECLARE @count int , @c char ( 1 ), @cenc char ( 2 ), @i int , @urlReturn varchar Read More... Posted Friday, March 09, 2007 3:12 PM by Peter DeBetta | 7 Comments Filed under: T-SQL

• T-SQL UrlEncode

  I was perusing the newsgroups when I came across a request in the microsoft.public.sqlserver.clr newsgroup to see if there was a way to use System.Web.HttpUtility.UrlEncode in T-SQL. I know using the CLR is an option, but I decided to write a T-SQL equivalent. Read More... Posted Friday, March 09, 2007 12:08 PM by Peter DeBetta | 12 Comments Filed under: T-SQL

• Multiple-Valued Parameters

  So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited Read More... Posted Monday, February 12, 2007 4:43 PM by Peter DeBetta | 21 Comments Filed under: T-SQL, XML, Performance

• Medians, Actual Query Cost, and Statistics

  I was going to comment on Adam's post " Medians, ROW_NUMBERs, and performance " (which was a follow-up to Aaron's post " Take the high road to middle ground ") and I realized that I needed to show some code and alas, comments are not so nice about formatting Read More... Posted Wednesday, December 20, 2006 5:48 AM by Peter DeBetta | 2 Comments Filed under: T-SQL, Performance

• XML Data Type Methods and SSIS Package Variables

  This is a follow-up to a posting from several months ago ( Using XML Data Type Methods to query SSIS Packages ). I included a temp table (based on information I found in the Microsoft.SqlServer.Dts.Runtime.VarTypeConvert class's constructor) which gives Read More... Posted Monday, December 18, 2006 2:31 PM by Peter DeBetta | 0 Comments Filed under: T-SQL, SSIS, XML

• iPod and iTunes - Parsing the XML Library

  So I was trying to figure out a way to get my iTunes/iPod music library into SQL Server. Unfortunately, the XML in the library is not the easiest with which to work. Here is an abridged version of that XML: < plist version = " 1.0 " > < dict Read More... Posted Tuesday, December 05, 2006 1:55 PM by Peter DeBetta | 8 Comments Filed under: T-SQL, XML, iPod Attachment(s): itunes xml for sqlblog.sql