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
I’ve finely started using Twitter
We’ll I’ve finely broken down and started using Twitter. I decided to go all out. I’ve got TweetDeck for my PCs, and TinyTwitter for my BlackBerry. I tried TwitterBerry but didn’t like it very much. TinyTwitter has much more functionally. I also signed up for BrightKite to track my location. My username on Twitter is […]