The right SQL goes a long way(vistadb.net)

submitted by vistadb(879) 3 years ago

I got a query from a customer this week that was taking a long time to run. <br/><br/> When I first looked at the query my first thought was that the indexes were wrong, or just the joins across 4 tables were killing the performance. But almost all of the lookup tables were really simple value lookups. <br /><br />The submitted query took 1 minute 55 seconds on my machine with his data. After rewriting the query, and adding a few indexes I was able to get it to run in 0.86 seconds. That is an AMAZING performance change ... read more...

add a comment |category: Database |Views: 5

tags: Database another

LINQ to SQL and alternate Providers(west-wind.com)

submitted by vistadb(879) 3 years ago

Alternate way to get L2S to load an ADO.NET connection object as a part of its context rather than using the built in SQL provider. read more...

add a comment |category: ADO.NET |Views: 8

tags: ADO.NET Database another

Visual Studio 2010 Beta 1 for MSDN Subscribers(vistadb.net)

submitted by vistadb(879) 3 years ago

Visual Studio 2010 Beta 1 is now on MSDN along with .Net 4 Beta 1. Some highlights from the information: .Net 4.0 Cloud Development - Windows Azure which is basically utility computing where you pay by the hour for your usage. Parallel Development - Not sure if this only means PLINQ for .Net developers or if they are only talking about C++ devs. TDD Improvements - Editor changes for building test cases first, and then writing the code. ASP.NET - CSS grids and design surfaces changes, more Javascript debugging improvements. C++ Compiler - Lots of changes for C++ development, including MFC. Sharepoint templates New Project Templates Windows 7 - MFC updates for Ribbon UI, and WPF changes. Application Model Changes - Reverse existing codebases, and lots of changes in Architect Edition to support more model types (including Class Libraries finally). Test Runner - This is potentially huge as it allows testers to submit bug reports complete with callstacks and traces that you can actually use to resume an app at the error point to avoid the dreaded No Repro on bug reports. I have seen this demo and it is quite impressive. We will see how it actually works though. read more...

add a comment |category: Visual Studio |Views: 387

tags: VisualStudio another

Gibraltar opens beta to new logging and reporting tool(vistadb.net)

submitted by vistadb(879) 3 years ago

Gibraltar Software has announced Beta 4 of their new application logging and reporting product as a public beta. Gibraltar is an end to end solution for logging, managing and reporting on your application. What you log is entirely up to your application. The product includes the ability to add trace listeners, log4net, and custom metric recording through custom code. read more...

add a comment |category: Community |Views: 6

tags: Community another

Social Bookmarking Extension for BlogEngine.Net – AddThis (Updated)(mayankraichura.com)

submitted by vistadb(879) 3 years ago

Nice article about creating an AddThis.com bookmark generator for BlogEngine.net. read more...

add a comment |category: ASP.NET |Views: 25

tags: ASP.NET another

How To: Clean Up ASP.NET JavaScript Tags(blog.reamped.net)

submitted by kayos(890) 3 years ago

In April of '08, I wrote a post about cleaning up the ASP.NET head tag using control adapters. I've got some great feedback from it, and I'm glad that I'm not the only one that is horrified when looking at the source of an ASP.NET rendered web page. From the comments of that article I was recently asked how to clean up JavaScript tags. read more...

add a comment |category: ASP.NET |Views: 21

tags: JavaScript ASP.NET another

Start plus two years, how are we doing?(vistadb.net)

submitted by vistadb(879) 3 years ago

Wow, two years since I acquired VistaDB. How did the time go by so fast? I thought it would be fun to reflect on what all has happened over the past two years, and to measure how we have done. At the time I acquired the company I had a list of items that I felt were the keys to making VistaDB a success. Somewhere along the way I lost that list, but found it again this week. It is interesting to go back and see how we got here. read more...

add a comment |category: Products |Views: 4

tags: another

The HttpWebRequest and Using Client Certificates(blog.reamped.net)

submitted by kayos(890) 3 years ago

So you may have found yourself in a similar situation, needing to make a TCP/IP request to a 3rd party API possibly using SSL. Well, that is a quite simple task. It can however, be complicated if this 3rd party requires the use of certificates for communication to its API server. read more...

add a comment |category: C# |Views: 117

tags: csharp ASP.NET C# another

Declaring Custom WPF Commands via Markup Extensions(hardcodet.net)

submitted by bradygaster(4897) 3 years, 1 month ago

Excellent article explaining how to use commands with WPF and markup extensions, in simple-to-follow examples. read more...

add a comment |category: Windows Presentation Foundation |Views: 47

tags: WPF another

Creating Rich Data Forms in Silverlight 3 - Introduction(silverlightshow.net)

submitted by bradygaster(4897) 3 years, 1 month ago

Silverlight 2 has introduced many interesting features and controls but it misses something that Silverlight 3 makes possible –easily creating and manipulating rich data forms. These series of posts will help you when creating rich data forms in Silverlight 3 in your projects. Silverlight 3 introduces a new control, called DataForm. It enables various methods for display, edit, update and navigation through data. read more...

add a comment |category: Silverlight |Views: 34

tags: Silverlight another

Gibraltar Software has announced open Beta for logging and reporting(vistadb.net)

submitted by vistadb(879) 3 years, 1 month ago

Gibraltar Software has announced Beta 4 of their new application logging and reporting product as a public beta. We have been working with them over the past several months as they prepare to release their product and I am quite excited to finally have the ability to discuss it publicly. There are just so many uses for the product that once you start using it you will want to embed it into everything you build. What is it? Gibraltar is an end to end solution for logging, managing and reporting on your application. What you log is entirely up to your application. The product includes the ability to add trace listeners, log4net, and custom metric recording through custom code. read more...

1 comment |category: Community |Views: 16

tags: VistaDB gibraltar Logging Community Log4Net another

.Net RIA Services and Multi-table Joins - Sliverlight 3(microapplications.com)

submitted by vistadb(879) 3 years, 1 month ago

Silverlight 3 talk about using EF models to query relational data. Interesting post read more...

add a comment |category: Database |Views: 16

tags: RiaServices Database another

Code guidance and quality of sample code(ayende.com)

submitted by vistadb(879) 3 years, 1 month ago

Nice blog about the quality of sample code vs production ready code. read more...

add a comment |category: Community |Views: 16

tags: Community another

VistaDB 3.5 Trial Available(vistadb.net)

submitted by vistadb(879) 3 years, 1 month ago

VistaDB 3.5 includes a number of enchancements to the core tools from the 4.x development work. Visual Studio Designer - This designer has a new name (and path). It is actually most of the new designer from the 4.x line. We are making a lot of changes to the internal architecture to get ready for client / server and Entity Framework support from a single designer. The new install path is the InstallDir\VisualStudio to reflect that a single dll is used for all versions of Visual Studio. The dll has also been renamed to VistaDB.vsdesigner.dll. Visual Studio Server Explorer - Displays the name of the database rather than "VistaDB Database" in the explorer tree. Existing entries must be removed and re-added in order to gain new naming. Visual Studio Database Template - Add new item templates for vdb3 database. We will add an asp.net version to include the role providers pre-populated in the database. There is no need to migrate from one format to another as the VistaDB.Web.Dll has been rewritten to only use the SQL Interfaces (but did not make it into this release). We now use the same schema as the SQL Server membership provider and it should make upsizing to SQL Server easier. Once you add the item template into your project a Server Explorer entry is made for you, and an app.config with the database factory entries just in case you need them. When adding a new template to a project it will also automatically make the correct app.config or web.config entries for the engines, and in the case of the web project it will also copy the dll from the GAC to your bin folder to make an easier deployment. Data Builder UI Changes - New launch screen showing a cached list of recent stories from our Blog. We will continue to update this over time (maximum of once ever 4 hours). You may uncheck the update box to prevent it from checking for a new landing page. The launch page also shows the most recent databases for quick reload of the files. read more...

add a comment |category: Database |Views: 13

tags: Database another

.Net Frameworks - how many distros are there?(vistadb.net)

submitted by vistadb(879) 3 years, 1 month ago

We got an email request from a potential user asking if VistaDB could run on Windows Server Core. I basically responded that if you can install .Net 2 then we should work. Well, that is where it gets interesting. A quick search through MSDN shows that you cannot install .Net 2 on Server Core. But then I found that you can get a customized hyrid ripped apart version of .Net 2 - somtimes... read more...

add a comment |category: Community |Views: 12

tags: Community another

Finding Text in SQL Server Stored Procedures(blog.reamped.net)

submitted by kayos(890) 3 years, 1 month ago

So, I'm sure you have been met with a similar scenario during development. You know the one that you have to rename a column or even drop a column in the database. This can be quite annoying if you are doing stored procedure based data access for your application. read more...

add a comment |category: Tips & Tricks |Views: 43

tags: SQLServer TipsAndTricks SQL Database Tips another