Tag | SQL Posts

Video Link - http://channel9.msdn.com/po... At PDC this year, our team spoke to Glenn Berry of NewsGator Technologies, an RSS platform company, about their work with Microsoft development technologies. This is a great video about Sharepoint, Silverlight and SQL 2008, shot by Warren Wilbee. Definitely worth checking out. Thanks for checking out this post! Cheers, Murray Gordon ISV Architect Evangelist Microsoft Corporation My Blog @ MSDN My Blog @ GeeksWithBlogs ...
There was a thread last year on the SSAS MSDN forum SSAS 2008 -- Why is metadata so slow??? in relation to slow metadata queries on a cube with 250+ measure groups. The good news is that despite the fact that the SSAS team has largely been focussed on PowerPivot for the SQL Server 2008 R2 release, they have also tried to address a few of the customer pain points in SSAS. Below is part of a recent response to this thread from Akshai Mirchandani from the SSAS development team: "As an update to this ...
Below are the some interesting t-sql enhancements in sql 2008 posted in the web... http://www.sqlservercentral... http://www.sqlservercentral... http://www.sqlservercentral... http://www.sqlservercentral... http://www.sqlservercentral... ...
As part of Microsoft UKs Azure Awareness Week in February (2010) we have three training workshops for partners taking place. I have added them over on the new Fans of UK Azure community site. Don’t delay – I expect the places to vanish quickly! February 23 Tuesday Reading Free One day Accelerated Training Workshop for Partners February 24 Wednesday Reading Free One day Accelerated Training Workshop for Partners February 25 Thursday Edinburgh Free One day Accelerated Training Workshop for Partners ...
Had a strange error come up today when I tried to use my home PC to run an Entity Framework project, the EDMX schema (is it a schema) was generated in SQL Server 2008 and my home dev machine has SQL Server 2005. I wouldn't have thought this would be a problem as I don't use any 2008 specific features (except the intellisense ;P), but alas I was getting a lot of exceptions from my FunctionImports (stored proceedures in Entity Framework). Upon investigating the stack trace it was telling me that the ...
[Source: http://geekswithblogs.net/a... I recently had the pleasure of installing and configuring the ESB Toolkit 2.0 in a multi-server environment. There are some notes on how to do this in the official documentation but they’re not exhaustive and they don’t include details on how to install the management portal in a multi-server environment. Prerequisites: · Install and Configure BizTalk in your multi-server environment · Install and Configure UDDI in your multi-server ...
I wrote this short article for the 27th of January edition of the UK MSDN Flash newsletter. I thought it would be useful to sneak it in here as well especially as it will be the basis of a number of upcoming blog posts – probably about seven of them :-) Seven things that may surprise you about the Windows Azure Platform January 2010 is when the Windows Azure Platform for Cloud Computing moved from beta to live. We have three services live and already serving applications developed in the UK: · Windows ...
After the second installment of our Speaker Idol format, I was asked by INETA to write an article for the January newsletter targeting other user group leaders. It came out great. The article describes the event format and some of our lessons learned. You can view the article at http://ineta.org/newsletter... There is a lovely mug shot. That serves me right for not having a more professional picture ready and had to get someone to take a picture in the office with ...
Microsoft Previews Tool to Ease Migration from MySQL to SQL Server Microsoft has released a new preview version of a tool that enables users of the MySQL database to migrate to Microsoft's SQL Server. On Jan. 11, Microsoft released a Community Technology Preview (CTP) of the Microsoft SQL Server Migration Assistant (SSMA) for MySQL toolkit. This tool dramatically cuts the effort, cost and risk of migrating to SQL Server. A new addition to the SSMA family is the CTP version 1.0 for MySQL that provides ...

Here is the code you need to start adding parameters to your sql commands:

Add parameter then add value:

Dim cmd As SqlCommand = New SqlCommand(s,c)
cmd.Parameters.Add("@id", SqlDbType.Int)
cmd.Parameters("@id").Value = foo

or

Add parameter with value:

command.Parameters.AddWithValue("@id", foo)

There have been many times that I’ve been handed a SQL instance that doesn’t allow me to do much with it even though the IT Admin for the machine have indicated they’ve done the install and your AD account is part of the Local Admin group. By default, in SQL 2008 local admin’s are not part of the sysadmin role – unless you’re running in single user mode. So, this article has a quick HOWTO on getting access back so you can go on your merry sysadmin way… http://technet.microsoft.co... ...
To start developing reports for SQL Server reporting service (SSRS) , you need first to install the tool, they don't come with Visual studio , in fact they are a part of SQL server. If you don't have SQL server installed on your machine, go and install SQL server, and in the features choose "SQL Server Reporting Services". If you had it on the machine, use add/remove and add it form the features N.B. you don't need to run the SSRS Service while developing it's only required if you are deploying the ...
Well this morning I've been trying to mirror the office's development environment onto an offline laptop. Correct me if I am wrong, but version ".0.30729.1 SP" includes the service pack 1 update (dont get me started on the mission of creating a full version of the installer/downloader to run offline) . So when I try to setup a new SQL Server 2008 instance why do I fail the test "Previous releases of Microsoft Visual Studio 2008" ... Most support web sites suggest re-installing SP1, which I have done ...
Yesterday, Microsoft announced that the official release timeframe for SQL Server 2008 R2 would be May of this year. Since a huge proportion of the features new to SQL 2008 R2 are Business Intelligence-related, Microsoft BI users and professionals should be very happy. Ostensibly, Office 2010 and SharePoint 2010 will be released concurrently with R2, or very close to it, and the MS BI stack will get its most important refresh in quite a long time. Reporting Services will have important new data visualization ...
We are now accepting speakers / presentations for Roanoke Code Camp 2010 (western Virginia) being held on Saturday, March 13th at Virginia Western Community College. If you have presented at a past Roanoke Code Camp -- welcome back! Our past reviews tell us we want you back. If you've never presented at a RCC, welcome! We will be having 4-5 tracks this year with topics including .NET anything and everything, SQL Server and SharePoint. If you are passionate about a topic you feel the Roanoke Valley ...
I will be popping along to CloudCamp this Thursday. I’ve been to CloudCamp once before when it coincided with Qcon London when I was a speaker in 2009. But TBH I really didn’t pay much attention last time around as it was a) the end of a long day and b) I was only dabbling with cloud at the time. On January 1st I switched full time to the Windows Azure Platform which means this time I will be paying attention :-) Find/avoid me as necessary :-) The agenda looks promising: 6.00 - 6.10 pm Introduction ...
This article is a two-part series regarding the LinqToWikipedia provider. The first article will cover the basic concepts of Linq as well as the client usage of this particular provider while the second article will explore the inner workings of the LinqToWikipedia provider to give you an understanding of what it takes to create your own IQueryable provider. NOTE: You should download the latest build from Codeplex so you can follow along with the code samples. What is Linq? Let's spend a moment and ...
Hyper-V is getting more exposure now that SharePoint 2010 is nearing it's launch as only x64 platforms will be supported. Previously in MOSS/WSS 3.0 developers can use Virtual PC or XP Mode to virtualize their SharePoint server. Hyper-V provides greater network functionality than Virtual PC, allowing you to create Virtual Internal and External network adapters via the Virtual Network Manager. It's also possible to add Legacy Network Adapter. Often you need internet access as well as access to your ...
Hey there everyone. I was recently tasked to pitch a book to my publisher. As a first step I need to come up with an outline for the Table of Contents. This book is the standard cookbook style with an added focus on the MVC side of ASP.NET. I have been poking about at other similarly styled books to get some ideas. I think comparing ASP.NET Web Forms to ASP.NET MVC would provide some folks with a good reference point when looking at the two ways of doing things. (Thanks to my friend James Shaw for ...
Microsoft Community TechDays is back again.In Hyderabad one day full event on 24th Jan 2010. Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. For ...
I was just “reviewing” a Windows Azure Platform developer video from Adrian Jakeman of QA and spotted at the end that they had various Azure courses up and running or in development. Given the video was excellent, Adrian is a top chap and QA consistently deliver great sessions, I felt I should point folks at: Windows Azure Platform – Accelerated Training Workshop, March 30th in London, 2 days AUDIENCE This course is aimed at software developers with at least 6 months practical experience using Visual ...
A while ago I posted an article about an issue when the tracking information for BizTalk appeared not to be working and it was because the stream status was out of sync and information was not passing from the messagebox database to the tracking database. http://geekswithblogs.net/m... Since then I did a small SQL script which could be used to check if they were in sync and if not could fix the issue. This script is below incase anyone needs it. Note: I ...
Using SQL Azure for your applications is relatively straightforward. All you need is... a connection string... and since SQL Azure uses TDS as its underlying communication protocol, just like SQL Server, it may seem natural that you don't need to change much in your application design approach when connecting a SQL Azure database. However, this may not necessarily be true. SQL Azure was designed for ease of deployment and scalability; and as such you may need to take certain things into consideration ...
Common questions when learning LINQ to SQL revolve around many-to-many relationships. This post will describe a scenario that needs queries across many-to-many relationships, show the data and the LINQ to SQL representation of that data, explain the query, and finally output the results. As you know, the design for many-to-many involves a join table. The following figure illustrates a many-to-many relationship between Tags and Tasks with a TasksTags join table: A scenario for working with this data ...
Ran into this issue today when upgrading a SQL 2008 Express instance up to Enterprise and trying to run Sharepoint Configuration Wizard. Apparently SharePoint 2010 Beta doesn't like SQL 2008 Enterprise without a few hotfixes...Those of which are still in beta themselves...Those can be found in the full text of the error I recieved as follows: "SQL Server at XXX has an unsupported version 10.0.2531.0. The minimum required SQL versions are SQL Server 2005 SP3 CU3, version number: 9.00.4220.00, downloadable ...
Having skim watched many (but not all) the Azure sessions from PDC I thought I would call out my top 5 sessions I recommend you find some time to look at if you already know the basics. Tips and Tricks for Using Visual Studio 2010 to Build Applications that Run on Windows Azure Lots of great tips for developing for Azure. There is also a companion blog post. Windows Azure Blob and Drive Deep Dive Blobs have evolved significantly since day one. This session shows all. Windows Azure Tables and Queues ...
I was recently turning one of my clients database to help improve performance in their high transactional environment. One of the major caveats that we had was that the client was dealing with ever increasing size of their databases (which all organizations do) that were surging to over TB in size and had limited window of maintenance due to high availability and constant change of data. With this in mind we knew that regular database indexing was not an option adding the sizes of indexes that were ...
Tech bloggers like to have a predictions post at the beginning of each year (or the end of the previous one). I’ve never actually written one before, although I have made year-ahead predictions in panel discussions for the now defunct NYSIA. Since there’s no panel this year, and since I’m taking better care of this blog, I’d thought I’d give clairvoyance a whirl right here. The following predictions are pretty random and probably not comprehensive, but I’m making it my new year’s resolution to prevent ...
This last year I had a focus to get more involved in Open Source (OSS). The year before I had been involved a little by submitting a patch here and there, but 2009 was a big year for me in OSS. I now manage 4 open source projects that have solved a need for me and others. Coming up on the end of the year it was important for me to get some final touches into at least two projects to finish out the year. UppercuT UppercuT (UC), for those of you who have never heard of it, is an automated build tool ...
Wow, it only seems like just last week I was sitting at my PC trying to determine what I was going to concentrate on in software development for 2009. I had also just started the Frederick .NET User Group (FredNUG) in September 2008 and I was trying to figure out how to get speakers scheduled. Then, things started to quickly fall into place. My local INETA mentor, Frank La Vigne, provided me with a few names of well respected .NET MVPs who would most likely be interested in speaking at FredNUG. (Thanks ...
Suppose you have to write a test to verify that an edit form will throw a certain exception under certain conditions. If you don't use VB 9 features, you might end up with this effusion of verbosity: Try editForm.Save(MyDataContext) Throw New AssertFailedException("Save should have thrown an exception") Catch ex As Exception If Not (ex.GetType().Equals(GetTyp... Then Dim errorMessage = String.Format("Save should should have thrown BusinessOperationException; threw {0} ...
Recently I had a need to create a SQL Server 2008 SSIS package that could do SFTP transfers. The FTP component that comes with SSIS is very useful but it cannot do secure transfers. In the past I have had to use scripting to create dynamic script files for WS_FTP pro (which I do use and like very much!!) but this brought in many more moving parts and was subject to failure for a number of reasons. After a bit of searching I found http://www.cozyroc.com and in particular the SFTP component: http://www.cozyroc.com/ssis... ...
In the new film “Up in the Air,” George Clooney’s character, Ryan Bingham, poses a question relevant to the premise of BI as a cloud computing offering. Bingham is a career transition specialist -- i.e. someone who fires people as an outsourced service – and he insists that his services must be delivered on-premise (if you will), despite his firm’s new initiative to start doing so via Web conference technology. That initiative is being pushed by his colleague, Natalie Keener (played by Anna Kendrick), ...
Back when I was an Application Architect working with UK ISVs I spent a lot of time helping companies understand how to architect multi-tenanted applications. However, I have never pondered about the challenges (and opportunities) of doing this with Windows Azure and SQL Azure. Until now. What sparked it off was a fairly simple question from a UK ISV that I ended up copied on. The question in essence was “What is the recommended approach to building a multi-tenancy solution on Windows Azure and SQL ...
Earlier I had written on migrating your Northwind database from SQL Server to SQL Azure. In that, I had mentioned that the SQL Azure Migration Wizard supports migrating the schema and doesn’t do the data migration which has to be done manually. Meanwhile, George Huey has published a recent version on the SQL Azure Migration Wizard at CodePlex which also does data migration. What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along ...
Now that we have some basics for LINQ for XML. Lets get deep into some using LINQ against Relational databases, aggregate functions, like group by and sort. The database we will be using is books, this can be obtained from this page. Once you download the database, mount it in SQL Server by attaching this mdf file. Once the mdf file is mounted, we can start with the following steps to do our first LINQ to SQL console program. 1) First of all we need to add a new DB by selecting Tools > Connect ...
In this Issue: Richard Waddell(2), Jeremy Likness, AfricanGeek, Michael Washington, Colin Eberhardt, clearbreeze(2), Tim Heuer, Allan Muller, Shawn Wildermuth, Jesse Liberty, Brad Abrams, and Gill Cleeren(2). Shoutouts: I'm sure you all aggregate Scott Guthrie, but just in case: Search Engine Optimization (SEO) Toolkit Shawn Wildermuth posted links to his XBoxGames Databases for SQL Server 2005 and 2008 Fons Sonnemans posted his Silverlight Christmas Card... using behaviors he already discussed... ...
In the previous post I had described the steps to secure your Windows Azure tokens and get the necessary Visual Studio templates as well as making your web application Azure ready by adding the cloud project and building against it. Once you have tested the Development Fabric, the instances as well as the application, the next step would be to publish it to the Windows Azure platform. Select the “CloudService1” project that you added to the solution, right click and select “Publish” Once you click ...
Earlier I had written 2 posts – Taking your Northwind Database to SQL Azure and binding it to an ASP.NET GridView Part I and Part II . I thought, I will complete the series with a post on moving your ASP.NET Application as well to Windows Azure making it a truly cloud based application. Before we start, there are a bunch of things that you would need to do. First and foremost, you would need a Token for Windows Azure. You can request for a free token for Windows Azure from here after providing your ...
If you have used the Entity Framework that shipped with Visual Studio 2008 SP1, you would really start appreciating the flexibility it offers for building schema driven data access layer and get it to the UI Layer either directly or using a middle tier such as WCF RIA Service. Check my earlier post on this, if you are interested further :) Meanwhile, the other exciting stuff that has been around is the SQL Azure which is part of the Windows Azure platform. SQL Azure provides relational data over ...
While working on SQL Azure connectivity from Visual Studio 2010, I faced the above error. The full error text is as below:- “Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.window... Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match. “ As the message suggested, I tried putting ...
The next version of Entity Framework has many new features, many of which are enabling it to catch up with features previously available in other frameworks like LINQ to SQL. One of these new features is the updated stored procedure support. In previous versions of EF, working with stored procedures was quite limited and really only usable with CRUD operations that were mapped to already defined entities. With EF 4, you can start with your stored procedure and have the designer automatically generate ...
I've always thoughts that BizTalk will start counting when the host instance gets restarted or the ports enabled. And when the interval hits inside the service window, it will do whatever it needs to do. We did a test today and I was surprised. BizTalk actually executes at the start of the service window and counts the interval time from that point. We were going to set up a SQL receive location polling every 24 hours to execute a daily task, but with this new discovery, we are going to set up a ...
I have just completed a first round of updates to my popular blog post from September Entity Framework 4.0 Resources – documentation links, best blog posts and more Pop a comment here or better still in the main post if I missed something cool! (Which no doubt I have) The following were added: Overview blog posts/articles What’s New in Entity Framework 4, Part 2: Modeling Changes (Nov/Dec 2009) Renovations to .NET 4.0's Entity Framework (Nov 2009) Entity Sequel (Dec 2009) 5 Steps to having a great ...
SQL Server continues to meet the growing demands of enterprise workloads through two new premium editions: SQL Server Datacenter & SQL Server Parallel Data Warehouse The new and expanded product line in SQL Server 2008 R2 delivers unprecedented value and functionality enabling massive scale at low TCO, improved Developer and IT efficiency and Self Service Business Intelligence. Source: Emma Healey, Microsoft UK http://ladylicensing.spaces... ...
I have been playing with the WCF RIA Services (erstwhile .NET RIA Services) for sometime and found that most of the samples out there focus on Silverlight based applications. While the new WCF RIA Services preview for VS 2010 is awesome in terms of its Silverlight integration, I also wanted to test out on building plain vanilla ASP.NET Applications and using the power of WCF RIA Services to build a middle tier for the same. Ok, to begin with, I already had Visual Studio 2010 Beta 2 installed and ...
I have recently picked up a copy of Richard Seroter's book "SOA Patterns with BizTalk Server 2009", and thought that I would try and make some useful comments on each chapter as I read it. I am currently working in an environment where we have been implementing BizTalk Solutions as a part of an overall SOA strategy for a number of years, and I am hoping that this book will help me to gain a new perspective on the use of BizTalk in this type of architecture, and hopefully expand my understanding of ...
So you're familiar with TDD (test-driven development)... Failing your tests first, then building up your classes to satisfy your tests so they're all "Green"... This is a typical scenario and is pretty straightfoward with .NET. Well now you have to create a WCF service and implement unit testing to ensure you don't break your service when you build out a new version. This is a bit more challenging but you do have some different options: Separate out your service code into a library and run your tests ...
Technorati Tags: Tutorials Rocky Lhotka is Talking Oslo at ALEMUG At Atlanta Leading Edge Microsoft Users Group Rocky Lhotka spoke about Oslo. Rocky spoke about MCsla, which is the prototype domain specific language and runtime he created for CSLA .NET using the SQL Server Modeling tools. He spoke about designing and defining a DSL with a custom grammar, using the m.exe and mx.exe tools to compile DSL code into instance data, and then defined a schema so that data can be loaded into SQL Server tables. ...