Tag | SQL Server Posts

Although the azure application will be running on the sky we still need to develop it on the ground since we would not be able to fly. In order to make it easy and simple to work with azure on local machine we need to download the Azure SDK firstly. Azure SDK extend Visual Studio 2008 and Visual Studio 2010 RC to enable the creation, configuration, building, debugging, running and packaging of scalable web applications and services on Windows Azure, and it includes all necessary assemblies which ...
When deploying the Microsoft.BizTalk.ESB.BAM.E... BAM activity (as part of the Core ESB Toolkit install) we ran into this error: --- OLE DB error: OLE DB or ODBC error: DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied : 08001 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘bam_ExcByApplication’, Name of ‘bamExcByApplication’ --- The issue was that we used a SQL Server Alias while configuring ...
The following code is from Ralph Whitbeck's blog. This is really a "cut and save" for me :) When restoring an SQL Server Database, you'll often need to kill existing connections to it, before starting the task. Change databaseName To the actual database name. Use Master Go Declare @dbname sysname Set @dbname = 'databaseName' Declare @spid int Select @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) While @spid Is Not Null Begin Execute ('Kill ' + @spid) Select @spid = min(spid) ...
To me Azure is a new technology but in fact it's not that new. In the PDC08 Microsoft announced that their cloud computing platform had been released with the name Azure, which stand for the color of the sky. I began to play with Azure recently and will post a series of blogs for what it is and how to use it. But first of all we'd better to understand what's Azure. If we went to the official website of Azure we can find the official definition. The Windows Azure platform offers a flexible, familiar ...
One thing most database change management tools use is SQL Server Managment Objects (SMO). Most do that because ADO.NET doesn’t allow the batch statement separator keyword GO in sql statements. So most people write off the ability to use a database change tool for sql server without actually having the sql server installed on the machine that is running the tool. This is not a reality in some organizations, especially when licenses for SQL server are limited. Split the GO Recently, a few guys have ...
In this all-submittal Issue: AfricanGeek(2), Michael Washington, Roberto Lopez, Brett Balmer, Rui Marinho, and Alex van Beek. Shoutout: Austin Avrashow has an interesting demo up of Mark Twain's Travels Just digging my way out from under being inundated with information for a week. Be patient, I'll catch up! From SilverlightCream.com: Silverlight Video Tutorial #13 AfricanGeek has 2 new video tutorials up on his site. This first one adds a Slider control to the Media Player and edits the Slider template ...
We’re very happy to have Damir Bersinic from Microsoft come and present on SQL Server 2008 R2 on March 9th! Below is the event abstract: SQL Server 2008 R2 is coming soon featuring several breakthrough capabilities that will enable your organization to scale database operations with confidence, help improve IT and developer efficiency, and enable highly scalable and well managed Business Intelligence on a self-service basis for your users. Come and find out how these changes will impact your role ...
This should not require a blog post! That being said, I struggled on and off for several days before I hit the right sequence of steps to install the SSMS package onto my existing instance of SQL Server 2008 Express. When I initially installed SQL Server 2008 I downloaded the version that said it was “with tools”, assuming that meant I would get the light version of the Management Studio along with the instance. Okay, I know what assume means. And as usual, it did not work as it should have. I ended ...
Last week one of my colleague asked me that how we can send multiple records to SQL server procedure parameters. Let us discuss the scenario:- Application user has selected multiple product and now you want to send Customer details and corresponding order details data to SQL Server. To resolve this Microsoft has provided multiple approaches in SQL Server like Table and XML Parameter. I read somewhere that if you want to be a architect, try to solve each software problem with xml framework. Let us ...
Just getting a few interesting cloud links “down on paper”. I last did one of these on Azure in Dec 2009. Not everyone seems to know that Roger Jennings does a rocking job of collating links on Azure – e.g. Sunday Feb 14th. Recommended read - Using SQL Server Client APIs with SQL Azure Version 1.0 Q&A: Looking Ahead at Microsoft's Cloud Strategy Tim O'Brien, director of Microsoft's Platform Strategy Group, discusses the future of Windows Azure, Silverlight, and developing with .NET. Getting MySQL ...
I have been using VSeWSS 1.3 since it first became available. As of this writing it is still in the CTP release stage. The previous version, 1.2 is still available, but the biggest advantage of the 1.3 release is support for 64 bit OS which was a prime motivator for me. Also 1.3 now supports publishing sites which was not possible with the previous versions. VSeWss 1.3 March 2009 CTP is available, and is the version I am using for the purposes of this article. A good blog post about the extensions ...
I recently conducted a small poll and it turns out that SQL Mobile is the most requested topic (see ongoing voting results here). So in this tutorial, we will cover how to create a SQL Mobile database for the PDA or emulator. Having seen the SQL Server Express (mentioned here), let's now look at SQL Mobile. Being the successor of SQL Server CE 2.0, SQL Mobile is Microsoft's lightweight database server that has a small enough footprint (~1.5MB) to fit and run smoothly in a Pocket PC device. It is ...
I normally use an int with an identity as the primary key for most tables in Sql Server and I think that is probably the normal habit of most developers, but on occasion, you will need to use a unique identifier, which maps to a System.Guid in code. I am not going to go into the pros/cons of using a Guid as your primary key, as there is much debate around this. I am currently working on a project where this is required and I also use Entity Framework 4 and ran in a snag almost immediately. Entity ...
We have just upgraded our TFS production system to the RC from Beta 2. Upgrading and Migration were done in 1.5 hour. More than 75 team projects upgraded. Our 30 internal developers and some more external will wake up to a new world tomorrow morning :-). Martin Hinshelwood managed to beat us with some hours http://blog.hinshelwood.com... but we must still be one of the very first companies to move over! We have a two-tier solution, ...
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 ...
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 ...
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 ...
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 ...
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 ...
Over the past several weeks I’ve found myself having to play the role of server administrator more and more. Being a developer I’ve had some exposure to server admin work in the past, but I certainly don’t consider myself an expert in the area. Unfortunately there was no one else to do it, so theses tasks started to come my way. Just before Christmas I was driving down to south Florida to visit family when I saw an urgent message from work stating that people were having issues logging in to our ...
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 ...
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 ...
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), ...
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... ...
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 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 ...
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. ...
While at TechEd Europe in November 2009 I had a chance to catch up with David Robinson, Program Manager in the SQL Azure team and discuss... SQL Azure :-) We cover the "reboot", large databases, the new support for SQL Azure in SQL Server Management Studio, customer feedback and futures. V2 hints include: - bigger database - automatic partitioning - spatial data types You might also want to check out the slides of a SQL Azure session I recently delivered based on the session David gave at TechEd ...
Conventinal Way of Searching : When there is a requirement to add a Search feature inside a website to search through knowledge base the first thing that will crack our mind is to add a Free Text Search with some Keywords. If it is a SQL server we will hit a free text query over a specific keyword index else we might lookout for some third party indexing utility like lucene.net to to fetch best matching result for the end user. This is called Keyword Searching. The search key words will be like "CEO ...
UPDATE: 5th January 2012If the client machine does not have SQL Server Configuration Manager, then head over to this MSDN article, http://msdn.microsoft.com/e... Qureshi has written an excellent comment for how to use the command line utility, cliconfg.exe, on a client machine which lacks SQL Server Configuration Manager. Isn’t this old hat? In a distant SqlBits, far, far away (actually the very first SqlBits) I gave two grok talks; the first on developers using SQL Server ...
Microsoft makes an excellent digital music player (the Zune HD), a well-crafted networked storage and backup solution (Windows Home Server), a strong DVR/digital entertainment hub (Windows Media Center) and perhaps the industry leading gaming console (Xbox 360) which itself has a growing number of digital media capabilities. But can they all get along? That was my question almost a year ago, when I returned from the 2009 Consumer Electronics Show, which was riddled with a variety of incompatible, ...
We are working on a cloud based application for a long time existing customer. we came across a pretty interesting challenge. The problem was; the New cloud based application needed to be able to integrate with our existing legacy applications. in particular our call center application. We have no intentions of moving this application to the cloud, however we need to be able to have access to some of that data with our new Application. Couple of weeks ago At PDC, during the Keynote Andy Lapin of ...
So I set out on a quest to install a SharePoint 2010 VM with Bob Davis, one of our 101 instructors for SharePoint Saturday Kansas City and a Co-Leader of the KC Office Geeks. We started around 5 pm and ended around 11 pm. Everything that could possible go wrong went wrong in triplicate. Here is a list of things you need to know: Turn on Virtualization in your bios: Bob did not have virtualization turned on in his bios, so the virtual machine I had stubbed out did not work. You need to make sure that ...
Part of my current project involves several batch processes that are run after normal working hours. Most of these jobs are doing either one of two things: importing data from a text file or exporting data to a text file. (Since my project is replacing an existing set of applications, we were required to maintain compatibility with the other systems that are sending or receiving data to or from us.) Our data is stored in a typical SQL Server 2005 database. We decided to use .Net based console applications ...
Background: Out of first few tasks that were assigned to me in my new project, I was asked to help testing team with promoting an existing partially tested BizTalk interface. After little bit of code re-factoring and ensuring that the design has been simplified (removed some unwanted logging etc.), we put code to the test. Functionality wise there were not many issues which surprised us and we quickly got over it. However, it wasn’t for long that we realized that there was some obvious issue hidden ...
Asynchronous statistics auto update in SQL Server would ensure that the statistics are not updated when a query is executed, ensuring timely response. For this option, we need to set AUTO_UPDATE_STATISTICS_ASYNC to ON and also AUTO_UPDATE_STATISTICS to ON. Here, a separate thread runs in the background, which actually does the job of updating the statistics. So updated stats are available the next time for a query. This can also work the way round, meaning that a query might be using old stats and ...
This should work for SQL Server 2005/2008-- ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName example: ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture ...
Two areas I am looking at right now are SQL Azure and Entity Framework 4. PDC had plenty of content on both these areas. Just need to find the time to watch some of it! I have added direct links to the standard definition WMV and the PPTs to download (which is what I am doing right now). SQL Azure SQL Azure Database: Present and Future Windows Media Video PPT Using the Microsoft Sync Framework to Connect Apps to the Cloud Windows Media Video PPT The Future of Database Development with SQL Azure Windows ...
I was asked a little while back to pull together the best training resources for .NET development to feed into a MSDN UK site. I thought it would be useful to share here as well. By no means everything is listed but sometimes less is more :-). Enjoy: Top Tip: Watch out – these are sometimes big downloads. For instance I just downloaded a high def PDC2009 session at 600MB! I recommend you check out Free Download Manager – it is a great open source tool for working with large files. Offline Training ...