SQLServerPedia.com Webcast Archived
I’ve been informed that the webcast I did last week with some of the other editors for SQLServerPedia.com has been archived for offline viewing. Denny
Back To Basics: Getting Data from an XML Document
One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using […]
SQL Quiz: Toughest Challenges
Chris Shaw posted a new SQL Quiz where he asks: “What are the largest challenges that you have faced in your career and how did you overcome those?” I found this question rather tough to answer (as I have when I’ve been asked similar questions during interviews), but here goes. 1: Dealing with some of […]
.NET User Group Slide Deck and Sample Code
Here is the sample code and slide decks which I’ll be using at the .NET User Group tomorrow night. Query Tuning Resource Governor See you tomorrow. Denny