SQL Detach / Attach blomqvist, January 1, 0001 I was working with a system migration where a client had moved a database server. The actual SQL Server HW was moved but not the SAN where the database MDF’s and LDF’s resided. They solved this by copying ... SQL Detach / Attach 0 0 0
Adding Rows in GridView with Edit, Update and Delete Functionalit... Vincent Maverick Durano, January 1, 0001 This example is a continuation of my previous post about “Adding Rows in GridView”. In this example I will going to demonstrate on how we are going to do Edit, Update and Delete operations in GridView ... Adding Rows in GridView with Edit, Update and Delete Functionalit... 0 0 42
SQL Server 2005/ SQL Server 2008 - Rebuild or Reorganize ALL Inde... Robz / Fervent Coder, January 1, 0001 I found this gem while looking at a database that needed all indexes rebuilt. I actually had to create the programmatic way of doing rebuilding all indexes in a database based on the information in these ... SQL Server 2005/ SQL Server 2008 - Rebuild or Reorganize ALL Inde... 0 0 2
Adding Rows in GridView Vincent Maverick Durano, January 1, 0001 This example shows on how to add rows of data in the GridView control. In this example, I created a simple database table called “Table1” for storing the data. The Table has the following columns: Id – ... Adding Rows in GridView 0 0 18
A very good Free SQL Server Utility : FineBuild Dave Oliver, January 1, 0001 Codeplex is a wonderful site. However not just for the .Net coder but the SQL Server guy/gal can find plenty of goodies there as well. One such goody is the FineBuild utility that does as the name suggest ... A very good Free SQL Server Utility : FineBuild 0 0 1
attaching adventureworks2008 on full version of sql server Alex Bransky, January 1, 0001 For anybody that bought the SQL Server 2008 Self-Paced Training book for 70-433, if you are running a full version of SQL Server 2008 rather than the express edition, you will have problems attaching the ... attaching adventureworks2008 on full version of sql server 0 0 15
Microsoft and True Grit andrewbrust, January 1, 0001 Last week, i.e. in a single week, Microsoft was on real tear: the company announced a release date for Windows 7, disclosed details of Zune HD and Zune’s integration into Xbox Live, discussed Project Natal ... Microsoft and True Grit 0 0 1
BizTalk Server 2009 and WCF SQL Adapter Pt.2 martinabbott, January 1, 0001 Having posted on the SQL Adapter to select data from a SQL Server database, I realised (too late as it happens!) that I had missed one approach. This approach is to use the Strongly-Typed Procedures option ... BizTalk Server 2009 and WCF SQL Adapter Pt.2 0 0 0
Free eBook on what’s new in SQL Server 2008 Dave Oliver, January 1, 0001 It’s not often we get stuff for free but Microsoft has decided to give away a complete book, not just afew sample chapters. All you have to do is go to this link , press the ‘Sign Up’ button, leave some ... Free eBook on what’s new in SQL Server 2008 0 0 4
BizTalk Server - New Downloads and KBs Jay Kinker, January 1, 0001 Downloads Microsoft BizTalk Adapter for SQL Server http://www.microsoft.com/do... BizTalk Adapter Pack 2.0 http://www.microsoft.com/do... ... BizTalk Server - New Downloads and KBs 0 0 0
Visio Note To SQL Server Description Chip Lemmon, January 1, 0001 I created a data model in Visio AE 2003 and went through the extremely tedious task of putting a note on just about every column. Unfortunately when I generated the DDL the notes on the columns were simply ... Visio Note To SQL Server Description 0 0 1
Configuring Oracle datasource in Sharepoint Designer Patrick Olurotimi Ige, January 1, 0001 I solved a problem identical to the description of this problem with SQL SERVER and you can see my post here; and I’ll share the solution for oracle below. After you have configured the Oracle data source ... Configuring Oracle datasource in Sharepoint Designer 0 0 3
Move AutoGenerate Columns at LeftMost Part of the GridView Column... Vincent Maverick Durano, January 1, 0001 There are certain scenarios that we need to combine an AutoGenerated Columns with TemplateField Columns or even BoundField Columns in the GridView. As we all know, by default the GridView will automatically ... Move AutoGenerate Columns at LeftMost Part of the GridView Column... 0 0 20
Think MANY TIMES before choosing Entity Framework Sudheer Kumar, January 1, 0001 Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; ... Think MANY TIMES before choosing Entity Framework 0 0 2
BizTalk Server 2009 and WCF SQL Adapter martinabbott, January 1, 0001 I started having a think about how you could make BizTalk Server 2009 RESTful as I had been asked to give it some thought. Whilst thinking about it and wondering how I could let any subscription know the ... BizTalk Server 2009 and WCF SQL Adapter 0 0 11
Baton Rouge SQL / .NET Saturday Coming August 1, 2009! Stacy Vicknair, January 1, 0001 On August 1st the Baton Rouge Area SQL Server and .Net user groups are hosting an all day free SQL Server and .Net training event! Attendees will have chances to win great prizes! What more could a SQL ... Baton Rouge SQL / .NET Saturday Coming August 1, 2009! 0 0 0
5 Quick Steps to Get Introduced with Visual Studio Team System an... Mohammad Ashraful Alam, January 1, 0001 Last month (May 2009) Microsoft has released its first beta for Visual Studio Team System 2010 and Team Foundation Server 2010 release, two of the most waited and wanted tools in developer community. From ... 5 Quick Steps to Get Introduced with Visual Studio Team System an... 0 0 0
Review: Three external screens from a single laptop with help fro... Liam Westley, January 1, 0001 As a developer I’ve become used to multiple monitors to increase my productivity. Debugging applications is much easier when one monitor is running Visual Studio and a second monitor is displaying the ... Review: Three external screens from a single laptop with help fro... 0 0 0
Slow File Receive RobBowman, January 1, 0001 I encountered a problem a few days ago with files not being picked from a receive location. The configuration was very simple, a two node group with a file receive location pointing at a share on a windows ... Slow File Receive 0 0 1
NDepend and CruiseControl.NET Robz / Fervent Coder, January 1, 0001 NDepend is one of the best code analysis tools out there for determining code quality! It does so with some advanced metrics and I can say I still don't understand all of it, but we take advantage of the ... NDepend and CruiseControl.NET 0 0 1
Get to love your database or not... woodbase, January 1, 0001 People always told me not to use MS Access for my web sites, however the closest they ever got to actually telling me why not, is something like: "It doesn't perform well if you have many user!" Well how ... Get to love your database or not... 0 0 1
WinPHP challenge recap Timmy Kokke, January 1, 0001 Introduction The WinPHP challenge is running towards it’s closing time. Only a few days before entering I came with the idea to enter the contest. I had to put a lot of my spare time into it, but it was ... WinPHP challenge recap 0 0 2
Advanced Debugging with Visual Studio 2008 Chris Williams, January 1, 0001 June 9, 2009 – Twin Cities Developers Guild Meeting, featuring Mike Benkovich When: 6:00 PM. Where: New Horizons of Minnesota (4510 West 77th Street - Edina, MN 55435) MAP Mike Benkovich Topic: Advanced ... Advanced Debugging with Visual Studio 2008 0 0 0
Pre-Select Multiple ListBox items based on Database Value Vincent Maverick Durano, January 1, 0001 I decided to write a simple demo about this because I always encounter this issue at the forums. Basically, this demo shows how to pre select multiple list items in the ListBox control based from database ... Pre-Select Multiple ListBox items based on Database Value 0 0 1
FAQ: Calculate Totals in GridView and Display it in Footer - Serv... Vincent Maverick Durano, January 1, 0001 I decided to write this post because I always encounter this kind of issue so many times before at the forums. The main question is that they want to automatically calculate the totals when a user enter ... FAQ: Calculate Totals in GridView and Display it in Footer - Serv... 0 0 7
Rule : Previous releases of Microsoft Visual Studio 2008" failed ... Aman Garg, January 1, 0001 You might get entangled while reinstalling SQL Server 2008 on a PC where VS 2008 has already been installed before. Simple way to resolve this scenario is to install VS 2008 SP1 on the machine. Various ... Rule : Previous releases of Microsoft Visual Studio 2008" failed ... 0 0 13
ListBox Control: Save Multiple Selected Items in the Database Vincent Maverick Durano, January 1, 0001 This example shows the basics on how to save multiple selected items from the ListBox control to the database. Please note that this example requires a basic knowledge of ADO.NET. STEP 1: Setting up the ... ListBox Control: Save Multiple Selected Items in the Database 0 0 11
Loving LINQ Ray Linder, January 1, 0001 Not too long ago, I spared some time to discover the hype of LINQ, primarily, LINQ to SQL. I was amazed of how much faster I could get things done with much less code. In fact, I’ve converted much of Glacsy.com ... Loving LINQ 0 0 6
A 'Get it Done Now!' Approach for transforming SQL Server Data to... Paula DiTallo, January 1, 0001 First, for all of the MS SQL Server database purists out there that will complain vehemently against this method of extraction/formatting because of the special characters (SEE: http://www.webmonkey.com/re... ... A 'Get it Done Now!' Approach for transforming SQL Server Data to... 0 0 0
SQL Update Statement - using SubSelect Paula DiTallo, January 1, 0001 This is a simple, but helpful example of changing a boolean or bit flag in a table to 'True' when the condition in the subSelect is met. In this context, the SQL statement finds all the cases where a sales ... SQL Update Statement - using SubSelect 0 0 0
NDepend review – code evolution achieved by following NDepe... Andrew Siemer - www.andrewsiemer.com, January 1, 0001 The people behind the NDepend software recently provided me with their latest version of NDepend to see what I thought. I initially ran the package over one of my recent projects and found that the reporting ... NDepend review – code evolution achieved by following NDepe... 0 0 0
Simple Sql script for finding a Guid/Uniqueidentifier in your dat... Patrice Calve, January 1, 0001 So... You're trying to debug an application that is using a large (100> tables) database and for a reason or an other, you don't understand where this darn Id is coming from! Here's a simple Sql Script ... Simple Sql script for finding a Guid/Uniqueidentifier in your dat... 0 0 0
May CTP of 'Oslo' - Initial experiments Charles Young, January 1, 0001 Microsoft yesterday released a new ‘May 2009’ CTP for their 'Oslo' toolset. This can be downloaded from Microsoft's web site at http://www.microsoft.com/do... ... May CTP of 'Oslo' - Initial experiments 0 0 1
Extending WinForms CRM to a Web application Webgui, January 1, 0001 Learn how CRMCompany created a solution from their existing Windows application based CRM that is available over the Web and answers the requirements of the customer. The article explains why Visual WebGui ... Extending WinForms CRM to a Web application 0 0 0
Error: Could not load file or assembly 'System.Transactions, Vers... Harish Ranganathan, January 1, 0001 Recently, I was trouble shooting an error for my friend. Despite having all the necessary framework and service packs installed, this error “Could not load file or assembly 'System.Transactions, Version=2.0.0.0, ... Error: Could not load file or assembly 'System.Transactions, Vers... 0 0 1
SQL Server 2008 R2 Dave Oliver, January 1, 0001 R2 ! As you may know I’m abit of a SQL Server nut so I was particularly interested in the announcement at the recent TechEd of SQL Server 2008 R2. R2 is the combination of the Kilimanjaro, Madison and ... SQL Server 2008 R2 0 0 0
Windows BizTalk Services? Joe Klug, January 1, 0001 With "Dublin" on the horizon as the future distributed application server role for Windows, does it make sense for Microsoft to call this new role "Windows BizTalk Services"? This would in many ways mimic ... Windows BizTalk Services? 0 0 3
Upgrading to TFS 2010 Beta 1 and SQL Collation Martin Hinshelwood, January 1, 0001 *Moved to: Upgrading to TFS 2010 Beta 1 and SQL Collation I have just finished installing TFS 2010 beta 1 and doing an upgrade of out TFS 2008 data. This did not go well… Due to a collation mismatch between ... Upgrading to TFS 2010 Beta 1 and SQL Collation 0 0 1
Return SqlDataReader from a method bullpit, January 1, 0001 .NET's SqlDataReader class is based on an active connection to the database. This means that while the SqlDataReader is in use, the SqlConnection that is serving the SqlDataReader is open and cannot be ... Return SqlDataReader from a method 0 0 1
Show images on Grid View from File Stream Agha Usman Ahmed, January 1, 0001 Background : In my last post about SQL Server 2008 new feature File Stream (Saving and Retrieving File Using FileStream SQL Server 2008), we did an example of saving an image to the file stream and then ... Show images on Grid View from File Stream 0 0 1
GWB: First Post on GWB and SQL Server 2008 Jeff Julian, January 1, 0001 We did the database migration this morning and everything seems to work perfectly. The environment is about 5x what our previous server configuration was and we moved from SQL Server 2000 to 2008. Ping ... GWB: First Post on GWB and SQL Server 2008 0 0 0
Creating software in two days: GiveCamp Retrospective Part 1 Len Smith, January 1, 0001 At Lansing GiveCamp I was chosen to lead a team tasked with creating a guest registration system for Ronald McDonald House of Mid-Michigan. Ronald McDonald House wanted to get off their current system, ... Creating software in two days: GiveCamp Retrospective Part 1 0 0 4
Step by Step : Installing Visual Studio 2010 Ramaraju, January 1, 0001 Finally I am able to download the Visual studio 2010 and prepared my system to install visual studio. I downloaded VS2010Beta1ENU_PRO_2PartsTo... and VS2010Beta1ENU_PRO_2PartsTo... ... Step by Step : Installing Visual Studio 2010 0 0 32
Microsoft Manufacturing Toolkit based on BizTalk & SQL Server? is... Jay Kinker, January 1, 0001 Dependencies The Manufacturing Toolkit requires the following technologies in order to compile and run: · BizTalk 2009/BizTalk 2006 R2 · SQL Server 2008/SQL Server 2005 · Windows Server 2003 R2/Windows ... Microsoft Manufacturing Toolkit based on BizTalk & SQL Server? is... 0 0 0
Bulk Insert ,Update and Delete with ASP.Net ListView control thanigai, January 1, 0001 ASP.Net Listview is a Template Driven Grid control from Microsoft. It combines the features of DataGrid, GridView and Repeater. There is lot of web resources available about ListView. I had a scenario ... Bulk Insert ,Update and Delete with ASP.Net ListView control 0 0 15
EDMPASS Inaugural Meeting May 28th! D'Arcy Lussier, January 1, 0001 If you live in Edmonton and do anything with SQL Server you should definitely check out the upcoming first ever meeting of the Edmonton chapter of the Professional Association for SQL Server (EDMPASS). ... EDMPASS Inaugural Meeting May 28th! 0 0 0
BAM Archiving/BAM_DM_ observations Andy Morrison, January 1, 0001 From the BizTalk documentation: “The DTS package, BAM_DM_<ActivityName>, performs the partitioning and archiving/purging. Each time this package runs, it truncates another partition and archives/drops ... BAM Archiving/BAM_DM_ observations 0 0 0
DotNetNuke 04.09.04 Upgrade Brian Scarbeau, January 1, 0001 In the past, after backing up my SQL database and DNN site, I'd hold my breath when I upgraded my sites hoping and praying that all will be well after the upgrade. Today, I did the same when I upgraded ... DotNetNuke 04.09.04 Upgrade 0 0 0
How to get a random record using MSSQL mikedopp, January 1, 0001 This is a very short post. so bear with me. SELECT * FROM Northwind..Orders ORDER BY NEWID()The Magic here is NewID() Flickr Tags: NewID(), Random Records in MSSQL BuzzNet Tags: NewID(), Random Records ... How to get a random record using MSSQL 0 0 0