|
|
|
|
Peter DeBetta's blog about programming in SQL Server using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
June 2006 - Posts
-
This post is for developers and admins alike. I have tried many ways to cause a crash in SQL Server 2005 by deploying assemblies with questionable code. To date, Safe and Eternal Access assemblies have not been able to cause any discernable grief, but Read More...
|
-
You may or may not have already noticed that we haven't enabled anonymous comments as of yet. We are working on implementing the best way to prevent spam on the site and will get comment working as soon as we have a solid solution, which may include any Read More...
|
-
As you can see from the multitude of archived posts,I have managed to migrate DasBlog posts (stored in XML files) to the CS 2.0 SQL Server data model. Let me outline the migration process. Import the DasBlog XML files. I used SQL Server 2005 Integration Read More...
|
-
This blog is not just about coding in SQL Server. It's also about the data access client. This post is for all you VB.NET and C# developers who are former VB programmers. Having worked with VB since its early days, there were many times when I had wished Read More...
|
-
I have been spending a lot of time of late getting a new reporting solution in place for a customer whose data is in Oracle on Unix. I'm happy to report that all is going well, and the biggest issues I am running into involve the use of SQL*Plus Worksheet Read More...
|
-
So I saw this article the other day that talked about using identities in the database. One snippet of code in the article was supposed to find tables with identity columns. I saw two key issues with this code: The code referenced system tables. If at Read More...
|
-
I spoke at the Dallas .NET User Group meeting last night about the CLR integration in SQL Server 2005. During the Q&A session at the end, I was asked for some more detail about creating overloaded methods and constructors in a User-Defined Types (UDT). Read More...
|
-
I just read a blog post by Adam Machanic and feel compelled to thank Adam on telling it like it is. I 'd also like to regurgitate his comments and add a few of my own: T-SQL is not going away. T-SQL is still the only means of accessing data. Even integrated Read More...
|
-
I am attempting to import my previous blog entries from DasBlog to CS. If you see a bunch of new posts in the next day, then you'll know I succeeded. :-) I'm also creating this post to learn more about the data schema in CS. Read More...
|
-
Well, after some discussions with Adam Machanic, we decided to get the new SQLblog.com up and running. I'll begin blogging next week (since I'm watching the World Cup right now)... Read More...
|
-
In keeping with my previous post, I wanted to show you how you could create the NthOfNextMonth function in .NET and then use it in SQL Server. The function, shown here, look amazingly similar to the T-SQL function. using System; using System.Data.Sql; Read More...
|
-
So, to kind of give you all a quick introduction to SQL Server “Yukon”, I though I would revisit a previous post that calculated the Nth day of the month following a specified Date. No, this is not a typo - Date is a new data type that stores Read More...
|
-
When I first started this blog, my original intent was to talk about all things related to programming SQL Server. Up until this point, I have skillfully avoided SQL Server “Yukon” as a topic. I am currently writing a book that about programming Read More...
|
-
Enigma ( http://sqljunkies.com/weblog/enigma ) posted a comment on the first entry in this topic regarding another method for converting a delimited list to a table. I will show an example of it here (formatted for ease of reading): Given the structures... Read More...
|
-
In this entry, we will explore a little oddity related to how we join two sets of data together. As you may already know, you can join two tables together in a variety of ways, three of which are shown here. SELECT * FROM Orders WHERE OrderID IN (SELECT Read More...
|
-
After writing this function, I discovered several months later on the internet a handful of other people had done essentially the same thing, with only slightly varying methodologies. I thought I was being rather novel when I did this not only because Read More...
|
-
Mike partially hit the nail on the head in his comment on my last post. He inferred that you cannot use a table variable for a dynamically executed procedure because the variable, like any other variable would do, goes out of scope. Well, the real truth Read More...
|
-
I was speaking to my friend Byer today, discussing the use of the OpenQuery function to get to some data from Oracle (in a linked server) - a requirement of the system on which he was working. More specifically, he needed to lookup a single value based Read More...
|
-
I couldn’t wait, and so I am continuing this topic a might sooner than expected (the original entry can be found here ). In that first entry, I had spoken about using T-SQL to find the Nth weekday of a month given a date in that month. Without further Read More...
|
-
SQL Server 2000 Reporting Services (SQL RS) is now available. I just watched the Web Cast for the official launch. I have been experimenting with SQL RS lately and I'll have to say that I am looking forward to making the switch from that other reporting Read More...
|
-
How many times have you been told that a user group meeting (or any regularly scheduled meeting, for that matter) would take place on the Nth weekday of each month - for example, perhaps the meeting was always on the second Thursday of the month. Or perhaps Read More...
|
-
I have worked on a number of systems where security setting were defined in the data itself. Bit flags were used to determine if a Role did or did not have a certain type of access, namely Select, Insert, Update, or Delete security. The fun part of the Read More...
|
-
February's issue (2004, of course) has a slew of SQL Server “Yukon” topics, including one by yours truly about creating User-Defined Types in .NET. :-) Be sure to check it out at http://msdn.microsoft.com/msdnmag/issues/04/02/default.aspx Read More...
|
-
Well, I will keep this entry short as I have to run out get pick up Chick-fil-A for my wife. Our son decided not to go down for his morning nap without a fight - and we are both tired, so as a treat, we will be dining on scrumptious chicken biscuits this Read More...
|
|
|
|
|
|