Tag | SQL Server Posts

I added an assembly and created clr functions on my SQL server only to receive the following error when I tried to excute them. Msg 6263, Level 16, State 1, Line 1 Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option....Note: Cross posted from KodefuGuru. Permalink ...
I am super excited about this event, we created the registration page just a week back and got it online for 5 days and we already had our 1000 registrations for the same, we increased the registration to 1200 and in 2 more days all 1200 filled, awesome response… I am Speaking on Getting Started with Silverlight 3 and, also speaking on Windows 7 for developers where I will be showing the Freescale board that has the accelerometer and other sensors and that will be fun, preparation is kinda ok cause ...
I will be the first to tell you that I don't think of myself as a writer. Instead I think of myself as a geek and a gardener. I will save you from my dissertation on the best food for hostas and will try to keep on track in this blog. I will stick to the geek topics as best I am able. A little about me: I have been working with SQL server since 1994, Version 4.21a to be specific. Prior to my dive into this new technology I was a mainframe DBA, working with IMS, DB2, and Sybase. This new DB technology ...
Recently, I upgraded to Windows 7 RC and found that the experience has been great. Zero compatibility issues, all works as it worked in Vista and the integration with Windows Easy Transfer (WES) has been phenomenal. If you don’t know WES, it is a tool available by default with Vista and Windows 7 that allows you to migrate your Outlook, IE, Desktop and other personal settings easily, in addition to backing up your files across different locations. Coming back to the original intent of the post, as ...
Continuing my series of great free stuff for SQL Server I’ve pulled a rabbit out of the hat for you today! In this economic climate one of the first things that seems to get cut is the training budget so anything that can help get your head around stuff is a big plus. To help Microsoft has released SQL Server 2008 Developer Training Kit So what does the Training Kit contain … Presentations (6) Filestream Spatial T-SQL Date and Time Types SQLCLR Reporting Services Demos (12) AdventureWorks Racing ...
This post is just to show some of the screenshots of the EMR software that we developed and deployed in the past few weeks in our clinic. Some of the features include: - Patient Registration - Return visit entry and scheduling - Entry for Patient history, Vital signs, ART History, Online Prescriptions, Online lab orders, Counseling, Workflow - Role base security with windows based authentication - Office 2007 Themes (Don’t know whether to call this a feature) Thanks to Component Factory The lab requisitions ...
I worked on a project for PaperWise a few months ago where I needed to restrict the results of a SQL view based upon the user executing queries against that view. To do that, I needed some way to tie the query being executed on the view to the user executing it. The problem is that subsequent queries in PaperWise don’t necessarily identify the user executing them. PaperWise uses standard SQL Server authentication and not Windows NT authentication, which means that we have a Users table in our database ...
I was working with a system migration where a client had moved a database server. The actual SQL Server HW was moved but not the SAN where the database MDF’s and LDF’s resided. They solved this by copying all of the data and log files onto a portable (USB) disk and sending this with the server. These files where then to copied onto the SAN at the new hosting place. But, they did not detach the databases first. Just copied the files. So when the server came up on the new location all the databases ...
Codeplex is a wonderful site. However not just for the .Net coder but the SQL Server guy/gal can find plenty of goodies there as well. One such goody is the FineBuild utility that does as the name suggest helps create a ‘Fine Build’ of your SQL Server install. All to often installing SQL Server can turn into a day long process with the various additional service packs, CU’s, tools and utility to install. Well FineBuild can automate all of that so all you need to do is run the start script, go off ...
For anybody that bought the SQL Server 2008 Self-Paced Training book for 70-433, if you are running a full version of SQL Server 2008 rather than the express edition, you will have problems attaching the AdventureWorks2008 database (file activation error). The trick is to use a SQL command, like so: USE [master] GO CREATE DATABASE [AdventureWorks2008] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQ... ), ( FILENAME = N'C:\Program Files\Microsoft ...
Last week, i.e. in a single week, Microsoft was on real tear: the company announced a release date for Windows 7, disclosed details of Zune HD and Zune’s integration into Xbox Live, discussed Project Natal and other coming improvements to Xbox, and launched its Bing “decision” engine. And all this week, at a special software design review (SDR) event, Microsoft is introducing major new business intelligence features coming in SQL Server 2008 R2, including its project Gemini product that helps rogue ...
Having posted on the SQL Adapter to select data from a SQL Server database, I realised (too late as it happens!) that I had missed one approach. This approach is to use the Strongly-Typed Procedures option from the Adapter UI. You can see you get to choose from the same list of stored procedures, but this time you get additional schemas generated. The approach I took was the same as used for the untyped stored procedure, so taking a file in, transforming using a String Concatenate functoid, calling ...
It’s not often we get stuff for free but Microsoft has decided to give away a complete book, not just afew sample chapters. All you have to do is go to this link , press the ‘Sign Up’ button, leave some details about yourself, if you’ve registered with MSDN before it’ll just pick up you existing details and then pdf will download. So what’s the catch? Well you will be signing up to Microsoft Press Book Connection monthly newsletter and learn about new books on Microsoft SQL Server 2008 and other ...
Downloads Microsoft BizTalk Adapter for SQL Server http://www.microsoft.com/do... BizTalk Adapter Pack 2.0 http://www.microsoft.com/do... Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications http://www.microsoft.com/do... BizTalk ...
I solved a problem identical to the description of this problem with SQL SERVER and you can see my post here; and I’ll share the solution for oracle below. After you have configured the Oracle data source (and worked your way through the errors) and the data source appears in the library - the problem cannot be solved with the configuration tools in SPD. Go to the ‘_catalogs/fpdatasources’ folder in the folder list panel of SPD. Find the XML file that corresponds to the data source in error as it ...
I started having a think about how you could make BizTalk Server 2009 RESTful as I had been asked to give it some thought. Whilst thinking about it and wondering how I could let any subscription know the message it was subscribing to was supposed to be GET, DELETE, PUT or whatever I started creating some basic plumbing to give me something to test. To this end I started taking a look at the new WCF SQL Adapter in the BizTalk Adapter Pack 2.0. This new adapter is built using the WCF LOB Adapter SDK ...
On August 1st the Baton Rouge Area SQL Server and .Net user groups are hosting an all day free SQL Server and .Net training event! Attendees will have chances to win great prizes! What more could a SQL Server and .Net Professional ask for? If this sounds good to you then don’t miss your opportunity to attend SQL Saturday! #17, the largest FREE training event dedicated exclusively to SQL Server, .Net, Development and Business Intelligence to hit Baton Rouge. Registration is required. For more information ...
Last month (May 2009) Microsoft has released its first beta for Visual Studio Team System 2010 and Team Foundation Server 2010 release, two of the most waited and wanted tools in developer community. From my point of view these two releases are going to be one of the most historical releases, as lots of really cool stuffs has been added with respect to the last version. However, as the Beta 1 releases are pretty infant, there are very limited resources available in the web and community, so I just ...
Introduction The WinPHP challenge is running towards it’s closing time. Only a few days before entering I came with the idea to enter the contest. I had to put a lot of my spare time into it, but it was worth it. I learned a lot from exploring the realm of php. It’s fun to work in a language I normally do not work in. And to find ways to implement some thoughts that have been on my mind for a while. Here’s the story about the what, the where and the how of BlogSnor, my entry for the WinPHP challenge. ...
You might get entangled while reinstalling SQL Server 2008 on a PC where VS 2008 has already been installed before. Simple way to resolve this scenario is to install VS 2008 SP1 on the machine. Various routes which can be taken are: · Install Visual Studio 2008 SP1 before you install SQL Server 2008 OR · Uninstall Visual Studio 2008, and then install SQL Server 2008. After SQL Server 2008 is installed, you can install Visual Studio 2008, and then install Visual Studio 2008 SP1. OR Do not install ...
First, for all of the MS SQL Server database purists out there that will complain vehemently against this method of extraction/formatting because of the special characters (SEE: http://www.webmonkey.com/re... that may (will likely) surface and need to be escaped, or that there's a better way to do this such as utilizing the XML Schema Collection/XML Explicit features available with SQL Server, etc. -- I recognize your concern, however, you'll have to admit, this is still (low-tech/mid-90's ...
Microsoft yesterday released a new ‘May 2009’ CTP for their 'Oslo' toolset. This can be downloaded from Microsoft's web site at http://www.microsoft.com/do... The release is notable for a couple of reasons. First, it provides insight into the move away from the 'three-in-one’ language approach (MGraph, MSchema and MGrammar) towards a single unified, 'M' language. Second, it contains an early version of 'Quadrant' which, ...
Learn how CRMCompany created a solution from their existing Windows application based CRM that is available over the Web and answers the requirements of the customer. The article explains why Visual WebGui was chosen for this project. The Roof Vault application includes a roof vault configuration tool in which a 2 dimensional drawing of the roof vault is displayed which can be manipulated by parameters. The Roof Vault is manufactured using this same drawing and parameters. This part was written in ...
Recently, I was trouble shooting an error for my friend. Despite having all the necessary framework and service packs installed, this error “Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934... or one of its dependencies. The module was expected to contain an assembly manifest.” was surfacing, every time we tried connecting to a SQL Server instance using SQL Server Management Studio. At first, I thought the issue must be with SQL ...
R2 ! As you may know I’m abit of a SQL Server nut so I was particularly interested in the announcement at the recent TechEd of SQL Server 2008 R2. R2 is the combination of the Kilimanjaro, Madison and Gemini projects. Kilimanjaro is adding support for up to 256 processors to the existing code base. Whilst Madison follows on from the purchase of DataAllegro last year moving data to handling petabytes of data. Lastly Gemini is about taking on Qlikview and providing Analysis Services using column-oriented ...
With "Dublin" on the horizon as the future distributed application server role for Windows, does it make sense for Microsoft to call this new role "Windows BizTalk Services"? This would in many ways mimic the Windows SharePoint Services/Microsoft Office SharePoint Server paradigm. The only problem in the short term is that BizTalk Server 2009 has just been released and looks nothing like Dublin. The ideal set of products would first include Windows BizTalk Services, which includes all of the lightweight ...

Watch the Introduction to SQL Server 2008 R2 Video

*Moved to: Upgrading to TFS 2010 Beta 1 and SQL Collation I have just finished installing TFS 2010 beta 1 and doing an upgrade of out TFS 2008 data. This did not go well… Due to a collation mismatch between my original SQL Server 2005 and my new SQL Server 2008 I received an error when upgrading…Read more...Follow my new blog on http://blog.hinshelwood.com ...
Background : In my last post about SQL Server 2008 new feature File Stream (Saving and Retrieving File Using FileStream SQL Server 2008), we did an example of saving an image to the file stream and then retrieve it back and make it available for download. The result of that example looks like as below. But, one has to press the button to download the image file. One of my blog reader raise a point that he wants to display the same image instead of Get File button which is going to download. Introduction ...

We did the database migration this morning and everything seems to work perfectly.  The environment is about 5x what our previous server configuration was and we moved from SQL Server 2000 to 2008.  Ping me if you see any issues because that was a little too easy.

At Lansing GiveCamp I was chosen to lead a team tasked with creating a guest registration system for Ronald McDonald House of Mid-Michigan. Ronald McDonald House wanted to get off their current system, paper, to streamline their processes and report on their data. The event started around 7:00PM on Friday and ended with 3:00PM on Sunday. That’s 44 hours. At first it seemed too simple and I wondered if Microsoft Access wouldn’t have been sufficient for their needs. That is until Jay Harris met with ...
Finally I am able to download the Visual studio 2010 and prepared my system to install visual studio. I downloaded VS2010Beta1ENU_PRO_2PartsTo... and VS2010Beta1ENU_PRO_2PartsTo... files from here. I took the back up of my VHD (Virtual Hard Disk) which is a Windows XP with Office 2007, Visual Studio 2008 professional, SQL Server 2005 Express edition, Silver light 2.0 SDK and Microsoft Expression 2.0. Let’s see how my installation went on. I started my installation by double clicking ...
If you live in Edmonton and do anything with SQL Server you should definitely check out the upcoming first ever meeting of the Edmonton chapter of the Professional Association for SQL Server (EDMPASS). Colin has done a great job getting this group off the ground, and he’s brought in Scott Gillespie to talk about SQL Server 2008 for Developers and DBA’s. I’ve included the info about the session below. Go be part of your local technology community. Date: May 28th 2009 Time: 5:00 pm - 7:00 pm Location:Stanley ...
Today I wanted to find the version of SQL Server 2008 installed in my machine. I did a quick search and the first support article from Microsoft had the answer to it http://support.microsoft.co... I just modified it a little bit with column headings so that if you are using it in an SP, returning it etc., it would help. So the modified query is as below SELECT SERVERPROPERTY('productvers... as 'Product Version', SERVERPROPERTY ('productlevel') as 'Service Pack Version', SERVERPROPERTY ('edition') ...
I’m speaking again at DevTeach this year in June in Vancouver. Here is a comprensive list of things going on. Party with Vancouver IT community Monday June 8th URL: http://party.cuga.ca/Home.aspx Vancouver IT community is hosting Monday june 8th in Vancouver a DevTeach kick off party. This is the official social event for DevTeach Vancouver. The event is not just for the attendees of DevTeach Vancouver it’s a free event for everyone. It’s a unique chance for the attendees, speakers and locals to ...
Last Monday, Microsoft used the TechEd keynote to announce their plans to include a Complex-Event Processing (CEP) engine in SQL Server 2008 R2. This article attempts to explain CEP from the perspective of a long-time user of BizTalk Server and to address the question as to why BizTalk architects and developers might have a reason to take an interest in the forthcoming CEP engine. Read on at http://geekswithblogs.net/c... ...
Last week was certainly an exciting weeks for many of the Microsoft bloggers in the community. Microsoft Tech-Ed 2009 in Los Angeles, one of the largest technical industry events of the year took place, and it appeared as always Microsoft reserved many of the announcements for its forthcoming Windows 7, and Office 2010 platform until last week. Being based in Sydney, and I unfortunately didn't managed to attend the event (through cost, as opposed to want), however through the trawling of many blogs ...
Web Platform Installer is a tool, which contains many libraries, components and ready to use solutions. This tool very useful, because allow to save many time. Also, it is free tool and you can download it and install on your machine. However, speech now not about it. Recently there was updating WPI in which there was a driver for support SQL Server in PHP. It is easy to be convinced of it if to start an installing package. Thus, developing on PHP you can use all benefits of usage of SQL Server. ...
Long past due is a review of Julie’s book, Programming Entity Framework, ISBN 978-0-596-52028-1 Julie adopted Entity Framework early on, from before it was even available to most MVP’s. This book is a reflection of that involvement with the product and the product teams over the past few years. This 23 chapter, 750+ page book covers a lot of ground and provides a great reference book for almost everything entity framework related. The first few chapters introduce the framework and will give you a ...
Um so you know its your dream to use windows server 2003/2008 as your desktop Operating system right? So most of you just said no. However for the small amount that might just be curious here is a little script to stop installed server applications built into these server installs. @echo off :start set /p _input="Server? [y/n]" if %_input% equ y ( echo Starting server services… sc start HTTPFilter REM HTTP SSL sc start IISADMIN REM IIS Admin sc start lanmanserver REM Server sc start MSSQLSERVER REM ...
Have I mentioned lately that I’m not the sharpest tool in the shed? It seems I was brilliant when setting up my SharePoint VM and I used my user account when setting up my VM’s service accounts. Smart move? right? At least I won’t forget what username and password I used. Well…. pretty stupid actually. My password changed on my user account which broke SharePoint on my VM. I couldn’t access any of the sites or Central Administration. Actually, I knew this was going to happen, I was just procrastinating ...
Project Sourcecode: NewsMashup In Part I of this series of articles I discussed the database that lies behind the application. Moving from the backend to the client side, it is now time to discuss the code which accesses the database and returns the data to application. I have a standard class I use when accessing databases. The version I am using here is developed to connect to SQL Server but with some minor changes it would not be difficult to adapt to other databases, and I already have one for ...
If you have had a chance to look at the downloadable videos from MIX 09 (http://videos.visitmix.com... then you will have heard that it will soon be possible to develop Azure hosted applications and have good old Transact SQL as a backend! It was in Nigel Ellis’ session on ‘What's New in Microsoft SQL Data Services’ which gives all the details. However as of the time of writing this functionality, while due in the next couple of months, is not yet available. All is not lost. I am going to ...
The Brandon .NET User Group will be hosting an event this Thursday, May 14th! From their website: In this session we will take you through building a data-driven web site using some of the latest tools in the ASP.NET landscape. We will go from zero to fully-capable site in 10 minutes, then drill deep to cover off how it all came together. Discussion: ASP.NET, LINQ to SQL, Dynamic Data Templates, URL Routing, SQL Server Express 2008 Pizza will be provided. To register for this event, click here ...
The Calgary PASS (Professional Association for SQL Server) is hosting an event tomorrow night, with John Bristowe talking about SQL Server Data Services. They’ll also be giving away a free registration to the upcoming DevTeach conference in Vancouver this June! Info on the event is below and you can register for the event at their website here. When: Wednesday, May 13, 2009 Where: CGI, 7th Floor, 800 – 5th Ave. SW, Calgary, AB Presenter: John Bristowe of Microsoft Canada Topic: SQL Server Data Services ...
NewsFlash...Microsoft today announced their long-awaited entry into the Complex Event Processing market. The press release is at http://www.microsoft.com/pr... The news was also announced by Bill Veghte as part of his keynote at TechEd. The Microsoft CEP offering will be delivered as part of SQL Server 2008 R2 Unfortunately, this is the only information I can find so far in the public domain, and, being a cautious kind of guy, and NDAd up the hilt, I will ...
I installed SQL Server 2008 Reporting Services with Microsoft Dynamics AX 2009 Reporting Extensions on a 64-Bit Windows Server 2008 system. While Deploying the reports I encountered the following error message: ===========================... Error: Deployment failed unexpectedly with the message: Not found See the log file for further details. Deployment failed with the following exception: System.Management.Managemen... Not found at ...
I have seen an interesting issue surface recently, one that many other corporations are probably facing: the dividing forces of security and auditing. It could be argued that auditing practices should strengthen security, however this may depend on the situation. Let's take database access control as an example. In a typical two-tier application, connections established to a database server are performed using a shared account. Usually, shared accounts are considered less secured than network accounts ...
Well - I am pleased to announce that I will be speaking at the SQL Server User Group of South Florida this coming May 28 2009 in Miramar (at the Devry University Campus). This group is run by Scott Klein. The topic? It will be on SQL Server Performance covering SQL Server 2005 and 2008. I will be mostly talking about indexes, index strategies, execution plan analysis and tracing... This month, our sponsor if TEK Partners - they will be bying Pizza... so there is no excuse... food, fun and networking! ...
A friend recently asked how do you make a call to a web page via code. For example, the web page might be designed to return some data in a text-based format and filtered by query string parameters. (While this is more commonly done using a web service, it can also be accomplished by controlling the output of the HttpResponse object.) The following is a basic demonstration of how you might go about coding this in Visual C#: 1: /// <summary> 2: /// Makes a request to a Uniform Resource Identifier ...