Community Blogs

We often need to display images from database like profile photo of the user or something. Displaying images from database to an ASP.NET Image is not a big deal but maintaining the exact aspect ratio and displaying a web friendly image is very important. The following program will help us to do that. < asp : Image ID ="ImgPhoto" runat ="server"></ asp : Image > The below code is written in the code behind page. Either the Width or Height of the image is specified. The second dimension is calculated by the program, maintaining the aspect ratio. ImgPhoto.ImageUrl = "ImageDisplay.aspx?Width=300&PhotoID=2" ; ImageDisplay.aspx is a webpage which contains the following code. This page is used to retrieve...

While the release of Beta 2 of Visual Studio 2010 and .NET Framework 4 is getting all of the attention this week, version 2.0 of the Microsoft Sync Framework was also released this week and can be downloaded from here ....( read more ) Read More...

Você quer aprender mais sobre o SQL Server 2008? Então reserve o sábado, dia 07/11/09 inteiro! A comunidade, com o apoio da Microsoft vai realizar um evento online com mais de 12 horas de duração ininterruptas! Com alguns dos melhores profissionais de SQL Server no Brasil compartilhando seus conhecimentos e tirando dúvidas sobre os mais diversos assuntos. Grade de palestras: 09:30 - 10:00 - Abertura do Evento 10:00 - 11:00 - Resource Monitor e Policy Management - Vitor Fava e Alexandre Lopes 11:00 - 12:00 - Entenda porque o Query Optimizer é mais esperto que você - Fabiano Amorim 12:00 - 13:00 - SQL Azure Database - Diego Nogare 13:00 - 14:00 - Novos Recursos de Desenvolvimento do SQL Server 2008 - Higor Fernandes 14:00 - 15:00 - Compressão...

osql.exe is a great application for running sql scripts in a batch.  I use a batch file to execute multiple sql scripts that I use to rebuild my current application database from scratch.  When developing a brand new application, deploying a database in this way makes it really easy to recreate the database just like it will be created on Day 1 when you build out the Production environment. This requires scripting out all of your sql objects and then also having a way to execute all of those sql scripts easily.  That is where osql.exe comes in handy. But osql.exe does have one issue that I ran into this week where it does not like UTF-8 (codepage 65001) or UTF-7 (codepage 65000) encoded files.  And sometimes you need to include...

StackExchange has recently gone to beta, allowing people to set up sites using the same platform that runs StackOverflow . As my team maintains SQL Server Central , we decided to take advantage of this and set up Ask SQL Server Central . We’re not sure where we’re going to go with it yet, as it takes quite a different model to the rest of the site, which mainly features articles and traditional forums, but we felt that some people might find it a useful way of finding information, and it was pretty straightforward to do, so we dived in. One immediate offshoot of this is that StackExchange uses OpenID as its preferred method of sign in. In order to reduce the complexity for the current members of SQL Server Central, we’ve taken the decision to...

I received a (initially) strange request to determine whether a SQL job is currently running or not. And researching it was useful, but it didn't quite tie all together for me. So, I'm posting this T-SQL snippet (which can be wrapped up into a stored procedure, if you wish) that determines whether a SQL job is running. For this example, I've hard-coded the name of the SQL Job... Enjoy! Normal 0 false false false EN-AU X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable...( read more ) Read More...

Daily tech links for .net and related technologies - October 9-11, 2009 Web Development Using MvcContrib ScriptInclude, Stylesheet, And T4MVC ASP.NET MVC Cheat Sheets NerdDinner with Fluent NHibernate Part 3 - The infrastructure ASP.NET Profiles in Web Application Projects ASP.NET 4.0 Roadmap 15 Helpful Website Usability Facts & Guidelines How to trigger an ASP.NET validator from JavaScript? ASP.NET MVC learning resource: Request-Handling Pipeline Poster Adventures with the SEO Toolkit Web Design...( read more ) Read More...

Just ran into this and thought I’d share.  If you are trying to connect to SQL Server from your Web application running on Windows 7 or Windows 2008 R2 and you’re getting a message that looks like this: Failed to generate a user instance of SQL Server Read More......( read more ) Read More...

Daily tech links for .net and related technologies - October 5-7, 2009 Web Development How To Speed Up Your Website By 80% Or More Enterprise Library Validation example for ASP.NET MVC 2 thinking out loud: asp.net mvc & nhaml ASPhere web.config editor Efficient Server Side Paging With ASP.NET And jQuery 3 Image Techniques To Speed Up Your Website 5+ Steps to Speed up your Website punypng: PNG Compression and Image Optimization Asp.net MVC Areas in depth - on code Web Design How to Code a Clean...( read more ) Read More...

Daily tech links for .net and related technologies - October 2-4, 2009 Web Development Special Folders You Won’t See in ASP.NET 4.0 Increase Your Website Performance by Hosting jQuery with a CDN Lower Case URLs and ASP.NET MVC Seadragon Ajax Control – Quick Start Guide Dynamically Generate META tags in ASP.NET Pages with LINQ to SQL ASP.NET MVC 2 Preview 2 - Phil Haack New AJAX Control Toolkit Release - Stephen Walther Reduce development costs by platforming on SharePoint Sending encrypted e-mail...( read more ) Read More...