(Jay Miller) Extension methods allow you to add functionality to existing classes by modifying the original class or using partial classes. In fact, you don’t need access to the source of the class at all. You can extend third-party classes and built-in classes as easily as you can extend your own c
Other News
ViewState, form fields, labels and Javascript
(Mikesdotnetting) An interesting question came up on the ASP.NET forums asking why a TextBox which has its value changed by client-side Javascript persists those changes across postbacks, while a Label does not. And in a nut shell, this question covered two of the biggest causes of confusion among n
Microsoft’s Lineup of SQL Server Related Webcasts for January 2008
Nine new webcasts are scheduled for January, covering such topics as “Unlock the Business Intelligence Capabilities of SQL Server”, “SQL Server 2008 Programming for Application Developers” and more.
Add / Delete a row from a SQL based Tabular Form (Static ID)
(Duncan Mein) The current application I am working on involves a re-write to a 12 screen wizard that was written 18 months ago. Several of the screens make use of manually built tabular forms (SQL report regions) and collections to hold the values entered. Some of the screens in the wizard have mult
Moving Tempdb and Master Database in SQL Server
(Steven Warren) There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to pe
Data Pump Rocks!
(Charles Schultz) For the past week, we dove into Data Pump with a vengeance. I have never played with it before; I think I may have tried a table export or two, but nothing really serious. So last week I had no clue what a huge improvement over the “traditional” exp/imp Data Pump is. Of course, it
Time and Time Again: Managing Time in Relational Databases Part 16 – Physical Implementation of Version Pattern 1
(Tom Johnston and Randall Weis) Starting with this installment in our series, we will begin to describe the physical implementation of these versioning patterns. To this point, patterns have been presented from a logical perspective. Data modelers would recognize these discussions as being about log
Powershell and SQL Server – Web Pages from a SQL Query
(Buck Woody) In a previous tutorial I explained how you can use the Web Assistant Wizard in SQL Server version 2000 to create web pages that show the status of your maintenance plans. It’s a great tool, backed by several stored procedures that actually do the work.
SelectViews SQL Server Show Ideas/Requests?
Featured Article(s) Pivoting Data With Oracle 11g’s Pivot Operator One of the new Oracle 11g features is the Pivot and Unpivot operators used to summarize rows into summarized pivot tables. This article describes how to use this feature in your Select statements Do THIS SQL Job Before THAT One Did you know you can use SQL Sentry Event Manager to […]
SQL Server At CES! (Sort of)
Featured Article(s) Review: SoftTree SQL Assistant SQL Assistant is a tool that integrates into your environment of choice, offering to help with your SQL coding. The hope is that you will end up with standardized code, better, more efficient coding time since the tool would help you create the code and more. One reason to use Cursors than Set based […]