Browse by Tags

All Tags » SQL Server   (RSS)
Building Occasionally Connected Smart Clients with WPF
02 November 09 02:57 PM
This month Dev Pro Connections has an article by Milind Lele on using Sync Services in a WPF application: Building Occasionally Connected Smart Clients with WPF With Sync Services and Visual Studio 2008 you can visually design your local data cache and Read More...
Postedby Beth Massi | 0 Comments    
Filed under: , , , ,
Inserting Master-Detail Data into a SQL-Server Compact Edition Database
15 September 09 07:11 PM
Yesterday John posted on the Visual Studio Data blog how to Refresh the Primary Key Identity Column during an Insert Operation using SQL Server. In that post he shows how the DataSet designer sets up a batch Insert statement to retrieve identity keys Read More...
Postedby Beth Massi | 1 Comments    
Filed under: , , , , ,
“Moving in” to Windows 7: My Favorite Features & Some Tips on Setup
01 September 09 05:22 PM
Last week I installed Windows 7 Enterprise on my main laptop – a Lenovo T60p ThinkPad. I was up in Redmond and MSIT made it available via a super-easy network boot that installs Office Enterprise, all the IT-required software like anti-virus, and all Read More...
Postedby Beth Massi | 13 Comments    
Filed under: , , , ,
Attaching a Local SQL Server Database Using sqlcmd
18 December 08 02:35 PM
I've been getting asked a lot lately about how to easily attach a local SQL Server/Express database file (.MDF file) to an instance of SQL Server (any edition) . In most of my samples I distribute local SQL Server databases and use user instance connection Read More...
Postedby Beth Massi | 20 Comments    
Filed under: , ,
Editing Data from Two Tables in a Single DataGridView
15 October 08 06:31 PM
I've had a lot of questions lately on how to display data from two separate tables in the database into a single DataGridView for editing. It sure would be nice if all our data was in a single table, but in reality most of the time it's not. Basically Read More...
Postedby Beth Massi | 24 Comments    
Filed under: , , , , , , ,
Enabling Remote SQL Express 2008 Network Connections on Vista
17 September 08 07:30 PM
Today I spent way too long trying to enable remote network connections on my SQL 2008 Express database running on my Vista development machine so I thought I'd post the steps here. Please note that these settings may NOT be appropriate for your production Read More...
Postedby Beth Massi | 32 Comments    
Filed under: , , , ,
What's New in Visual Studio 2008 SP1 - Client and Data Features
11 September 08 12:51 PM
Last night I spoke at East Bay.NET UG on some of the new features in Visual Studio Service Pack 1 focusing on client and data. I did a whirlwind tour of new SQL 2008 data types and Sync Services enhancements , ADO.NET Entity Framework , ADO.NET Data Services Read More...
Postedby Beth Massi | 6 Comments    
Filed under: , , , , , , , , , ,
Channel 9 Interview: SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1
08 August 08 05:12 PM
I just posted a new Channel 9 interview with Milind Lele, a PM on the VS Pro Tools team. In this interview Milind shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support Read More...
Postedby Beth Massi | 2 Comments    
Filed under: , , ,
Support for SQL 2008 Data Types Coming into LINQ to SQL
22 February 08 05:22 PM
Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new features you can expect to see added to LINQ to SQL. This includes support for new data types coming in SQL 2008. Enjoy! Read More...
Postedby Beth Massi | 3 Comments    
Filed under: , , ,
Resizing Images Stored in SQL-Server
28 August 07 11:35 AM
In SQL-Server we can store images inside database tables directly using the Image column type. And with .NET 2.0 data binding it can automatically convert these images (stored as byte arrays) into System.Drawing.Image classes for you. For instance, say Read More...
Postedby Beth Massi | 23 Comments    
Filed under: , , , ,
Attachment(s):PictureResizing.zip
Building a Secure Login Form (Parameterized Queries Part 2)
06 June 07 10:48 PM
In my first post on parameterized queries I built a simple login form that really was a contrived example meant to showcase how to use the TableAdapter Configuration Wizard to configure a parameterized query. However, since I opened myself up here, I Read More...
Postedby Beth Massi | 27 Comments    
Filed under: , , , , ,
Attachment(s):LoginClient.zip
Working with a Local Data File in VS
29 May 07 05:23 PM
Visual Studio 2005 made some big improvements in the way applications work with data, from BindingSources to the Data Sources Window all the way to a free version of SQL-Server called SQL-Server Express . I've had a few customers get stuck on using SQL-Server Read More...
Postedby Beth Massi | 18 Comments    
Filed under: , , , ,
Reading from a Serial Port and Saving to a Database
05 May 07 09:14 AM
Recently I was sent a question about how to read from a serial port and save the information to a database so instead of following up privately I thought I'd post my answer here. There's a good article in the MSDN Library that has some hints on how to Read More...
Postedby Beth Massi | 8 Comments    
Filed under: , , , ,
Attachment(s):ReadFromSerialPort.zip
Visual Basic How-To Video Series is Online
04 May 07 11:48 AM
This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the details Read More...
Postedby Beth Massi | 15 Comments    
Filed under: , , , , , ,
SQL Server Express Video Series
03 April 07 11:25 AM
If you're new to SQL Express , Reporting Services , or databases in general, you'll want to check out the SQL Server Express video series up on www.asp.net . I just finished watching them myself. These videos walk you through all the free tools you get Read More...
Postedby Beth Massi | 2 Comments    
Filed under: , , ,

This Blog

Syndication

Bookmark and Share

Add to Technorati Favorites


Your Host:
Me!
NOTE: The opinions expressed here are MY OWN and are not necessarily those of my employer, partners, customers, friends, or family. ALL content presented AS-IS, for entertainment purposes only with ABSOLUTELY NO WARRANTY expressed or implied.
Page view tracker