(Chris Eaton) Let’s start with the syntax for creating the partitioned table. The table creation syntax has a short form and a long form. I gave a brief example of the short form in my last posting. Before diving into the syntax, let’s first talk about the partitioning column. Table partitioning all
Author: SSWUG Research
How Should My XML Look?
(Jennifer Kyrnin) Creating an XML document, writing the DTD, and parsing it with a browser are all fine, but how will the document display when you view it? XML is not a language of display. In fact, documents written with XML will have no formatting at all.
ASP.NET Tip: Create a ViewState Property
(Eric Smith) ASP.NET uses the ViewState to store data going back and forth to the server, eliminating the manual drudgery of reloading form controls and so forth. The ViewState can also be helpful for keeping your own state information, once you know how to read and write it. Using the ViewState can
MySQL 5 C# sample code using ObjectDataSources
(defwebserver) I created this example because I could not find a simple explanation for using MySQL 5 with ObjectDataSources in ASP.NET 2.0.
Exception handling best practices in SQL Server 2005
(Adam Machanic) Exception handling is a key component of any solid software development methodology. Fact is, bugs do exist and exceptions will occur at some point when code runs. But what should you do to deal with exceptions and ensure they don’t cause problems? Unfortunately, when programming SQL
User Tips: Receiving an Email When Database Data is Changed
(Wade Wilbur) For low-volume databases, those that are predominantly read and not written to, or database tables that are designed to not be updated or only updated under rare circumstances, a DBA or developer may be interested in being notified whenever the data in a particular table is modified. O
Security in Microsoft .Net Framework: Part I
(Dinesh Tawar) CAS stands for Code Access security. CAS is a process that controls the access that code has to protected resources and operations. CAS allows code to be trusted to varying degrees, depending on where the code originates and on other aspects of the code’s identity. CAS also enforces t
Dynamic News Stories
(Adrian Holovaty) I like structured data. My favorite projects tend to be those that deal with, and exploit, structured information: events, restaurants, crime, and political information.
Working with Windows Messages in .NET
(John Mueller) You might not be familiar with messages, but they’re extremely important, especially when you need to perform tasks outside of the range of tasks that Microsoft programmed into the .NET Framework. All communication in Windows relies on messages.
Weaving WebSphere: AIRPort Now Arriving
(Joe Pluta) You know me, always trying to find quotes that really fit. Well, this song is appropriate to this article for a number of reasons. First, it’s both old and new. The original was recorded in 1967, and it’s been re-recorded dozens of times over the years. Each time, it gets a little someth