Error: conversion of a datetime2 data type to a datetime data typ... intermark, January 1, 0001 Using VS2008 and Entity Framework, the exact error message is: "The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.\r\nThe statement has been terminated." ... Error: conversion of a datetime2 data type to a datetime data typ... 0 0 1
Fancy a job in the Microsoft UK ISV technical team? Eric Nelson, January 1, 0001 If you are: a senior technologist (Application Architect, Senior Developer or similar) with strong experience in developing solutions using the Windows platform (Visual Studio, SQL Server, IIS etc) fancy ... Fancy a job in the Microsoft UK ISV technical team? 0 0 0
A bit about backups and tools: Virtual Restore Enrique Lima, January 1, 0001 Over the last months, I have been putting a considerable level of effort recovering databases. That would be databases in dev, staging and prod. Somewhere, somehow someone got access to Prod and decided ... A bit about backups and tools: Virtual Restore 0 0 0
Silverlight Cream for April 24, 2011 -- #1077 Dave Campbell, January 1, 0001 In this Issue: Michael Washington, Morten Nielsen, John Garland, Bil Simser, Adam Nathan, András Velvárt, WindowsPhoneGeek(-2-), Jesse Liberty(-2-), Martin Krüger, Damon Payne, and Xianzhong Zhu. Above ... Silverlight Cream for April 24, 2011 -- #1077 0 0 0
NoSQL, No Peace andrewbrust, January 1, 0001 After several months of research, review and revision, a white paper I wrote for the SQL Azure team, “NoSQL and the Windows Azure Platform”, has been published by Microsoft. If you go to http://www.microsoft.com/wi... ... NoSQL, No Peace 0 0 5
Performance Turning Leonard Mwangi, January 1, 0001 Am back to SQL Server performance turning after a year of a lot of things, as always I love sharing what I am doing to help someone in need and to create a point of reference to my work. Below is a SQL ... Performance Turning 0 0 0
Talked about SQL Azure at an Oracle Conference Herve Roggero, January 1, 0001 I have to admit, I was really excited to have the opportunity to talk about SQL Azure at an Oracle conference. Microsoft invited Scott Klein to COLLABORATE 11 (on 4/13/11), but at the last minute we switched ... Talked about SQL Azure at an Oracle Conference 0 0 0
MySql.Data.MySqlClient version mismatched Anirudha, January 1, 0001 UPDATED 28 December 2013 In this post I am writing how to fix the MySql.Data.MySqlClient issue when server doesn’t make call to same library with same version that is used in development server. Back in ... MySql.Data.MySqlClient version mismatched 0 0 1
Microsoft .NET Framework 4 Platform Update 1 - Runtime Update tiagomargalho, January 1, 0001 It seems that Microsoft has made available a runtime update for the .Net Framework 4.0 that allows a developer to create State Machine Workflows (event-driven workflows). This is great news for everyone ... Microsoft .NET Framework 4 Platform Update 1 - Runtime Update 0 0 0
Upcoming Speaking Schedule for 2011 Q2 Mike Huguet, January 1, 0001 I have stepped it up a notch and am speaking at numerous user groups and technical conferences in the South East in the coming months. These include .NET & SharePoint user groups as well as SQL Saturday ... Upcoming Speaking Schedule for 2011 Q2 0 0 0
Installing SharePoint 2010 on Windows 7 without killing kittens i... Enrique Lima, January 1, 0001 First, let me clarify the “killing kittens” statement. A couple of years back, I had a chance of attending a sessions presented by Todd Klindt and Shane Young on SharePoint Installation and to raise awareness ... Installing SharePoint 2010 on Windows 7 without killing kittens i... 0 0 3
Singapore .NET User Group - April UG Meeting Aman Garg, January 1, 0001 Singapore .NET User Group - April UG Meeting UG Meeting will be held on 18th April 2011 on next Monday, at Level 21 Auditorium from 1900hrs – late. Light refreshments will be served before the session. ... Singapore .NET User Group - April UG Meeting 0 0 1
Business Connectivity Services - Sharepoint 2010 Aman Garg, January 1, 0001 Business Connectivity Services is a new provided to what earlier existed as Business Data Catalogue in SharePoint. BCS adds a lot of new features and has been enhanced immensely now. BCS connects with ... Business Connectivity Services - Sharepoint 2010 0 0 2
ASP .NET Videos! powerusers, January 1, 0001 I have compiled some basic videos about the asic of ASP .NET from NETTUTS. Nettuts is blog from Envato which provide awesome stuff on Websites, Blog and much more. I hope you wouuld like these videos. ... ASP .NET Videos! 0 0 3
ADO.NET Entity Framework – Code First Development Pattern Lance Robinson, January 1, 0001 Here’s a quick start introduction to the ADO.NET Entity Framework Code First Development Pattern. For a more complete (but still intro) walkthrough, check out ScottGu’s blog. At the time of this writing, ... ADO.NET Entity Framework – Code First Development Pattern 0 0 0
BizTalk Server Configuration - BizTalk Group Creation Failure Stuart Brierley, January 1, 0001 I was recently installing a new BizTalk Server 2010 mult-server implementation, where the SQL server installation resides on a separate server to the BizTalk server installation(s) and I ran into a problem ... BizTalk Server Configuration - BizTalk Group Creation Failure 0 0 1
Two UK centric LinkedIn discussion groups you really should join Eric Nelson, January 1, 0001 If you are: Involved in developing software products (aka an Independent Software Vendor) or Considering a “move to the cloud” or both! Then you should consider joining one or both of these Microsoft UK ... Two UK centric LinkedIn discussion groups you really should join 0 0 0
A Monkey Talks about ASP.NET Vincent Maverick Durano, January 1, 0001 Last week, I was interviewed by Zandra Nilocas from Microsoft Philippines. It was my first time experience to talk about something in front of the camera so it's not surprising that I looked like an idiot ... A Monkey Talks about ASP.NET 0 0 0
Bullet Points from MIX11 Day 2 –WP7, Silverlight and Kinect... mbcrump, January 1, 0001 Since my blog is mainly about Silverlight, WPF and Windows Phone 7, I decided that I’d make a recap of today’s MIX 11 Event for those of you who missed it. I only included things that I thought were big ... Bullet Points from MIX11 Day 2 –WP7, Silverlight and Kinect... 0 0 1
Windows Phone 7 Announcements Recap from MIX11 Nikita Polyakov, January 1, 0001 I am very excited to help share this news with you today! I feel as excited today as I was when Windows Phone 7 developer story was revealed at MIX10 last year. I see so many more application scenarios ... Windows Phone 7 Announcements Recap from MIX11 0 0 0
Cycling Through Selected CTE Values Bunch, January 1, 0001 A great benefit of using a CTE is their ability to replace some uses of Cursors. Sometimes you may need a Cursor to fetch an ID value from a table. Use that ID in a Select statement. Then fetch the next ... Cycling Through Selected CTE Values 0 0 0
Another free tool to try - SQL Complete Express TATWORTH, January 1, 0001 At http://www.devart.com/dbfor... there is an intellisence ... Another free tool to try - SQL Complete Express 0 0 1
Philly Code Camp 2011.1 Soe Tun, January 1, 0001 Thanks to everyone who attended my session at Philly Code Camp 2011.1. It was a very fun and interactive session for me, and I hope it was an informative and helpful session for you as well. I apologize ... Philly Code Camp 2011.1 0 0 1
How-to Index for Windows Azure Tiago Salgado, January 1, 0001 How to: Build a Windows Azure Application How to Configure Virtual Machine Sizes How to Configure Connection Strings How to Configure Operating System Versions How to Configure Local Storage Resources ... How-to Index for Windows Azure 0 0 0
Silverlight Cream for April 05, 2011 -- #1071 Dave Campbell, January 1, 0001 In this Issue: Michael Crump, Jeremy Likness, Matthew Delisle, Xianzhong Zhu, Nigel Sampson, Jeff Prosise(-2-), Andrea Boschin, Mike Ormond, Jeff Wilcox, and Bil Simser. Above the Fold: Silverlight: "Silverlight ... Silverlight Cream for April 05, 2011 -- #1071 0 0 0
Color Code Your SSMS Windows With the SSMS Toolpack Jesse Taber, January 1, 0001 This blog post has moved:http://gruffcode.com/... ... Color Code Your SSMS Windows With the SSMS Toolpack 0 0 1
Man With a Mission - Welcome to myBlog! MikeHale, January 1, 0001 Fellow Techies of the world.. Welcome! In this obligatory first post I want to just tell you a little about myself and what I intend to do with this blog. I’ve worked in fits and starts on a tech blog ... Man With a Mission - Welcome to myBlog! 0 0 1
Adding id to combobox items Jim Lahman, January 1, 0001 First, create a class containing two members: value and id. Value is what is displayed in the combobox while id is associated with that value. I like to create a “global” class to contain properties and ... Adding id to combobox items 0 0 0
Firewall ports to open for SQL Server 2008 Jim Lahman, January 1, 0001 Open firewall ports as listed in http://msdn.microsoft.com/e... SQL Admin Connection- 1434 (TCP) SQL Debugger - 135 (TCP) SQL Service Broker - 4022 (TCP) SQL TCP Browser - 2382 (TCP) ... Firewall ports to open for SQL Server 2008 0 0 1
Using transactions to delete records from SQL Server Jim Lahman, January 1, 0001 Transactions are a great way to perform many actions but make it appear as one unit. Always start a transaction with BEGIN TRAN. Let's take a look at these statements: 1: BEGIN TRAN 2: DELETE SCHEDULES ... Using transactions to delete records from SQL Server 0 0 4
PL/SQL: get the id if a value exists in a look up table, insert a... robertphyatt, January 1, 0001 I ran into this one because I was working with some tables in a normalized database and I needed to quickly check to see if an id existed, and if it didn't, I needed to insert and then get the id. This ... PL/SQL: get the id if a value exists in a look up table, insert a... 0 0 2
Usage of Bitwise operator in SQL Server pankajsharma, January 1, 0001 This is my first post, so i am not sure how to proceed. I was very anxious to post something relevant to IT community but due to work loads or a thought that everything is available on net here or there ... Usage of Bitwise operator in SQL Server 0 0 4
Windows 7 or Windows Server 2008? juanlarios, January 1, 0001 I am in the proccess of putting together a demo machine. i arleady have a Windows 7 VM with the essentials for SharePoint Deveopment. But I spent some part of the weekend putting together a demo machine ... Windows 7 or Windows Server 2008? 0 0 0
Entity Framework - Editing, Updating and Deleting Data in the For... Vincent Maverick Durano, January 1, 0001 Previously we've talked about how to fetch the data from the database and populate the form with EF. In this example I'm going to demonstrate how to do Edit,Update and Delete operations in the form with ... Entity Framework - Editing, Updating and Deleting Data in the For... 0 0 3
Entity Framework - Fetching and Populating the Data in the Form Vincent Maverick Durano, January 1, 0001 In Part 1 we've talked about how to insert data to the database with Entity Framework. In this part I'm going to demonstrate how to fetch the data from the database and populate the form fields with Entity ... Entity Framework - Fetching and Populating the Data in the Form 0 0 9
Entity Framework - Inserting Data to Database Vincent Maverick Durano, January 1, 0001 Few months ago I wrote a series of articles regarding how to Insert, Update, Fetch and Delete data in the form using LINQ to SQL. You can view the series of articles below: Inserting Data to Database using ... Entity Framework - Inserting Data to Database 0 0 13
Choosing the right ORM saifkhan, January 1, 0001 Over the last few days I’ve been coding away with several ORMS and code generators trying to find me one which I am comfortable with. Here is what I learn Not all ORMs are perfect! SubSonic Telerik OpenAccess ... Choosing the right ORM 0 0 1
Row not found or changed jkrebsbach, January 1, 0001 I have a .Net 4.0 site that uses Entity Framework and Linq to SQL. After reworking a few tables and a few page operations, a new error appeared: "Row not found or changed". Every time I commit changes ... Row not found or changed 0 0 0
Store Procedure Debugging in VS2008 RoneeNoor, January 1, 0001 Debugging is cool. I mean what would have been happened to developers if they couldn’t debug their code!! Speaking of myself at some point I probably would’ve got pissed off and started to seek some other ... Store Procedure Debugging in VS2008 0 0 0
Allowing or blocking ip addresses with PHP and mySQL based off of... robertphyatt, January 1, 0001 Ok here is a cool trick I figured out that I hope will be helpful to someone: What if you wanted to block all the incoming ip addresses from a given country to a given site using only PHP and mySQL (without ... Allowing or blocking ip addresses with PHP and mySQL based off of... 0 0 0
Connecting an MVC project to an SQL database FranHoey, January 1, 0001 I'm just getting to grips with MVC linq etc etc and came across what looks like a common stumbling block. For the more experienced of you reading this please refrain from shouting "Dumbass" at me. All ... Connecting an MVC project to an SQL database 0 0 3
WP7 Training & Information Resources 2 russ61, January 1, 0001 (these are lifted verbatim from Microsoft here, here and here and are presented below only because it’s convenient to have them lumped altogether…) Getting Started with Windows Phone Windows Phone development ... WP7 Training & Information Resources 2 0 0 0
How to Import Negative Decimal or Floating Values to Flat File Wi... Compudicted, January 1, 0001 A question popped up not so long ago on the MSDN SSIS Forum from somebody struggling with a leading zero being dropped from the data being exported to a flat file to be returned back. The person asking ... How to Import Negative Decimal or Floating Values to Flat File Wi... 0 0 11
Producing and Consuming OData in a Silverlight and Windows Phone ... mbcrump, January 1, 0001 This article is Part 2 of the series “Producing and Consuming OData in a Silverlight and Windows Phone 7 application.” Producing and Consuming OData in a Silverlight and Windows Phone 7 application. (Part ... Producing and Consuming OData in a Silverlight and Windows Phone ... 0 0 0
Silverlight Cream for March 27, 2011 -- #1066 Dave Campbell, January 1, 0001 In this Issue: Michael Wolf, Colin Eberhardt, Kunal Chowdhury, Benjamin Roux, Nigel Sampson(-2-), Jeff Prosise(-2-), Jeremy Likness, and Beth Massi. Above the Fold: Silverlight: "Useful Value Converters" ... Silverlight Cream for March 27, 2011 -- #1066 0 0 0
Linq to SQL and Linq to SQL classes Tim Murphy, January 1, 0001 While I have been using Linq to Object for a couple of years now I had not investigated Linq to SQL up to this point. I figured I would put together my take on this technology’s use. Linq is a wonderful ... Linq to SQL and Linq to SQL classes 0 0 0
Encrpyt and decrypt a Stored Procedure Tiago Salgado, January 1, 0001 When we don't want to others have access to our Stored Procedures, Triggers or Views code, created on a database, you can create and encrypt easily, just by adding a "WITH ENCRYPTION". Here’s an example ... Encrpyt and decrypt a Stored Procedure 0 0 1
WPB .Net User Group March 2011 Meeting with Andy Warren Sam Abraham, January 1, 0001 Andy Warren (@sqlandy) , Microsoft MVP, was our March speaker at the West Palm Beach .Net User Group. Andy spoke about SQL Statistics and answered all our SQL questions. We appreciate Andy's long drive ... WPB .Net User Group March 2011 Meeting with Andy Warren 0 0 1
Using the Emergency State for a Corrupt SQL Server Database Akshay Deep Lamba, January 1, 0001 Problem I noticed a new feature that was first introduced in SQL Server 2005, which is the Emergency state for a database. It looks that it may facilitate dealing with a suspect database. How can I use ... Using the Emergency State for a Corrupt SQL Server Database 0 0 0
Connect to SSIS on Named Instance of SQL Server Humprey Cogay, C|EH, January 1, 0001 I am encountering this error on a freshly installed Named Instance SQL Server 2005 "Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The SQL Server specified in Integration Services ... Connect to SSIS on Named Instance of SQL Server 0 0 0