|
|
| |
SSWUG Articles
Tracking SQL Server Timed Events, Part 1
|
(Buck Woody) If you do a search here on InformIT, on other SQL Server sites, or even the Internet at large, you’ll find no lack of tips, discussions, training and other information on Performance Tuni
|
Create a XSL for XML to XHTML
|
XSL stands for EXtensible Stylesheet Language, and is a style sheet language for XML documents.Most of the browsers support this.Also it is supported by most major Web development tools, including Dre
|
Exploring Derived Column Transformation in SQL Server Integration Services
|
(Marcin Policht) As we have explained in our most recent article, Derived Column Transformationcan be leveraged in order to resolve data type conversion issues that tend to surface when importing the
|
Getting the counts in hour intervals
|
A friend recently asked a question about how to split the counts for a given day into 4 hour intervals for an event that happens in their system. The scenario was quite simple – they have meetings th
|
Agile development with XML
|
(William Brogden) What does "Agile Development" mean anyway? Many times during the history of the profession of software development people have become frustrated and disgusted with how so many major
|
Oracle Partitioning and Parallel Execution for Performance seminar by Tanel Poder
|
(H.Tonguç Yýlmaz) Tanel was our visitor last week as I mentioned earlier, he did a one day seminar on partitioning and parallel execution. There were lots of interesting discussions for me, I tried to
|
What’s new in statement-level performance metrics
|
(Curt Cotner) As I've been visiting various customers and presenting at conferences, I'm finding that there is a lot of interest in our new performance monitoring capabilities in Optim Performance Man
|
Validation in Linq to SQL and ASP.NET
|
(John Charles Olamendy) One important aspect of every enterprise application is the validation of business rules. In this article, I will show how to add business rules to Linq to SQL data model defau
|
DB2 Stored Procedures and Defaults (Conclusion)
|
(Keith McDonald) If you remember the previous post, I showed how moving some logic from an anonymous block into a scalar function caused the program to start reporting an SQL0577N, saying that the und
|
IBM DB2 adds 'SQL Skin for Sybase ASE' to Ease Database Migrations
|
(Conor O'Mahony) IBM is continuing to play the role of liberator, allowing users who thought they were locked-in to another DBMS vendor to switch to DB2. Last year, IBM added support to DB2 for syntax
|
Impact of Truncate or Drop Table When Flashback Database is Enabled
|
(alejandro.vargas) Recently I was working on a VLDB on the implementation of a disaster recovery environment configured with data guard physical standby and fast start failover.
|
Working with XML in Databases
|
More and more users are storing XML documents in database columns, especially when XML data is sent or received from other entities. Storing data in XML helps enterprises more easily accommodate revis
|
More DB2 for z/OS parallelism
|
(Willie Favero) In my previous post on parallelism ("DB2 for z/OS Parallelism" ) back on May 15 I introduced some of the basic concepts behind parallelism. Today, I'd like to take a look at the DSNZPA
|
Exploring Javascript's eval() Capabilities And Closure Scoping
|
(Ben Nadel) A little while ago, while working on the jQuery Template Markup Language (JTML) code, I used Javascript's Function() constructor to compile template markup and found out that it doesn't cr
|
How to Modify Existing Seeded Templates Using XML Publisher
|
(Shivmohan Purohit) Seeded templates cannot be updated or deleted. The Update and Delete icons for these templates are disabled. If you wish to modify a seeded template, duplicate it, then modify the
|
Account permissions and security settings
|
This article describes Microsoft SharePoint Server 2010 administrative and services account permissions. It covers the following areas: Microsoft SQL Server, the file system, file shares, and registry
|
Bryan’s impressions of IDUG NA 2010
|
(Bryan Smith) Writing to you now from outside of Rome at IOD EMEA, but I wanted to take some time to focus on some of my impressions of this year's IDUG NA in Tampa:
|
ASP.NET MVC 2.0 Templating
|
(Brian Mains) Templating is now in the ASP.NET MVC 2.0 framework, for .NET framework 3.5 and 4.0. We are going to take a look at these features.
|
More Info on DB2 RI
|
(Troy Coleman) The previous two weeks I've written about DB2 referential integrity (RI). My good friend Suresh Sane posted a comment to clarify my May 4 post on using RI.
|
Physical Join Operators in SQL Server - Hash Operator
|
(Ami Levin) In second part of this series on physical join operators we looked at the Merge Operator. In the final part of the series we turn our attention to the Hash operator.
|
|
|
|
