|
|
|
|
Peter DeBetta's blog about programming in SQL Server 2008, 2005, etc. using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
Browse by Tags
-
I have been very remiss in posting lately. Unfortunately, much of what I do now involves client work that I cannot post. Fortunately, someone asked me how he could get a formatted list (e.g. tab-delimited) of files with GPS data from those files. He also Read More...
|
-
SQLblog found a new home this past weekend and was moved onto a much needed, much better server infrastructure. SQLblog continues using MaximumASP (now CBeyond Cloud Services but still found at www.maximumasp.com ). We have been very happy with Read More...
|
-
Now that I've discussed converting XML into a set of HIERARCHYID values I thought I'd try to reverse the process... Not sure if you’ve attempted to convert a table with HIERARCHYID to an XML representation, and if you have, I’m sure you’ve experienced Read More...
|
-
In a previous blog post , I had discussed a method of shredding XML to a table with HIERARCHYID, and realized that it had a dependency that I was not too keen about: The XML data required an “id” attribute in order to create the hierarchy. I had sorted Read More...
|
-
A friend and colleague of mine, Caleb Jenkins, has started a fitness challenge ( http://calebjenkins.wordpress.com/2009/01/29/official-rules/ ) and I decided that it was time for me to accelerate my fitness program that I had started in January. As of Read More...
|
-
Are you a twitter tweeter who loves SQL Server? You are?! Great, because SQLblog is now posting (AKA tweeting) on Twitter at http://twitter.com/sqlblog . Enjoy! Read More...
|
-
It took a while, but a new e-book authored by yours truly, Greg Low, and Mark Whitehorn is finally available. And it's free! To get your free copy, browse to http://www.microsoft.com/learning/sql/2008/default.mspx . From there, look in the Special Offers Read More...
|
-
Last year, my 4 year-old son and I walked (well, I carried him for 2 miles) in support of Juvenile Diabetes Research Foundation (JDRF). We raised a modest amount in support of this wonderful effort. This year, we want to help more than ever, and I thought Read More...
|
-
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...
|
-
As promised, I am posting my samples from the North America TechEd 2008 Developer Week. Note: All the samples are designed to run in SQL Server 2008. The safe dynamic sql samples can be modified, however, to work in SQL Server 2005. Read More...
|
-
After numerous questions and requests, we decided to create a forum for all SQL Server related questions. You can view the new forum at http://sqlblog.com/forums/57/ShowForum.aspx or use the Forums menu item on the site to browse there. We hope this new Read More...
|
-
With some help from two esteemed colleagues, Greg Low and Mark Whitehorn, the Introducing SQL Server 2008 book is now content complete. Sure, there is still some tech and copy editing that needs to be done, but the core writing is complete. The book, Read More...
|
-
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...
|
-
Microsoft reported: "We have recently discovered an issue with SQL Server 2008 CTPs that result in SQL Server 2008 not starting or installing on Feb 29 GMT only. We recommend that you do not run, install or upgrade this CTP on Feb 29 GMT to minimize any Read More...
|
-
Bloggers at SQLblog.com were occasionally having issues posting. We had narrowed down the cause to the use of bracketed identifiers with certain text, such as [name] or [date], so that when a post contained a query such as this: SELECT Description as Read More...
|
|
|
|
|
|