|
Indexing Strategies |
|
|
By host on
12/28/2007 9:13 AM
|
|
|
At the most recent IndyPASS meeting, Tom Pizzato presented on the subject of Indexing Strategies. Tom's presentation was packed with detail that ranged from introducing the concept of indexing as well as discussing performance considerations at the page level.
This presentation was exceptional and so much so that I wanted to make note of it here in my blog. A great point discussed in this presentation was that while in general table scans in a query are not desireable there are times where they are more efficient than an index seek. For example: If you were querying a 100 row table.
Also noted was how the order of execution in a WHERE clause can effect the performance of a query as well as its use of indexes.
There was alot of great information and not enough time to fit it all in. A special thanks to Kimberly Tripp who provided Tom with a large portion of the information presented by Tom. To download Tom's slidedeck,
 |
|
|
More...
|
|
|
SQL Server 2008 Cometh |
|
|
By host on
12/16/2007 10:36 PM
|
|
|
|
Like most real world developers and DBAs, I am working with multiple SQL Server versions at the same time. I currently work with SQL Server 2000 in one project while working with SQL Server 2005 in another. To further this experience, I recently had a discussion with a peer who just completed a project to move SQL Server 7 to SQL Server 2000. Some businesses are more eager to adopt the latest and greatest software while others take the “wait and see” or “if it ain’t broke don’t fix it” approach.
We now find ourselves on the cusp of another version of SQL Server. This really begins the new Microsoft eighteen month release plan. This plan is very aggressive; but so is the software and database marketplace. SQL Server has become quite a complex platform and frequent improvement and innovation is not only desired but essential to its survival and competitiveness.
Regardless of whether one feels that this new version is too soon or just in time, it is fast approaching and Microso ...
|
|
|
|
|
More...
|
|
|
|
Why Blog? |
|
|
By host on
12/10/2007 9:16 AM
|
|
|
|
There are many blogs on the internet. These blogs range from a series of short technical articles to updates on the latest developments and activities of a new baby. There are many motivations to writing a blog, her are just a few that I immediately think of:
- Exercising writing skills.
- Communicating specialized knowledge.
- Communicating ideas to a community of persons with a similar interest.
- A public diary.
- Sharing information to family, friends, or professional peers.
- Venting or establishing an outlet to voice an opinion/viewpoint.
- Marketing of a service/product.
For me, my motivation of writing this blog is two-fold:
1. In my early days of becoming a VB/VB.NET/SQL Server developer a big chunk of my learning came from online articles, forums and blog entries. When I run into an overly difficult challenge, these are still a ve ...
|
|
|
|
|
More...
|
|
|
A Brief Introduction To Threat Modeling |
|
|
By host on
12/4/2007 7:02 AM
|
|
|
|
Threat Modeling is one of those topics that you may see pop up in my blog fairly frequently. It is a subject that I find very interesting. I am in the process of authoring an article on this subject which should be published early 2008; but thought I would provide some nuggets for this blog.
Threat Modeling is the formal process of evaluating and documenting an asset's exposure to security breaches and data loss. An example of an asset would be an enterprise architecture of a network, an individual server, an application, a database or even non-computer based items such as patient file folders stored in a doctor's office. This is key to the security plan of any asset.
This process can be boiled down to four steps:
- Defining Assets
- Identifying Vulnerabilities
- Analyzing Threat ...
|
|
|
|
|
More...
|
|
|
Interaction of Web Controls Using Events |
|
|
By host on
11/30/2007 12:50 PM
|
|
|
|
One of the tricky aspects of using web controls in a .NET Web Application is the interaction of web controls. A scenario that may accurately describe the need for such interaction would be a master page that contains one web control that provides a search functionality and another that allows data entry functionality for the item recalled and selected from the search web control.
The use of “Events” works very well. I have used these quite extensively in my past .NET Web Application projects. A quick example of how an Event can be implemented:
Web Control 1 (we’ll call it webControl1) will be the instigator of the event. “DoSomething” will be the name of the event. The Event will need to be declared at the top of the class by using the following syntax:
Public Event DoSomething() ...
|
|
|
|
|
More...
|
|
|
INTERSECT Operator |
|
|
By host on
11/26/2007 12:49 AM
|
|
|
|
In my recent research for filtering options I ran across an operator that I had never considered: the INTERSECT operator. This operator was introduced with the release of SQL Server 2005.
The INTERSECT operator returns unique values from where they exist in both queries being evaluated. A sample of how this may appear in a query is as follows:
SELECT ...
|
|
|
|
|
More...
|
|
|
Agile Development |
|
|
By host on
11/18/2007 9:12 PM
|
|
|
|
A fellow developer and I often have discussions regarding the subject of Agile Development. I often am on the critical side of the discussion. Recently, I have been researching this method of development further so that my view point is from what the method is rather than the assumption of what I think it is.
|
|
|
More...
|
|
|
Red-Gate's SQL Dependency Tracker |
|
|
By host on
11/14/2007 9:13 AM
|
|
|
|
Being a visual person, I was looking for a tool that could quickly present my database schema in a graphical format. Qucikly identifying the dependecies that the objects in my database had with eachother was my objective. The benefit of having this information available in such a manner was so that I could state with confidence the effects of modification to any object in the database. Also by having this information, it makes building queries and stored procedures much easier.
I recently installed SQL Dependency Tracker by Red-Gate. This tool is designed to meet my objective. Unlike alot of tools where they pack in so much functionality that the use requires a 300 page manual, this tool was extremely intuitive. Literally within seconds I was able to view the dependencies of my schema.
To obtain my schema, I simply clicked on the "Add Objects To My Project" but ...
|
|
|
|
|
More...
|
|
|
Creating Multi-Segmented Files Using T-SQL (Part 3) |
|
|
By host on
11/11/2007 6:56 PM
|
|
|
|
In part 2 of this blog series, I presented how to prepare a SQL statement that will produce the Header Segment of a multi-segmented fixed length file. As part of that blog entry, I listed items that should be considered when preparing the string that would ultimately be returned when the SQL statement is executed. These considerations should also be part of the building of the remainder of the segments that are involved in this file.
The specific example that is being constructed in this series is a very simple one. It contains 3 segments:
- Header Segment
- Client Segmnet
- Footer Segment
A sample of the content of these segments are as follows:
Header Segment: 01HTV200711040000000000170
Client Segment: 021234567890 &nbs ...
|
|
|
|
|
More...
|
|