Rollback in Oracle and SQL Server CatherineRussell, January 1, 0001 I have an Oracle background. It was interesting to see how rollback handled in Oracle and SQL Server. There is no begin trans in Oracle. What oracle does is it will store the data in a temporary area called ... Rollback in Oracle and SQL Server 0 0 0
Session state has been disabled for ASP.NET.The Report Viewer con... Patrick Olurotimi Ige, January 1, 0001 While i was trying to setup some reports on a SPF 2010 site. After trying to add a Sql Reporting Webpart i get the error: Session state has been disabled for ASP.NET. The Report Viewer control requires ... Session state has been disabled for ASP.NET.The Report Viewer con... 0 0 13
2 min video about the SQL_Compare CatherineRussell, January 1, 0001 It is nice to start blogging again! I am working on new project in a small company now. We do not have a full time database admin. I have to cover multiple roles: getting requirements, writing docs and ... 2 min video about the SQL_Compare 0 0 0
SQL Server 2008 Remote Access GGBlogger, January 1, 0001 I've spent what seems like weeks attempting to set up remote access for SQL Server 2008. Up to recently my database access was alway against a local instance but I now have two servers and I want to work ... SQL Server 2008 Remote Access 0 0 3
SQL Server Date Comparison Functions HighAltitudeCoder, January 1, 0001 A few months ago, I found myself working with a repetitive cursor that looped until the data had been manipulated enough times that it was finally correct. The cursor was heavily dependent upon dates, ... SQL Server Date Comparison Functions 0 0 0
How to create a new Team Project Collection in TFS2010 jehan, January 1, 0001 Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; ... How to create a new Team Project Collection in TFS2010 0 0 3
MDX using EXISTING, AGGREGATE, CROSSJOIN and WHERE James Rogers, January 1, 0001 It is a well-published approach to using the EXISTING function to decode AGGREGATE members and nested sub-query filters. Mosha wrote a good blog on it here and a more recent one here. The use of EXISTING ... MDX using EXISTING, AGGREGATE, CROSSJOIN and WHERE 0 0 3
RoundhousE now supports Oracle, SQL2000 Robz / Fervent Coder, January 1, 0001 RoundhousE, the database migration software that is based on sql scripts has added support for Oracle and SQL 2000. There have also been numerous other little things, including better logging and a script ... RoundhousE now supports Oracle, SQL2000 0 0 0
AppFabric – where are all the monitoring events? Shawn Cicoria, January 1, 0001 When you’ve just gone through a setup of AppFabric and you’ve got some WF/WCF things happening, if you start looking at the Dashboard and you see nothing, it might be as simple as restarting SQL Agent. ... AppFabric – where are all the monitoring events? 0 0 0
FILESTREAM in SQL Server 2008 R2 CatherineRussell, January 1, 0001 Much data is unstructured, such as text documents, images, and videos. This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management ... FILESTREAM in SQL Server 2008 R2 0 0 0
Introducing Microsoft SQL Server 2008 R2 CatherineRussell, January 1, 0001 I was thrilled to find a free ebook: Introducing Microsoft SQL Server 2008 R2,by Ross Mistry and Stacia Misner The purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both the new and the ... Introducing Microsoft SQL Server 2008 R2 0 0 0
BizTalk 2009 - The Community ODBC Adapter: Schema Generation with... Stuart Brierley, January 1, 0001 As previsouly noted in my post on Schema Generation using the Community ODBC Adapter, I ran into a problem when trying to generate a schema to represent a MySQL stored procedure that had input parameters. ... BizTalk 2009 - The Community ODBC Adapter: Schema Generation with... 0 0 5
BizTalk 2009 - The Community ODBC Adapter: Receive Location Stuart Brierley, January 1, 0001 I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas. But what about creating a receive location? An ODBC receive location will ... BizTalk 2009 - The Community ODBC Adapter: Receive Location 0 0 3
BizTalk 2009 - The Community ODBC Adapter: Schema Generation Stuart Brierley, January 1, 0001 Having previously detailed the installation of the Community ODBC Adapter for BizTalk 2009, the next thing I will be looking at is the generation of schemas using this ODBC adapter. Within your BizTalk ... BizTalk 2009 - The Community ODBC Adapter: Schema Generation 0 0 2
BizTalk 2009 - The Community ODBC Adapter: Installation Stuart Brierley, January 1, 0001 I have previsouly detailed the installation of MySQL, the configuration of MySQL and the installation of the ODBC Data Connector for MySQL. The reason I needed to install and configure these servers was ... BizTalk 2009 - The Community ODBC Adapter: Installation 0 0 5
Iron Speed Designer 7.0 - the great gets greater! GGBlogger, January 1, 0001 For Immediate Release Iron Speed, Inc. Kelly Fisher +1 (408) 228-3436 kfisher@ironspeed.com http://www.ironspeed.com Iron Speed Version 7.0 Generates SharePoint Applications New! Support for Microsoft ... Iron Speed Designer 7.0 - the great gets greater! 0 0 0
SQL Azure Roadmap gets a little clearer – announcements fro... Eric Nelson, January 1, 0001 On Monday at Tech▪Ed 2010 we announced new stuff (I like new stuff) that “showcases our continued commitment to deliver value, flexibility and control of data through data cloud services to our customers”. ... SQL Azure Roadmap gets a little clearer – announcements fro... 0 0 2
PrairieDevCon – Slide Decks Dylan Smith, January 1, 0001 PrairieDevCon 2010 was an awesome time. Learned a lot, and had some amazing conversations. You guys even managed to convince me that NoSQL databases might actually be useful after all. For those interested ... PrairieDevCon – Slide Decks 0 0 0
MySQL - ODBC Data Connector Stuart Brierley, January 1, 0001 Having previsouly installed and then configured MySQL, you may now need to install the ODBC Data Connector driver in order to connect to your MySQL database. Following the Splash screen the first thing ... MySQL - ODBC Data Connector 0 0 0
Q&A: Will my favourite ORM Foo work with SQL Azure? Eric Nelson, January 1, 0001 short answer: Quite probably, as SQL Azure is very similar to SQL Server longer answer: Object Relational Mappers (ORMs) that work with SQL Server are likely but not guaranteed to work with SQL Azure. ... Q&A: Will my favourite ORM Foo work with SQL Azure? 0 0 0
Declaring variables in SQL Tim Hibbard, January 1, 0001 I would like to blog more about the problems I encounter on a daily basis. I find that taking 10 minutes or so to write a simple solution to my problems helps me retain that information. I always forget ... Declaring variables in SQL 0 0 1
MySQL - Configuration Stuart Brierley, January 1, 0001 Having previously detailed how to install MySQL Server, the next step is configuring MySQL. The MySQL configuration wizard can either be run immediately following installation from the MySQL installation ... MySQL - Configuration 0 0 1
SQL Server Split() Function HighAltitudeCoder, January 1, 0001 Diversify Your Database! Ever wanted a dbo.Split() function, but not had the time to debug it completely? Let me guess - you are probably working on a stored procedure with 50 or more parameters; two or ... SQL Server Split() Function 0 0 0
How’s your Momma an’ them? Bill Jones Jr., January 1, 0001 When a Southern “boy” like me sees somebody that used to be, or should be, a close friend or relative that they haven’t seen in a long time, that’s a typical greeting. Come to think of it, we were often ... How’s your Momma an’ them? 0 0 6
The backup set holds a backup of a database other than the existi... Shravan, January 1, 0001 Fewdays back i took the backup of my development server, I am trying to restore it in my own system. I am getting the following error. The backup set holds a backup of a database other than the existing ... The backup set holds a backup of a database other than the existi... 0 0 0
MySQL - Installation Stuart Brierley, January 1, 0001 In order to create a development environment for a project I am working on, I recently needed to install MySQL Server. The first step was to download the msi. Running this presents you with the installer ... MySQL - Installation 0 0 0
Use Expressions with LINQ to Entities EltonStoneman, January 1, 0001 [Source: http://geekswithblogs.net/E... Recently I've been putting together a generic approach for paging the response from a WCF service. Paging changes the service signature, so it's not as ... Use Expressions with LINQ to Entities 0 0 15
WWDC and Tech Ed: A Tale of Two DevCons andrewbrust, January 1, 0001 Next week marks the first full week of June. Summer will feel in full swing and it will be a pretty big season for technology. In seeming acknowledgement of that very fact, both Apple and Microsoft will ... WWDC and Tech Ed: A Tale of Two DevCons 0 0 1
Random MongoDb Syntax: Updates Liam McLennan, January 1, 0001 I have a MongoDb collection called tweets. Each document has a property system_classification. If the value of system_classification is ‘+’ I want to change it to ‘positive’. For a regular relational database ... Random MongoDb Syntax: Updates 0 0 0
Performing a clean database creation using msbuild Robert May, January 1, 0001 So I’m taking a break from writing about other Agile stuff for a post. :) I’m still going to get back to the other subjects, but this is fun too. Something I’ve done quite a bit of is MSBuild and CI work. ... Performing a clean database creation using msbuild 0 0 1
What's New in ASP.NET 4 Navaneeth, January 1, 0001 The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved ... What's New in ASP.NET 4 0 0 1
First Shard for SQL Azure and SQL Server Herve Roggero, January 1, 0001 That's it!!!!! It's ready to go and be tested, abused and improved! It requires .NET 4.0 and uses some cool technologies, like caching (the new System.Runtime.Caching) and the Task Parallel Library (System.Threading.Tasks). ... First Shard for SQL Azure and SQL Server 0 0 0
mongoDB Management Studio Liam McLennan, January 1, 0001 This weekend I have been in Sydney at the MS Web Camp, learning about web application development. At the end of the first day we came up with application ideas and pitched them. My idea was to build a ... mongoDB Management Studio 0 0 4
SQL Server Connectivity Portal Enrique Lima, January 1, 0001 We all love one stop portals :-) Browsing around MSDN I came across this for connectivity, yes, a one stop portal, find info on connecting using a variety of technologies and good guides. http://msdn.microsoft.com/e... ... SQL Server Connectivity Portal 0 0 0
SQL Azure: Notes on Building a Shard Technology Herve Roggero, January 1, 0001 In Chapter 10 of the book on SQL Azure (http://www.apress.com/book... I am co-authoring, I am digging deeper in what it takes to write a Shard. It's actually a pretty cool exercise, and ... SQL Azure: Notes on Building a Shard Technology 0 0 0
SQL Saturday 40 - South Florida - July 31st 2010 Herve Roggero, January 1, 0001 Hi everyone - if you live in Florida, or if you will be in the area on July 31st come and see us! If would like to speak or attend, visit http://www.sqlsaturday.com/... The event will be ... SQL Saturday 40 - South Florida - July 31st 2010 0 0 0
Better than dynamic SQL - How to pass a list of comma separated I... Rodney Vinyard, January 1, 0001 Better than dynamic SQL - How to pass a list of comma separated IDs into a stored proc: Derived form "Method 6" from a great article: · How to pass a list of values or array to SQL Server stored procedure ... Better than dynamic SQL - How to pass a list of comma separated I... 0 0 2
Building the Ultimate SharePoint 2010 Development Environment Manesh Karunakaran, January 1, 0001 It’s been more than a month since SharePoint 2010 RTMed. And a lot of people have downloaded and set up their very own SharePoint 2010 development rigs. And quite a few people have written blogs about ... Building the Ultimate SharePoint 2010 Development Environment 0 0 17
Great opportunity to try Windows Azure over the next 7 days if yo... Eric Nelson, January 1, 0001 Are you a UK based developer who has been put off from trying out the Windows Azure Platform? Were you concerned that you needed to hand over credit card details even to use the introductory offer? Or ... Great opportunity to try Windows Azure over the next 7 days if yo... 0 0 1
Q&A: Can you develop for the Windows Azure Platform using Win... Eric Nelson, January 1, 0001 This question has come up several times recently as we take several hundred UK developers through 6 Weeks of Windows Azure training (sorry – we are full). Short answer: In the main, yes Longer answer: ... Q&A: Can you develop for the Windows Azure Platform using Win... 0 0 1
Install of AppFabric RC stops AppFabric Monitoring (some traps fo... Rob Addis, January 1, 0001 I uninstalled AppFabric Beta 2 and installed AppFabric RC. The AppFabricEventCollection Service is started (runs under Local Service which is a dbo_owner on the Monitoring Database to prove this wasn’t ... Install of AppFabric RC stops AppFabric Monitoring (some traps fo... 0 0 1
SharePoint 2010 and SQL Server 2008 R2 Enrique Lima, January 1, 0001 Recently participated in a conversation that asked about what thoughts were around the advantages of SharePoint 2010 and SQL Server 2008 R2. I guess we can really dive in by exploring a document on TechNet ... SharePoint 2010 and SQL Server 2008 R2 0 0 0
Silverlight Cream for May 25, 2010 - 2 -- #870 Dave Campbell, January 1, 0001 In this Issue: Kirupa, Matthias Shapiro(-2-, -3-), Giorgetti Alessandro, Kunal Chowdhury, Mike Snow, and Jason Zander. Shoutout: This looks like a really nice WP7 app done by a team of folks for Imagine ... Silverlight Cream for May 25, 2010 - 2 -- #870 0 0 0
Tools and Utilities for the .NET Developer mbcrump, January 1, 0001 You can reach this page anytime at http://tools.michaelcrump.net Thanks to everyone that has contributed so far, we are getting several thousands hits from all sorts of developers a day. Recent Contributors ... Tools and Utilities for the .NET Developer 0 0 26
TFS 2010 Basic Concepts jehan, January 1, 0001 Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; ... TFS 2010 Basic Concepts 0 0 5
Copying files from GAC using xcopy or Windows Explorer Rohit Gupta, January 1, 0001 use this command for copying files using a wildcard from the GAC to a local folder. xcopy c:\windows\assembly\Microso... c:\gacdll /s/r/y/c The above command will continue even it encounters ... Copying files from GAC using xcopy or Windows Explorer 0 0 0
SyncToBlog #12 Windows Azure and Cloud Links Eric Nelson, January 1, 0001 Some more “syncing to paper” :) Steve Marx wrote a very interesting article about using Hosted Web Core in an Azure Worker Role. Hosted Web Core is a new feature in IIS 7 that enables developers to create ... SyncToBlog #12 Windows Azure and Cloud Links 0 0 0
Performing an upgrade from TFS 2008 to TFS 2010 Enrique Lima, January 1, 0001 I recently had to go through the process of migrating a TFS 2008 SP1 to a TFS 2010 environment. I will go into the details of the tasks that I went through, but first I want to explain why I define it ... Performing an upgrade from TFS 2008 to TFS 2010 0 0 0
ASP.NET MVC Application In Action - I (DailyJournal) Rajesh Pillai, January 1, 0001 Its been long due I was planning to write an article on creating some useful ASP.NET MVC application. I have code named it "DailyJournal". Its a simple application which allows creation of multiple activities ... ASP.NET MVC Application In Action - I (DailyJournal) 0 0 0
SQL Concatenate Bunch, January 1, 0001 Concatenating output from a SELECT statement is a pretty basic thing to do in SQL. The main ways to perform this would be to use either the CONCAT() function, the || operator or the + operator. It really ... SQL Concatenate 0 0 1