Winnipeg SQL Server UG November Event – Highlights from the... D'Arcy Lussier, January 1, 0001 November Event: Highlights from the PASS Summit Michael DeFehr, Protegra The annual summit for the Professional Association for SQL Server was held in Seattle in the first week of November. With over 160 ... Winnipeg SQL Server UG November Event – Highlights from the... 0 0 0
Make SQLExpress DB accessible from other computers Muljadi Budiman, January 1, 0001 When I started using SQLExpress 2005, everything works on my development machine – however when I wanted to access the database from another machine (trying to access the sqlexpress database remotely) ... Make SQLExpress DB accessible from other computers 0 0 0
Patterns: Abstract Factory Sanket Naik, January 1, 0001 Intent Provide interface for creating families of related or dependent classes without specifying there concrete classes. Scenario: I have been wondering about a valid scenario where I would put the Abstract ... Patterns: Abstract Factory 0 0 1
LINQ to SQL Again?? Steve Michelotti, January 1, 0001 Tomorrow night I’ll be at RockNUG presenting LINQ to SQL. Yes, LINQ to SQL. Again. In the last 2 years I have presented LINQ to SQL numerous times at various user groups and code camps. Why do I keep getting ... LINQ to SQL Again?? 0 0 4
SQL Server Modeling (a.k.a Oslo) Update microsoftian, January 1, 0001 I am talking about the sixth item from my earlier post In a nutshell... Oslo initiative (Microsoft Modeling Platform for 10x development productivity) took several directions and finally ended up being ... SQL Server Modeling (a.k.a Oslo) Update 0 0 0
Installing a second hard drive on my HP 6910p – one step closer t... Liam Westley, January 1, 0001 I’ve previously described my reasoning for buying a business laptop like the HP 6910p, http://geekswithblogs.net/t... I’m now feeling even better about that decision ... Installing a second hard drive on my HP 6910p – one step closer t... 0 0 12
BizTalk 2004 Server Connection Issues - MSDTC Stuart Brierley, January 1, 0001 Overview There is sometimes an issue on the BizTalk Server, often following an operation such as an operating systems service pack installation, where the MSDTC settings can be reset from those that BizTalk ... BizTalk 2004 Server Connection Issues - MSDTC 0 0 2
Writing custom MembershipProvider Lukasz Kurylo, January 1, 0001 This text is based on the Chris Pels video and code located here. ASP.NET Membership mechanism allows to use the build-in server tables to store and retrieve user data. By default, this mechanism can only ... Writing custom MembershipProvider 0 0 0
SQL Server Event Michael Stephenson, January 1, 0001 Thought this may be of interest to some SBUG Members as they will be discussing SQL Server 2008 R2 and SQL Azure at the Edge UG http://edgeug.net/ ... SQL Server Event 0 0 5
ReSharper is not available Marko Apfel, January 1, 0001 Today a colleague ask me to help. On his system all ReSharper menus are grayed out. Also the Visual Studio Add-In Manager does not show this add-in. He tried: a new installation: without success, running ... ReSharper is not available 0 0 0
SQL Azure - Auditing Choices Herve Roggero, January 1, 0001 As I am digging more into SQL Azure, it seems choices for auditing will become a little bit more restricted. Generally speaking there are four ways to audit SQL Server statements; these mechanisms are ... SQL Azure - Auditing Choices 0 0 0
SQL Server 2005 Zugriffsproblem bei Remotezugriff Marko Apfel, January 1, 0001 Wenn ein Remote-Zugriff auf einen SQL Server 2005 mit der Fehlermeldung "A connection was successfully established with the server, but then an error occurred during the pre-login handshake.When connecting ... SQL Server 2005 Zugriffsproblem bei Remotezugriff 0 0 0
Error: The database server you specified cannot be reached .. Marko Apfel, January 1, 0001 Beim Installieren des Enterprise Single Sign-On Dienstes kommt folgende Fehlermeldung: The database server you specified cannot be reached. Make sure you have specified the correct server name and that ... Error: The database server you specified cannot be reached .. 0 0 0
Verwenden von Pivotal XDR Schema in BizTalk Server 2006 Marko Apfel, January 1, 0001 Pivotal erzeugt mittels GenerateSchema.ASP für die Integration Adapter ein XDR-Schema. Dieses Schema ließ sich unter BizTalk Server 2002 auch anstandslos importieren und weiterverwenden. Der BizTalk Server ... Verwenden von Pivotal XDR Schema in BizTalk Server 2006 0 0 0
Error: EXECUTE permission denied on object 'sp_sdidebug' Marko Apfel, January 1, 0001 Beim Debugging wird der Fehler: "EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'." geworfen. Komplette Fehlermeldung: [System.Data.SqlClient.SqlE... = {"EXECUTE ... Error: EXECUTE permission denied on object 'sp_sdidebug' 0 0 0
Sproc Executing Slow? It Might be This Robz / Fervent Coder, January 1, 0001 So you have stored procedure and it’s having issues. When you run it, it returns really fast. When .NET runs it, its like a dog. The first thing you learn about SQL Server is that it has something called ... Sproc Executing Slow? It Might be This 0 0 7
Summary of the Entity Framework 4 changes introduced with Beta 2 ... Eric Nelson, January 1, 0001 I thought it would be useful (at least to me!) to summarise the new stuff in Entity Framework 4 given it actually comes in 2 parts. The list is a simplified and categorised version of this and this. General ... Summary of the Entity Framework 4 changes introduced with Beta 2 ... 0 0 0
Entity Framework 4 Session DEV305 at TechEd Europe 2009 – w... Eric Nelson, January 1, 0001 Next Monday (9th Nov 2009) at 9am I will be delivering an overview of the new stuff in Entity Framework 4 at TechEd Europe. The session is DEV305 and the description reads: ADO.NET Entity Framework in ... Entity Framework 4 Session DEV305 at TechEd Europe 2009 – w... 0 0 0
Finding Duplicates in a Table Bunch, January 1, 0001 Here is an easy way to find duplicate data in a table. This simple example would return any userNames that appear twice or more in the table. SELECT userName, COUNT(userName) as UserDup FROM tblUsers GROUP ... Finding Duplicates in a Table 0 0 0
Avoiding TNSNAMES in Oracle .NET data connections EltonStoneman, January 1, 0001 Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; ... Avoiding TNSNAMES in Oracle .NET data connections 0 0 40
SQL Azure shows promise for small data applications - not there f... James Rogers, January 1, 0001 I am currently sitting in a seminar on BI in the Cloud by John Welch at the PASS Summit 2009. SQL Server Azure looks promising for a variety of applications. Currently it only supports SQL Server relational ... SQL Azure shows promise for small data applications - not there f... 0 0 1
SQL Azure Connection error “Cannot connect to <servernam... Harish Ranganathan, January 1, 0001 If you have been using the SQL Azure Portal for creating SQL Databases and connecting to them from your SQL Server Management Studio, you would have realized the ability to query the Azure Cloud Databases ... SQL Azure Connection error “Cannot connect to <servernam... 0 0 2
downloadable book released: SharePoint guidance for SQL Server da... John Alexander, January 1, 0001 I stumbled across a recently released collection of guidance and best practices for SharePoint DBAs and those who love them. From the download page… “ This book is a guide for database administrators who ... downloadable book released: SharePoint guidance for SQL Server da... 0 0 1
Silverlight Cream for November 03, 2009 - 2 -- #724 Dave Campbell, January 1, 0001 In this Issue: Damian Schenkelman, Jonathan van de Veen, Stephen Forte, Laurent Duveau(2), Alan Mendelevich, and nmarun. From SilverlightCream.com: Why Silverlight 3 Navigation cannot be fully leveraged ... Silverlight Cream for November 03, 2009 - 2 -- #724 0 0 0
SharePoint ALCM: A real world example Kelly Jones, January 1, 0001 For the past year, I’ve been working with a client that is in a very unusual position, at least one that has been rare in my career. My client is an established business being spun off from their corporate ... SharePoint ALCM: A real world example 0 0 1
How time flies! Bill Jones Jr., January 1, 0001 How time flies! Monthly Guild meetings, several code camps, an MVP Summit and oh yeah, that mobility app we did at work. We consumed 2008 and much of 2009 working with Microsoft on a serious development ... How time flies! 0 0 2
Which ORM? LINQ To SQL, Entity Framework? LLBLGen? NHibernate?…? Mohamed Meligy, January 1, 0001 While I was planning to write about the same topic and have the draft ready in my Windows Live Writer waiting to complete, I found an interesting question in StackOVerflow and couldn’t just resist to answer: ... Which ORM? LINQ To SQL, Entity Framework? LLBLGen? NHibernate?…? 0 0 0
CRUD operations using LINQ Han Cheng, January 1, 0001 I will use the AdventureWorks database to demonstrate how to perform CRUD operations using LINQ. You can use LINQPad (a free tool) to execute your C# statements without going through the hassle of writing ... CRUD operations using LINQ 0 0 2
Come see me at the Richmond Code Camp! , January 1, 0001 I will be speaking at the Richmond Code Camp in Richmond, VA on Oct 3, 2009. My topic will be "Examining Linq2Sql & Entity Framework." It will start with a brief history of ORM and then do a walkthrough ... Come see me at the Richmond Code Camp! 0 0 0
Code Download For "Examining Linq2Sql & the Entity Framework" fro... danemorgridge, January 1, 0001 Last Thursday I presented a talk titled "Examining Linq2Sql & the Entity Framework" at the PhillyXAML meeting. As promised here is the code download. There are 2 Visual Studio projects, one for Linq2Sql ... Code Download For "Examining Linq2Sql & the Entity Framework" fro... 0 0 0
I'm speaking at CMAP Code Camp on Nov 7 , January 1, 0001 I am speaking at the Central Maryland Association of .NET Professionals Code Camp on November 7th. I'll be doing 2 sessions: Getting to know the Entity Framework There are quite a few choices when it comes ... I'm speaking at CMAP Code Camp on Nov 7 0 0 0
Using Visual Studio 2010 Beta 2 to do Entity Framework Model Firs... Dane Morgridge, January 1, 0001 I was at first a little skeptical about the Entity Framework Model First development in Visual Studio 2010 beta 2. I was a little worried that the database that was generated wouldn't be something I would ... Using Visual Studio 2010 Beta 2 to do Entity Framework Model Firs... 0 0 5
Wanted: Killer apps! Reward: $12,000 prize! Chris Williams, January 1, 0001 Wanted: Killer apps! Reward: $12,000 prize! Spread the word—there’s a contest for developers blazing trails with the .NET Framework and Visual Studio, Windows, Windows Server, Windows Azure, SQL Server, ... Wanted: Killer apps! Reward: $12,000 prize! 0 0 1
A BI Star is Born: PowerPivot Will Receive Immediate Multi-Vendor... andrewbrust, January 1, 0001 PowerPivot is the newly announced name for Microsoft’s (not yet released) self-service analytics product, formerly code-named “Gemini.” PowerPivot brings the power of OLAP analytics to end-users, by allowing ... A BI Star is Born: PowerPivot Will Receive Immediate Multi-Vendor... 0 0 1
Nested GridViews in .NET 2.0 , January 1, 0001 v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 ... Nested GridViews in .NET 2.0 0 0 0
Converting ASP.NET DataTable to JSON using JayRock , January 1, 0001 Beginners using jQuery plugins and jQuery AJAX with ASP.NET get stuck with one common problem-converting datatable to JSON. This conversion is necessary since JSON can be easily parsed in JavaScript and ... Converting ASP.NET DataTable to JSON using JayRock 0 0 11
Installing Team Build 2010 Beta2 Dylan Smith, January 1, 0001 I just went through the process of creating a VHD for use by myself and some other members on my team. I had a pre-built base image with Windows Server 2008 and SQL Server 2008 Enterprise that I used to ... Installing Team Build 2010 Beta2 0 0 0
ACT NOW!!! Atlanta Incubation Week (Nov 9th-13th) Murray Gordon, January 1, 0001 With several successful Microsoft BizSpark Incubation Weeks (Win7 Boston, Win7 Reston, CRM Reston, CRM Boston, Win 7 Irvine, Mobility Mountain View,), we are pleased to announce Microsoft BizSpark Incubation ... ACT NOW!!! Atlanta Incubation Week (Nov 9th-13th) 0 0 1
Linq to Sql ORM Designer - System.InvalidOperationException: Inco... robertbunn, January 1, 0001 Today I got the following error when working with the Linq to Sql dbml file: "System.InvalidOperationExc... Incorrect AutoSync specification for member 'xxxxx'." The problem involved the primary key ... Linq to Sql ORM Designer - System.InvalidOperationException: Inco... 0 0 2
Oracle Update with Join – Revisited Will Smith, January 1, 0001 I’ve had a lot of feedback on my Oracle Update with Join post. The most common problem people have encountered with this approach is the dreaded “SQL Error: ORA-01779: cannot modify a column which maps ... Oracle Update with Join – Revisited 0 0 6
SharePoint as BI and Data Platform andrewbrust, January 1, 0001 Day 2 of the SharePoint Conference has just about come and gone, and I’ve shifted my focus from yesterday’s pure developer angle to topics of data and business intelligence. And there has been a lot to ... SharePoint as BI and Data Platform 0 0 0
Installing Visual Studio 2010 Team Foundation Server on Windows V... Martin Hinshelwood, January 1, 0001 *Moved to: Installing Visual Studio 2010 Team Foundation Server on Windows Vista in 3 minutesNew in Visual Studio 2010 is the ability to install TFS on XP, Vista and Windows 7. You can use SQL 2008 Express, ... Installing Visual Studio 2010 Team Foundation Server on Windows V... 0 0 18
Winnipeg SQL Server UG October Event D'Arcy Lussier, January 1, 0001 October Event: Continuing T-SQL Development: Bullet-Dodging and Spoon-Bending Part 2 Michael DeFehr, Protegra Michael DeFehr continues his series on T-SQL development for the second Winnipeg SQL Server ... Winnipeg SQL Server UG October Event 0 0 0
Hello & Good BI GoodBISQLServer, January 1, 0001 Well finally I am dedicating myself (again) to starting up a blog about good practices in Business Intelligence using SQL Server 2005 & 2008. So just to prove to myself that this isn’t a fad I’ve downloaded ... Hello & Good BI 0 0 0
SQL Server xml data type - gaining popularity? ScottKlein, January 1, 0001 I spoke last weekend at the Orlando SQL Saturday on the topic of SQL Server and the xml data type. I was somewhat concerned that my session would draw little attendees for several reasons. First, my session ... SQL Server xml data type - gaining popularity? 0 0 1
Windows Azure Platform “free” for MSDN Subscribers an... Eric Nelson, January 1, 0001 Well not exactly free but definitely extremely welcome and a great benefit. The introductory offer includes a huge 750 hours of compute time – which rather nicely is how much you need to run a node 24x7 ... Windows Azure Platform “free” for MSDN Subscribers an... 0 0 0
Visual Studio 2010 and .NET Framework 4 Beta 2 now available &nda... Eric Nelson, January 1, 0001 I am not the biggest fan of Mondays but today is different. Today is a good day. Today we announced the availability of Beta 2 of Visual Studio 2010 and revealed the official launch date: Visual Studio ... Visual Studio 2010 and .NET Framework 4 Beta 2 now available &nda... 0 0 1
Sync Framework Common Practise of ADO.NET argot, January 1, 0001 I have been working on database synchronization for a couple of weeks, and seems it at the final testing stage, I am using Microsoft Sync Framework 2.0, the DB server is SQL server 2008 Standard, and clients ... Sync Framework Common Practise of ADO.NET 0 0 9
Getting Ready to Share andrewbrust, January 1, 0001 This is my 100th post to this blog, but it’s also, in a real sense, my first. That’s because, starting now, my blog will be syndicated on RedDevNews.com and VisualStudioMagazine.com, the same sites that ... Getting Ready to Share 0 0 0
Why is “Legacy” a Pejorative? Jeff Certain, January 1, 0001 I had the tremendous privilege in the last couple days to spend time with a bunch of architects at ITARC in NYC. I’m still trying to wrap my head around it all… but that’s always the result when I spend ... Why is “Legacy” a Pejorative? 0 0 0