sql server
There are 24 entries for the tag
sql server
The following is a simple checklist you can use when building web applications. Much of this still applies to other technologies and can easily be extended. I try not to get too specific on technology or methodology, but it is definitely leaning toward ASP.NET. If you can think of something I am missing or disagree, please leave a comment. Detailed information follows the checklist. How much of the checklist you follow will depend on the project. If its just a hobby site, you may skip items like...
Well, I can finally start releasing the name of our product / company / web site since 1 - we are officially expanding the team and hiring more people and 2 - the placeholder page is up at juggle.com. But I can't tell you what we are building yet. Hey, here is a good way to find out. Join the company! Hiring in St. Louis We are a small web development group looking to expand our team. Plain and simple, we are looking for great developers. We are focused on finding people who have a passion for development...
Okay, so "everyone" hates Visual SourceSafe. But the simple truth is many .NET developers have access to it for free because it comes with their MSDN Subscription. So a lot of .NET developers use it and they are familiar with it. Not because it's the best, but just because it's there. When we launched the new company we too went with Visual SourceSafe because it was included in our subscriptions, we were familiar with it, and it was better than nothing. But since then it has failed us in the biggest...
When we first started the new project there was no question that it would be ASP.NET. It's what I knew and I trusted it to get us there. I wasn't going to risk a startup by playing with Ruby on Rails or PHP when I knew very little about it. I also went directly to SQL Server for the same reasons. But during the first weeks of development we needed to run MySQL to power some software we thought for sure we were going to need to run. That threw a wrench in the plans. Did we really want to run two database...
I think a person's start menu says a lot about them. So show us your start menu! It's a simple Ctrl+Alt+Print Screen. Work Running Windows XP, the company is not overall aggressive about adopting the new OS even though we are a software company. Not running a standard skin (that's the Zune skin). Using IE, not Firefox. Must be a company thing? Windows Live Writer is the top program. I post once or twice a day from work during downtime, but I don't leave the application open. Visual Studio, Notepad...
Step 1 - Get the Tools Cost - $0Time - About 3 hours to download an install Visual Web Developer 2005 Express Edition Visual C# 2005 Express Edition SQL Server 2005 Express Edition - You will have the option of downloading this when you download Visual Web Developer and Visual C#, but I recommend downloading SQL Server separately with Advanced Services for reporting. Step 2 - Getting Comfortable Cost - $0 to $30 if you purchase the eBookTime - 30 hours for either the video or book route Start with...
I think the guy that wrote this article just woke up one morning and thought, "Let's see how many people I can piss off today." Here is what he has to say about his experience with open-source IDEs. They were slow, flaky and frustrating. I very soon abandoned the Java world – I couldn’t stand the tools, the debuggers were crap or non-existent and the documentation was sparse one-dimensional and uninspiring. There is nothing out there in the open source world that can begin to compete with the fluidity...
We are adding a senior C# developer to our team for an ASP.NET 2.0 product scheduled to be released in about 1 year. This is product development, not IT support, with a software development firm. This is all we do. If you are interested, or know someone who is, please let me know. Here is the official description: Mitchell Humphrey is a software vendor located in St. Louis, MO, with a nationwide client base. We are currently seeking a Senior Software Developer in our Software Development Department....
Ever needed to query a self referencing table to build out a tree of data, such as a menu? Rob Conery presents a very useful and fast way to do so using SQL Server 2005. Read Recursive Queries in SQL 2005
SubSonic will work fine with Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition, so you can get started without dropping a dime. You can also use MySQL or any database that can be accessed through Enterprise Library for .NET Framework 2.0, but SQL Server is probably the most likely setup. Note: The sample web site included with the SubSonic source code includes an SQL script to create the Northwind database. This article will use that database when examples are needed....
Common Table Expressions, or CTE, are a new construct introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query. Moreover, CTEs can be recursively defined, allowing a recursive entity to be enumerated without the need for recursive stored procedures. In this article we'll examine the benefits, uses, and syntax of both recursive and non-recursive CTEs. Read on to learn more!
This sample is a self-contained ASP.NET application that demonstrates a few things:
In this article we'll look at two ways to improve Scott's method. The first approach uses a table variable (just like Scott's), but utilizes the SET ROWCOUNT command to reduce the number of records read and inserted into the table variable. The second technique more cleverly uses SET ROWCOUNT to provide an even more efficient approach than the first.
SQL Server 2005 offers a number of new features over its predecessor, including many features aimed at making working with databases more like writing .NET application code. For example, in SQL Server 2005, stored procedures, triggers, UDFs, and so on can be written using any .NET Framework programming language (such as Visual Basic or C#). Another feature, and the focus of this article, is SQL Server 2005's support for TRY...CATCH blocks.
Looks like service pack 1 of SQL Server 2005 (already?) will include the Management Studio with SQL Server Express.
For a while I have been adding books to the library feed of this site one at a time. Here is a list of books that I currently keep on my “must have” bookshelf. I will update this periodically as new volumes are added and dropped. The Library link list will also stay syncronized.
REAL Software, providers of REALbasic, cross-platform that really works, announced today that REAL SQL Server 2006, a multi-user relational database engine for use with REALbasic, is in beta.
If you are an MSDN subscriber you can get the final release of Visual Studio 2005 and SQL Server 2005 now. Good luck downloading it. I haven't even been able to login.
I remember whan all we had were MCSEs and MCSDs and by golly, we liked it! Now were gonna need an MCCA (Microsoft Certified Certification Analyst) just to figure out who is who!
Microsoft has released Service Pack 2 for Microsoft Office 2003.
Hosting.com is pleased to provide FREE hosting plans for ASP.NET 2.0 and SQL Server 2005 Express Edition.
This new service replaces Windows Update and adds patching for Office, Exchange and SQL Server all in one place.
Here is a quick blast of items that I have stored in Yahoo! MyWeb related to .NET 2.0
How do I setup the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of SQL Express?