Tag | Database Posts

When you add SQLCMD statements to a pre-deployment or post-deployment file in a database project in Visual Studio 2010.  You might see the error "SQL80001: Incorrect syntax near ':'".  This is not a real error assuming you have the correct SQLCMD syntax.

To clear the errors temporarily right click on the document and select SQLCMD mode.

Last week I keep searching on how to use the autocomplete in silverligth with visual studio 2010 but most of the examples that I find they are using a textbox or combobox for the autocomplete. I tried to study those examples and apply to the single autocomplete from tools on my silverlight project. And now this is the result. I will use a database again from my previous post (Silverlight Simple DataBinding in DataGrid) to show how the autocomplete works with database. This is the output: First, this ...
Identify early adopters Pick a small project with a small(ish) team. This can be a legacy application or a green-field application. Strive to find a team of early adopters that will be eager to try something new. Get the team on board! Research Research the tool(s) that you want to use. Some tools provide all of the features you would need while some only provide a slice of the pie. DBVCS requires the ability to manage a set of change scripts that update a database from one version to the next. Ideally ...
In the process of creating my own DB VCS tool tsqlmigrations.codeplex.com I ran into several good resources to help guide me along the way in reviewing existing offerings and in concepts that would be needed in a good DB VCS. This is my list of helpful links that others can use to understand some of the concepts and some of the tools in existence. In the next few posts I will try to explain how I used these to create TSqlMigrations. Blogs entries Three rules for database work - K. Scott Allen http://odetocode.com/blogs/... ...
Search all stored procedures in a database for a string SELECT routine_name, routine_definition FROM information_schema.routines WHERE routine_definition LIKE '%textyoursearchingfor%' AND routine_type = 'PROCEDURE' ...
1) Turn off Tracing unless until required Tracing is one of the wonderful features which enable us to track the application's trace and the sequences. However, again it is useful only for developers and you can set this to "false" unless you require to monitor the trace logging. How it affects performance: Enabling tracing adds performance overhead and might expose private information, so it should be enabled only while an application is being actively analyzed. Solution: When not needed, tracing ...
On Friday night, I took my life in my own hands and helped out out our local school PTA quiz night. Of course being a techie, what could I possibly add to an event like this. The answer of course is a scoreboard… Using a projector a laptop I perched myself at the front of a school hall in front of all the parents to either face a techie success or dismal humiliation in front of my peers. The scoreboard itself was an ASP.NET AJAX application that periodically and smoothly refreshed itself drawing ...
In this Issue: Phil Middlemiss, Jim Wightman, Jeremy Likness, Ross Wozniak, SilverLaw(-2-), XAMLNinja, Victor Gaudioso(-2-), Sergey Barskiy, and Jeff Handley. Shoutouts: Chris Klug posted The CommandManager that never dies…and ends up on Codeplex… Mike Swanson posted All About MIX10 From SilverlightCream.com: A Scalable Orb Radio Button Holy crap ... if you don't like this tutorial by Phil Middlemiss... just go back to programming DOS :) ... this is great... keep it coming, Phil! Using Silverlight ...
[UPDATED 10th March 2010: Edd produced a 2nd post on using IronRuby with WPF/.NET ] [You might want to also read other GuestPosts on my blog – or contribute one?] On the 26th and 27th of March (2010) myself and Edd Morgan of Microsoft will be popping along to the Scottish Ruby Conference. I dabble with Ruby and I am a huge fan whilst Edd is a “proper Ruby developer”. Hence I asked Edd if he was interested in creating a guest post for my blog on IronRuby. If you should stumble across this post and ...
For anyone interested in some really all-encompassing agile training in the Austin area, there’s a fantastic one coming up from March 24-26th at Headspring. All the topic details, schedule and registration info are here, but just a rough outline of the topics covered: object oriented programming SOLID principles design patterns dependency injection team design on whiteboard IDE tools and quickly navigating a codebase Test-Driven Development mocking pair programming refactoring pain driven development ...
BizTalk: Compensation Model As Charles Young mentioned, the Compensation is one of the most under-used features of the BizTalk. See “BizTalk Server 2006: The Compensation Model” article. If you didn’t read his article, I would strictly recommend it. Next article to read is “Transactions and Compensation Using BizTalk Server” by Richard Seroterand the "Atomic Transaction Shape" webcast by Alan Smith There are still many questions in using Compensation in BizTalk. · What is the proper order of the ...
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 ...
Just read this and found it very interesting. The following are 2 queries to get rowcount on a database table: Query 1 (the one everyone knows): SELECT COUNT(RowID) AS [RowCount] FROM elig_Inbox Query 2 (the interesting one): SELECT st.row_count AS [RowCount] FROM sys.dm_db_partition_stats st WHERE index_id < 2 and OBJECT_NAME(OBJECT_ID)='eli... What's really interesting to me is that once you look at the execution plan of the 2 queries, you'd find the improvement in performance. In real ...
Liveside.net and Mary Jo Foley are reporting that rumors of Live Mesh’s death are greatly exaggerated. That’s excellent, as far as I’m concerned. Mesh is a good product, and it would be a huge pain if I had to switch to something else were Redmond to kill it. Meanwhile, I continue to find it fascinating how many sync standards Microsoft has across its product set. Here’s a list of them (excluding Live Sync and Live Mesh), and I’m betting it’s not comprehensive. Can you think of others?: ActiveSync ...
Hi everybody, It has been a long time since my previous post about mapping stored procedure parameters to SSIS package variables post. I have been busy+lazy and never get around to posting a follow-up post until now. In this post, I will show how to execute a SSIS package using the dtexec Utility from a Stored Procedure because it is one of the most frequent questions I received for my previous blog post. First of all, I have a few important things to let you know. I am a Senior .NET Developer and ...
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 ...
Our Info Terminal loads its content from a web server via Web Services. We built a full scalable Silverlight Homepage, in which we can edit the contents for the Info terminal. Our Info Terminal application runs on a Tahoe II developer board. The interface for the page is easy to use. At first you have to login as an Administrator. Then you can add edit or delete news entries. You are also able to set an entry as invisible. A news entry can consist of a picture and as a text content. Internally the ...
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 ...
Occasionally you’ll need to restore content databases in SharePoint, whether to recover some lost data or refresh a dev/test environment. Here are the steps needed in order to access the new data: Determine which database contains the site collection you need to restore. You can find this by going to Central Administration—>Application Management—>Site Collection List. Choose the appropriate web application from the dropdown, and click on the site collection that you’re working with. Restore ...
BAM Operations, a brief summary Installing the BAM infrastructure BAM infrastructure composed on the base of the SQL Analysis Services (SASS) and the SQL Integration Services (SISS). The SQL Notification Service is an optional element. 1. Before installing BAM make sure the SQL Analysis Services and the SQL Integration Services are installed. If not, install them. 2. Create the BAMAnalysis and the BAMStarSchema databases. It can be done in separate step or while the BizTalk configuration. 2.1. Start ...
One of the things I love about NHibernate is the vibrant community that works so hard to continually improve the library. I’ve been using NHibernate off and on for a number of years on projects that had short development cycles and it never failed to provide me with a solid framework for my Data Access Layer. One particularly interesting thing is that NHibernate can generate Create, Update, and Delete scripts that allow you to manage your database and keep it more or less in sync with your entity ...
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 ...
I've been meaning to post this for a little while, and a recent post on the SSAS forum at ssas-info.com prompted me to finally get around to it. Basically the small Powershell script below will attach to the specified SSAS server and script all of the databases out to an XMLA file. In this example I also add a timestamp in the form of YYYYMMDD to the end of the file. $serverName = "localhost\sql08" $outputFolder = "C:\data\" ## load the AMO and XML assemblies into the current runspace [System.Reflection.Assembly... ...
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 ...
This is not a new topic for most of us, however there are aspects of using Virtual Machines that are applicable to us as developers and consultants that are not often discussed. As a consultant, when I begin a new project I want to be able to turn over my work and an established proven development environment to the client at the end of the project. With a VM I can give them the exact system I used, with all of the configuration and tooling intact. (Licensing can be a tricky issue so be sure you ...
I recently ran into a business problem that I can't find any sample code online. I think I worked out a tolerable solution. The business scenario is this: All rows retrieve from the database must be in edit mode, but only some fields should be in edit mode, not all. Editing one row at a time is out of the question. User might make changes and THEN want to sort the grid. Any user input needs to be preserved. Have to use .NET control that come out of the box with Visual Studio due to maintenance concerns. ...
Action Description Example AddLookupColumnToList Creates a new <b>list</b>-scoped lookup column pointing to an existing list. Download Quickstart AddSiteColumnToContentType Adds a site column to an existing content type. Download Quickstart AddSiteColumnToList Adds a site column to an existing SharePoint list. Download Quickstart CreateLookupColumn Creates a new <b>site</b>-scoped lookup column pointing to a field in an existing list. Download Quickstart EnsureSiteColumn Adds ...
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 ...
The Technology: WSS 3.0 running on Windows Server 2003 R2 Standard Edition, Service Pack 2. The Issue: Sharepoint search stops working, for no apparent reason. Some Clues: At the scheduled time when the Search is supposed to be updating, the following entries are made in the Event Viewer under Application: Sharepoint Event ID: 2436 Type: Warning Category: Gatherer “cannot be crawled. Context: Application 'Search index file on the search server', Catalog 'Search' Details: Access is denied. Verify ...
Below is the current list of charities that will be receiving free software implementations at the 3rd Annual Coders4Charities event on March 26-28, 2010 at Centriq Training in Leawood, KS. 1st Breath 1st Breath is committed to providing education, advocacy, and public awareness of stillbirth in addition to assisting families and medical professionals dealing with the death of a baby. Needs: 1st Breath would like C4C to update their website to allow for interactive forms and the ability to accept ...
Saas vs. S+S Saas is an architectural paradigm where a solution architecture can benefit from the economies of scale of the data and behavior of that architecture being built and hosted in the cloud by a third party in a multitenant fashion. Software + Services is an architectural paradigm where a solution architecture can achieve some of the same economies of scale as Saas while simultaneously benefiting from the synergies and efficiencies of the data and behavior of that architecture being partly ...
There are a few applications that I’m playing with in Windows Azure that are reliant on MySql for various reason. For example, I’m working with a group that is doing Joomla development and it’s completely dependent on MySql. Mostly this is due to using MySql native drivers rather than using a database independent layer such as ADO.NET in .NET or PDO in PHP or leveraging database specific features that are only found in MySql. Regardless of the reason, for me to run these applications in Windows Azure, ...
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 ...
Normal 0 false false false EN-AU 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; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... ...
One of my goals for the year was to speak at least three times this year and from the looks of things, it appears I’ll meet that goal in the first half of the year. This is what’s going on this year for me (subject to additions/changes): Rocky Mountain Tech Tri-Fecta 2.0 - http://rmtechtrifecta.pbwor... Coders For Charities (C4C) - http://coders4charities.org/ Chicago Alt.NET May Meeting KC .NET UG July Meeting Kansas City Developer Conference (KCDC) Virtual Alt.NET Meetings Other Events Rocky ...
I wanted to pull together all of my notes on compression I've gathered from various sources and bring them together here, in the hope that it would help someone else. All of this information is from reliable sources, such as the online MSDN but these sources aren't always easily found in a pinch. Using HTTP Compression for Faster Downloads (IIS 6.0) If your Web sites use large amounts of bandwidth or if you want to use bandwidth more effectively, consider enabling HTTP compression, which provides ...
To download the source code please click here Introduction Claim-based authorization is a new model of authorization introduced in Windows Communication Foundation. This model addresses more scenarios than the popular role based security model (IIdentity, IPrincipal). This is useful when an application requires complex and fine grained control on expressing access control decisions. Role based security model may not be powerful or flexible enough and is often too coarse when we reach complex scenarios ...
I have been experiencing an ongoing issue with the Delicious Firefox add-in where the list of local bookmarks didn’t jive with the list on the Delicious website – I had more locally than on the Delicious website. After an unfruitful exchange with Delicious support (does anyone ever really get any help with first level support? No offense intended, people), I set out to figure out what was going on myself. Turns out that another Firefox add-in called RefControl caused the post to the Delicious website ...
Coders4Charities 2010 planning is well underway! For those of you not familiar with the event, C4C is an event where developers, DBAs, graphic designers, business analysts and other geeks come together to provide free software implementations for local non-profit organizations over the course of one weekend. This is the 3rd year for C4C, and it will be taking place Friday through Sunday, March 26-28, 2010 at Centriq Training in Leawood, KS. We’re still looking for geeks willing to volunteer for this ...
Introduction In September 2006 I made a major decision on my company Source Code Management (SCM) strategy and signed up with http://www.hosted-projects.... which provide a hosted solution for SubVersion, Trac and Bugzilla. A few years earlier, I’d already moved my SCM from SourceSafe to SubVersion hosted on my own server on a local network. However, I really wanted to move to a hosted provider so I could have remote access to the SCM without worrying about firewall configuration and software updates, ...
[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 ...
What if there was a tool out there that could let you specify a structure for a project (visual studio solution + everything else) and save you up to 3+ hours of work every time you started a new project? Warmup was an idea by Dru Sellers to remove all of the setup work required every time you set up a new project. You know, create the solution, add projects, put in your references, etc. Then how about getting the infrastructure for your service/website/console set up as well with things like IoC, ...
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 ...
Lots of folks keep asking me for UK prices and to be fair it does take a little work to find them (You need to start here and bring up this pop up) Hence for simplicity, I have copied them here (as of Jan 29th 2010). Note that there are several rates available. The following is “Windows Azure Platform Consumption” Windows Azure Compute Small instance (default): £0.0728 per hour Medium instance: £0.1455 per hour Large instance: £0.291 per hour Extra large instance: £0.5819 per hour Storage £0.091 ...
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 ...
Few months ago I've been seeing many users in the forum asking how to generate dynamic textbox on the form and save the values to the database on Button click, so I've decided to write this post and wrap up all the examples that I wrote before on how to accomplish the task using different controls so that when I encounter such or similar questions again in the forum, I can simply refer them to this post. Here are those examples: Using ASP Table: FAQ: Dynamically Adding Rows in ASP Table on Button ...
We begin this particular piece of our adventure into functional programming with some WCF code unification. This same technique can be used with other constructs including database connections and anything that has a setup/tear down template. I have a small set of example code using WCF which I’ll be using as an example. The specifics of the WCF calls, syntax, and general discussion is outside of the scope of this particular post; however, there are many good references on MSDN and in other’s blogs. ...
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 ...
You can learn the Windows Azure Platform and develop against it locally on your own machine using only the SDK and a copy of Visual Studio (details here) – but at some point you will want to deploy your application to the cloud and understand how it is managed etc. At which point this offer may be just what you need. Windows Azure Platform introductory special offer: This allows anyone to try the Windows Azure Platform at “no charge”. The offer will end on July 31st 2010. Included each month at no ...