ASP.NET News from Blogger: Jason N. Gaylord   Get the feed of: Jason N. Gaylord

Total News: 22

Great Post about SELECT * Queries

I just read a pretty good post by Jon Galloway about SELECT * queries. It can be found here: http://weblogs.asp.net/jgalloway/archive/2007/07/18/the-real-reason-select-queries-are-bad-index-coverage.a...

Preventing SQL Injection Attacks

Scott Guthrie just posted some really good stuff about preventing SQL injection attacks. In his blog post he talks about an application that Michael Sutton created to check SQL injection attacks by sc...

Red Gate's SQL Prompt is Free until Version 3

Paul Litwin has pointed out in one of his blog post's that Red Gate's SQL Prompt utility, a great IntelliSense utility for SQL server can be downloaded for free until the next version is released. To ...

Frustrations over [SQLSTATE 42000] (Error 22029) in SQL 2000

I kept receiving an error message in the event viewer about 2 of my SQL jobs and couldn't figure out why it was occurring. The error contained [SQLSTATE 42000] (Error 22029). After doing some res...

WinFS Being Dissolved, Absorbed Into SQL Server

It seems like the WinFS team has tossed in the towel. None the less, the team and its offerings will be absorbed in ADO.NET and the next version of SQL Server codenamed Katmai. To read more, click her...

SQL 2000 Support Won't Be Dropped...yet

That Wally is up to it again and this time he pulled David Silverlight into it as well! For folks who thought that SQL 2000 server support was being dropped, its not. Wally made this outrageous c...

Announcing! Visual Studio Team Edition for Database Professionals

Microsoft Corp. today announced Visual Studio Team Edition for Database Professionals, expanding Visual Studio 2005 Team System to include tools that enable software development organizations to colla...

What is a Database?

It's kind of funny how many times I run into individuals who think they know what a database is, but they really don't understand it. On one of my lists earlier today, I saw a post where someone was l...

Security and Incidence Response Handling at .NET Valley Event

During the May 24th .NET Valley Event at Johnson College in Scranton PA, Mike Murphy, a TechNet Presenter will talk about Security and Incidence Response Handling in Microsoft SQL Server. Below is Mik...

SQL Server 2005: Oops, Application Broken!

I came in this morning and to my surprise, my one app kept failing. It was a win app that used a SQL Server 2005 backend. I checked the error logs that it generates to find that the error stated that ...

TechEd Day 2: MS Announces Release Dates For Visual Studio.NET 2005 and SQL 2005

Paul Flessner, senior vice president of Server Applications at Microsoft, announced that SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006 will be formally launched during the week of Novemb...

SQL Server 2005 Business Intelligence Webcasts

Microsoft has released a SQL Server 2005 Business Intelligence webcast list. You can view the list of webcasts and other events here: http://www.microsoft.com/events/series/sqlserverbi.mspx...

Interview with Tom Rizzo

In a recent interview at VS!Live, Tom Rizzo, the director of product management for Microsoft SQL Server, answered some questions about SQL Reporting Services and SQL Server 2005. You can read the tra...

MSDN Code Camp - Greater PA 2005 Pictures

I finally got around to posting the pictures from the Greater PA MSDN Code Camp 2005 event in Philadelphia. They are posted on the .NET Valley User Group website at http://www.dotnetvalley.com/Photo+G...

Deploying SQL Express with ASP.NET 2.0 Providers

If you plan on keeping your SQL Express data when you deploy an ASP.NET 2.0 application that you add the applicationName attribute to each of your providers under each special ASP.NET configurati...

SqlExpress 2005 Capabilities

I posted a question to the ASPAdvice.com forums regarding the limitations of SqlExpress 2005. I already knew that there was no limitation on connections. However, Scott Forsyth was able to provide me ...

SQL Talks at MSDN Code Camp

The .NET Valley User Group will participate with other User Groups in the Greater PA region in attending the Greater PA MSDN Code Camp in Philadelphia this Saturday and Sunday (April 23 and 24). We lo...

UPDATED: SQL Server 2005 Uninstallation Issues

A little while ago, I blogged about some issues with uninstalling SQL 2005. Finally, Microsoft has published an uninstallation "script." Find out more by visiting http://lab.msdn.microsoft.com/vs200...

Viewing Your Database in SQL 2005

I must say that I'm very disappointed that SQL 2005 has limited the table information that you can view on a single screen. What I mean is that they have removed database diagrams from SQL 2005 and ha...

The log file for database 'tempdb' is full...

Today I received an error message within one of our applications stating that "The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space." I ...

SQL Server 2005 Installation / Uninstallation Issues

I ran into an issue when installing a new version of Visual Studio 2005. I forgot to uninstall SQL Server 2005. So, the .NET Framework versions were different. This caused tons of issues leading to me...

Getting Ready For SQL Server 2005

I read a fairly decent article today about getting ready for SQL 2005. So, I thought I'd share...http://www.ftponline.com/vsm/2004_en/magazine/features/rjennings/...

View Other bloggers