|
|
|
|
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
-
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. Share this post: email 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...
|
-
I received a IM message in Windows Live Messenger from a techie friend earlier today. The message reads ( myname replaces my actual email name) "Hey isnt this YOU?? http://msngallery.ms.funpic.de/viewimage.php?= myname @hotmail.com" I thought it strange Read More...
|
-
I laughed, I cried... http://www.youtube.com/watch?v=v5uw07iEkjU Bill Gates presents a farewell video at the keynote of the Consumer Electronics Show. (video URL has been changed to YouTube since the MSN video and image are no longer "available".) Share Read More...
|
-
Just over a month ago, Simon Guest had posted a blog entry about the call for sessions for TechEd 2008. The original deadline was 31 December 2007, but I've just gotten confirmation that this deadline has been extended to 31 January 2008, so if you were Read More...
|
-
While working on a new book, I have been experimenting with the new HIERARCHYID data type. And since I've seen comparisons drawn between using XML versus using HIERARCHYID to manage a hierarchy of data, I decided that it would likely be very useful if Read More...
|
-
Denis posted a follow-up to the posts by both Louis and me. However, I have to say that there is a better way to pass a bunch of data to a procedure. The following code is amended to include the table-valued parameter feature. --The Movie Table CREATE Read More...
|
-
My esteemed colleague Louis Davidson just wrote about a new feature in SQL Server 2008 known as row constructors . I thought I'd follow up with some more fun usage of this cool feature. In addition to being used with an INSERT statement, you can also Read More...
|
-
If you are reading this post then you are being served up by SQLblog from its new home at MaximumASP hosting provider. We are very excited to be working with the people at MaximumASP in order to better serve the community and help with the continuing Read More...
|
-
Have you ever needed to pass in a value that would be used throughout the lifetime of a connection - perhaps a connection session level value that would be used by multiple procedures, views, functions, etc...? Well, a colleague of mine, Jay Frysinger, Read More...
|
|
|
|
|
|