How much would it cost you to stand at the wrong end of a shooting gallery? Nuthin` if you`re talkin` SQL Express
I'm a natural born fool for free stuff. Better yet, I'm an even bigger fool if the free stuff is worth something. I can't get over how cool SQL Express 2005 is and the cost is, well... free. Here's yet another example of how cool this thing truly is:I'm about to plow through SQL 2005 Reporting Serv......
SQL Server Express - Pre-Built Database Designs and Publish To Hoster Wizard
SQL Server Express Starter Schemas The SQL Server Express team got Barry Williams from http://databaseanswers.org to publish 10 pre-built schemas for common database designs to help ease the pain of working with databases and for users to understand what real-world database schemas look......
.NET Masters Lecture Series :: Los Angeles, CA :: Saturday, February 10th
In a couple of weeks I'll be presenting a full-day, hands-on conference/lecture/class/lab at the Robert Half Technology offices in Los Angeles. Together we will build a complete, functional, real-world blog engine that highlights recommended practices and ASP.NET 2.0-specific features. Topics discu......
Robyn Page`s SQL Server Cursor Workbench
The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on when they should and mainly should not be used. By example and testing Robyn Page proves that, when handled with care, cursors are not necessarily a "bad thing"....
...
SQL Server 2005 Compact Edition - Kudos to the SQL Team
If you track the Microsoft or ASP.NET weblogs you've surely noticed that roughly two weeks ago now Microsoft released SSCE or SQL Server 2005 Compact Edition. Rather than simply saying "they released it, go download it because it's cool" I want to openly thank the SQL team ......
Video Series: SQL Server 2005 Express Edition for Beginners
This video series is designed specifically for SQL Server beginnersindividuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases....
...
Active Query Builder .NET Edition is out!
Active Query Builder is a powerful .NET component to build complex SQL queries with ease. Active Query Builder is a perfect choice for both SQL beginners and experienced query writers. It renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional......
Looking for the perfect job where you can do Test Driven Development and Pair Programming?
Thycotic is growing once again – we are looking for another top calibre developer to join our team - this is a great opportunity to practice agile techniques on the Microsoft .NET platform from an experienced team while working on great products and with interesting clients.
We&nbs......
LINQ to SQL " "Real" " Example App Available
The Atlanta Code Camp was today, so I finally got to give my LINQ and O/R Mapping talk that I've been preparing.I tried to have minimal slides so that I could do a deep dive into real code, but I still went a little too long. The slides look great on my own PC, and in fact they're mos......
LINQ to SQL "Real" Example App Available
The Atlanta Code Camp was today, so I finally got to give my LINQ and O/R Mapping talk that I've been preparing.I tried to have minimal slides so that I could do a deep dive into real code, but I still went a little too long. The slides look great on my own PC, and in fact they're mos......
Next generation data access with LINQ - February edition of VSJ magazine (article)
Just thought I'd give you all the heads up on this article I have written for VSJ magazine. The article covers: Advatages of using LINQ to SQL Overview of LINQ Entities Tools Querying entities (including related entities) On the front cover there is a caption saying "Hands on .NET 3.0" with th......
Codemash: Follow up
Ok -- back home and back blogging on a regular keyboard again! Codemash was awesome! I had a great time and day two was arguably the best day (for me). Scott Guthrie is not only a really smart guy, he's a great communicator and his presentations were awesome. I'm definitely going ......
Vista DB 3.0 to support Mono
VistaDB has announced that their upcoming 3.0 release will have complete support for Mono. VistaDB is an embeddable SQL database engine built completely in C# and occupying only 600k on disk....
...
A Security Overview of Microsoft Visual Studio 2005 Team Edition for Database Professionals
Visual Studio 2005 TE for DBPro is the most recent addition to the VS Team Suite of products. Its mission is to bring developers of database application code (Transact-SQL for SQL Server 2000 & SQL Server 2005) into the application development life cycle....
...
Quick Tip: Performing an FTP rename
Nigel Rivett provides a technique for moving files from one FTP directory to another, and for performing this processing from SQL Server Integration Services....
...
Working with Stored Procedures in an MS Access Project
This tutorial shows the steps involved in creating stored procedures using MS Access 2 with the back end SQL 2 Server. It describes three kinds of stored procedures including procedures that return values in parameters....Automate Software Builds with Visual Build Pro Easily create an automat......
Free Source Code mojoPortal 2.2 Released
I'm happy to announce the release of version 2.2 of mojoPortal, an Open Source Content Management/Portal solution that uses and illustrates most of the compelling new 2.0 .NET features, inlcuding Personalization/WebParts, Custom Providers, Master pages, XHTML compliance, Localization, and more.mojo......
The Ultimate Excuse Database
Is your IT project in trouble? Do you need to create a smokescreen so that no-one can pin the blame on you? No problem! Marvel at Phil Factor's versatile use of T-SQL functions in creating the "ultimate excuse database" and then start generating your excuses immediately!...
...
Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET
Learn how to create a Windows Forms app using Visual Basic.NET that synchronizes data between a SQL Server 2005 database and a SQL Server 2005 Compact Edition database using Remote Data Access (RDA)....
...
Wrap it up!
In our daily programming with .NET, we often find new things to use. In some cases Microsoft tells us there is something new to use. Take the case of moving from .NET 1.1 to .NET 2.0. Remember in .NET 1.1 how you used the ConfigurationSettings.AppSettings("MyValue") to retrieve valu......
Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
Last month I posted about the new (free) Database Publishing Wizard that is designed to make it much, much easier to upload and deploy SQL Express and SQL Server databases in a web hoster environment. In my first Database Publishing post, I walked through how you can use the Da......
Tip/Trick: How to upload a .SQL file to a Hoster and Execute it to Deploy a SQL Database
Last month I posted about the new (free) Database Publishing Wizard that is designed to make it much, much easier to upload and deploy SQL Express and SQL Server databases in a web hoster environment. In my first Database Publishing post, I walked through how you can use the Da......
Laptop Suggestions, Advice, or Recommendations?
It's about time for me to upgrade my laptop and am soliciting any
recommendations/advice you, my faithful blog reading audience of six, care to share. I use the laptop for User Group talks, conferences, and as the
presentation/demo machine for my classes and training. In total, it gets used maybe......
Saving InfoPath Forms to SQL Server 2005 as XML
The new XML data type within SQL Server 2005 opens new possibilities for persisting XML data of InfoPath forms. This article discusses and demonstrates how to save entire InfoPath forms to SQL Server 2005 as typed or untyped XML data.
...
Query paging by one trip to MS-SQL 2005 via one simple query.
Query paging by one trip to MS-SQL 2005 via one simple query. Without using stored procedure, view or all others features. Only with T-SQL and .NET...
...
Retrieving Data from a SQL Server 2005 Database Using the SQL DataSource Control in ASP.NET 2.0
In this article Jayaram demonstrates how to retrieve data from a SQL Server 2005 Database using the SQL DataSource Control in a step-by-step manner.
...
The TSQL of Verticons and Anime Emoticons
Well there I was trying to think of an idea for a blog (u_u) when it suddenly occurred to me (*_*) that I should do a nice little SQL function on Emoticons. It was a happy thought (^_^) which made me smile (n_n). I was amazed (^.^) and astonished (*^*) sometimes incredulous (o_O) at the variety of ......
Pop Rivett and the Suspect Database
When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly harmless colleague, our curmudgeonly hero jumps into action...
...
The T-SQL Emitted by the aspnet_regsql.exe Command Line Program when Adding the Infrastructure for SQL Cache Dependencies
In order to use SQL cache dependencies in ASP.NET 2.0 on the Express Edition of SQL Server 2005 or on SQL Server 7.0 or 2000, ASP.NET needs to continuously poll the database to determine if there's been any change to the monitored tables. For this to work, the database needs some infrastructure ins......
The T-SQL Emitted by the aspnet_regsql.exe Command Line Program when Adding the Infrastructure for SQL Cache Dependencies
In order to use SQL cache dependencies in ASP.NET 2.0 on the Express Edition of SQL Server 2005 or on SQL Server 7.0 or 2000, ASP.NET needs to continuously poll the database to determine if there's been any change to the monitored tables. For this to work, the database needs some infrastructure ins......
Examining ASP.NET 2.0's Membership, Roles, and Profile - Part 8
One of the main challenges of building a programming framework is balancing the desires to create a standardized, straightforward
API for accomplishing common tasks and providing flexibility and customizability so that developers using the framework can
mold the framework to fit their applicati......
Returning Values from Stored Procedures in ASP.NET
When developing larger scale applications it is quite likely that at some point you’ll be working with Microsoft’s SQL Server. Being the enterprise database server of choice for Microsoft based applications odds are you’ll be using either it or MS Access for smaller applications.
During the initial......
An alternative way to MSWord Render extension of SQL Reporting Service using XSLT and xml document mapping.
SQL Reporting service doesnt support export report to MSWord yet. By using render extensions for exporting MSWord not so easy. This article describes an alternative way converting SQL report to MSWord file....
...
sysobjects, sys.objects... what about INFORMATION_SCHEMA?
SQL Server Management Objects (SMO) is one of the coolest parts of SQL Server 2005, in my opinion. I've written about SMO before, and used it extensively in writing Data Dictionary Creator. In a nutshell, SMO is a collection of objects that are designed for programming all aspects of......
[tip] Use the Database Publishing Wizard to script your table data
Jeff Atwood recently asked "Is your database under version control?" Well, is it? It's not as easy as it sounds. Until now, there wasn't a good, scriptable solution to the problem. I'll run through a few of the options I've looked at in the past, but let's jump to to the punchline: The Databa......
TSql vs. SQL CLR Performance Analysis
Original Post: http://morewally.com/cs/blogs/wallym/archive/2006/12/27/616.aspxI went and spoke to the Michiana .NET User Group on November 21, 2006.The talk was in South Bend, IN.The subject of the talk was Sql Server 2005 CLR Objects.Whenever I do the talk, I got get the question of “Which ......
TSql vs. SQL CLR Performance Analysis
Original Post: http://morewally.com/cs/blogs/wallym/archive/2006/12/27/616.aspxI went and spoke to the Michiana .NET User Group on November 21, 2006. The talk was in South Bend, IN. The subject of the talk was Sql Server 2005 CLR Objects. Whenever I do the talk, I got get the ques......
Team System Year End Round Up...
Yeah I put year end in the title, but don't think that means I'm ready to admit that 2006 is already over! Here's a few Team System things that are happening that I haven't blogged on. Version 1.2 of the MSSCCI Provider has been released - Remember this is what let's you get to TFS from all those ......
Workflow SQL Services Installation
Windows Workflow Foundation comes out of the box with the ability to persist workflows into SQL Server and to use SQL Server to store tracking information. In order to use these on a Database you must run 4 scripts to install the schema and procedures into a database that will be used to store the ......
Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)
Scenario: You finish building a great ASP.NET application, have everything tested and working right on your local system, are taking full advantage of the new ASP.NET 2.0 Membership, Role and Profile features, and are ready to publish it to a remote hosting environment and share it with the w......
A Database Development Model Using SQL Compare
Richard Mitchell and Steven Davidson describe how they used Red Gate's database schema-comparison tool, SQL Compare, to develop the latest version of red-gate.com...
...
SQL Server 2000/MSDE on Vista? Nope
Perhaps it's time to look for the "list of things that won't be supported on Vista".
In the meantime, thanks to Kate Gregory for pointing
out this one.
...
...
SQL Server recovery model selection (or, what`s this 3GB LDF file?!)
SQL Server recovery models can be a bit tricky. By default, SQL Server databases are set to Full Recovery mode, which means they maintain sufficient logs to restore to any specific point in time. These logs can grow to several GB for a small, lightly used database over time. For a developmen......
.NET SQL Authorization Manager
.NET Sql Authorization Manager (AzMan x .NET 2.0) allows you to set Item-based permissions for Authorization Manager-enabled Microsoft.NET 2.0 applications. Storage reside on a MS Sql Server DataBase and can be administrated by a managed MMC 3.0 Snap-In....
Swivel
Swivel has been called "YouTube for Data". Very cool.Who will be the first to post their Team System productivity data? How about some kind of SQL Server connector to Swivels? ...
MobiLink Synchronization Wizard in SQL Anywhere 10
If you work with data that is distributed and stored in databases then you understand the importance of keeping multiple databases synchronized. Mobilink is a technology that can help with that process. Keep reading to learn more....New SAP NetWeaver J2EE Preview! Try the new SAP NetWeaver J2EE pr......
Output Caching in ASP.NET 2.0
One of the most sure-fire ways to improve a web application's performance is to employ caching. Caching takes some expensive
operation and stores its results in a quickly accessible location. ASP.NET
version 1.0 introduced two flavors of caching:
Output Caching - caches the entire rendered mar......
Reporting Services - Add a logo to the Report Manager
The SQL Server Reporting Services Report Manager is functional, but it's not very customizable. The ASPX pages just reference compiled assemblies, so the only real way to modify them is via CSS. What makes that more difficult is that the SSRS HTML is poorly constructed so that the tags you'd most ......
Use ASP.NET Membership and Role Providers in Windows Communication Foundation
It's possible to use ASP.NET membership and role providers for authentication and authorization in Windows Communication Foundation.
To enable ASP.NET membership for authentication you need to modify service configuration file and add appropriate items for ASP.NET membership to it then set Win......
Create Drill-Through Reports using ReportViewer in ASP.NET 2.0
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0....
...