Tag | SQL Server 2008 Posts

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... ...
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... ...
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 ...
A big thanks to all those who attended http://edgeug.net/ last night to hear about SQL Azure and SQL Server 2008 R2. I really enjoyed it and once again “Merry Christmas”! Links http://bit.ly/startazure takes you to the getting started page for SQL Azure (and Windows Azure) Download SQL Server Management Studio R2 which works with SQL Azure Brief walkthrough of using SSMS R2 with SQL Azure (nice screenshots similar to what I showed in the first demo) Download the SQL Azure Migration Wizard http://twitter.com/ericnel ...
I just started the appetites with my last post on RoundhousE. RoundhousE itself has a migration sample to help you get familiar with how it works. You can get to that by using a subversion client to download the source. When you download the RoundhousE source from SVN and run build.bat, you get a code_drop folder. Go in there and look at the deployment folder for a sample run. Prerequisites: Locally installed (and running) SQL Server 2008 Run That Bad Boy When you get into the code_drop folder, take ...

Thought this may be of interest to some SBUG Members as they will be discussing SQL Server 2008 R2 and SQL Azure at the Edge UG

 

http://edgeug.net/

 

I just went through the process of creating a VHD for use by myself and some other members on my team. I had a pre-built base image with Windows Server 2008 and SQL Server 2008 Enterprise that I used to begin the process (Note: I was hoping to use Windows Server 2008 R2 but it appears it only comes in 64-bit and VirtualPC doesn’t support 64-bit). From there I installed Visual Studio 2010 Ultimate Beta 2 and Team Foundation Server 2010 Beta 2. Everything went extremely smoothly except for one small ...
I have been working on database synchronization for a couple of weeks, and seems it at the final testing stage, I am using Microsoft Sync Framework 2.0, the DB server is SQL server 2008 Standard, and clients are SQL Server 2008 Express as I use Change Tracking to track DB changes instead of TombStone Tables and Guid tracking columns, I use WCF+IIS+SSL to host server side service, the binding uses Gzip binary encoding. The reason we are not using SQL Server Replication is because our tables need dynamic ...
This is my 100th post to this blog, but it’s also, in a real sense, my first. That’s because, starting now, my blog will be syndicated on RedDevNews.com and VisualStudioMagazine.com, the same sites that carry my monthly column, Redmond Review. For those who haven’t read my posts or columns before, allow me to present a quick intro. (For everyone else, go ahead and skip to the next paragraph.) My name is Andrew Brust, and I’m a Microsoft MVP and Regional Director. I don’t work for Microsoft – they’ve ...
I haven't had much to post about for a while, but yesterday I decieded I was going to take Keramic Koala, the next release of Ubuntu Linux for a spin. I have an old machine sitting around, and I wanted to turn it into a subversion server. So I downloaded the CD image, and true to my past experience with Ubuntu, it downloaded blazing fast, being about 700 MB CD image in about 15 minutes. Burnt it, and popped it into my beastly machine. The machine I'm setting it up on, has 500GB Hard drive, Pentium ...
Full Disclosure: I was lucky enough to be sent a free review copy by the publisher But... if I had not been sent a review copy I would have gone out and bought a copy of this book anyway. Why is that? Because I had purchased the previous edition and I knew that it would be the most in depth book on SSAS 2008 available. It has been written by members of the product team and contains a wealth of information that just could not come from any other source. I'm sure most of you have heard that Attribute ...
If you like to migrate your Web tier or the ASP.NET Application to Windows Azure, check my new posts Part I and Part II SQL Azure is the latest buzz around Cloud Computing and the ability to take relational database to the cloud as is, is something most would welcome compared to the earlier model of ACE (Authority, Container, Entity) that was there when SQL Azure was SSDS. Well, like others, I also got interested and wanted to explore the SQL Azure. SQL Azure is currently in CTP and offers token ...
What a pity. I’ve spent some time recently evaluating SQL Server 2008 Reporting Services with respect to its proposed use on a UK public sector project that will implement a part of the 'national infrastructure'. In every respect but one, Reporting Services provides an excellent fit for the stated requirements. There is already a commitment to using SQL Server, and SharePoint, within the project, so Reporting Services appears the way to go. What is the exception? Well, Reporting Services provides ...
This is the second in a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. In case you don’t want to skim through the whole post, the main things I learnt in day one are: 1. Never forget that install errors can be caused by something as simple as a corrupt file! (My “battle” outlined below) 2. Virtual PC RC for Windows 7 isn’t perfect. It doesn’t like working with a VM created on an older version. (Details below) 3. There are some nice storage explorer tools ...
Next week I am presenting two sessions at Software Architect 2009. Both sessions are new, new in the sense that I am creating them this week and new in the sense that whilst they are on topics I have experience with, in each case there is a significant new element for me to learn. I thought it would be fun and interesting (to me anyway!) to keep a diary of my preparations to get these sessions in good shape. The two 90minute sessions are: Design considerations for storing data in the cloud with Windows ...
I’m participating in the Microsoft Gemini CTP (Gemini is the self-service BI component cooperatively provided by the forthcoming SQL Server 2008 R2, Excel 2010 and SharePoint 2010) and the SQL Azure CTP. I found intriguing the question of whether these two CTP technologies could be used together. Turns out they can! I successfully got Gemini to import data from a SQL Azure Database (after migrating the AdventureWorksDW2008 dimCurrency table into an Azure database called AWCloud)! I set up the connection ...
The Regina Technology Community welcomes Nick Nastic! Topic: SQL Server 2008 R2 and project codename "Madison" SQL Server 2008 R2 is the next generation of the Microsoft SQL Server database platform, planned for release in the first half of 2010. SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help organizations improve IT and developer efficiency with: new and enhanced tools for the management of applications and multiple servers master data services complex event processing ...
Hello Folks, Today I'll will mention the Microsoft SQL Server 2008 Fileds data types, you need to choose the right data type for the database fileds for more speed efficency, and i think the most important thing the fundamental of the database itself. Let's begin: char: the char datatype is ifxed in length, if you enter fewer that than the number of character defined the remaining length will be space filled to the right; use this data type when the column dat is to be of fixed length, which tends ...
Here I am after a week of putting Windows 7 to the test while working frantically on a tight timeline project and am happy to say that all is well. It has crashed a time or two and I still cannot install Visio 2007 or SQL Server 2008 Developer Edition, but I am still pleased. It seems to be faster than XP and I quickly got the hang of using the UI and the search feature. There are quite a few handy conveniences that will make life easier such as the RDP client has a recently used list. I went ahead ...
I decided to join in on the fad and perform a dual boot installation of Windows 7 RTM on my laptop with Windows XP. I am working on a project with a pretty tight timeline so installing from scratch was way too risky. I took the advice from some of my co-workers and went for the dual boot option by creating a partition using Acronis Disk Director in which to install the new OS. I created a 30 GB partition and started installing with the DVD that was created from the ISO. The installation was super ...
So when I first started working with SQL Server 2008 and LINQ, I would pretty much just use the LinqDataSource because it was definitely the easiest to use. It’s pretty good for testing purposes, or really small projects, but if you’re doing anything that is going to grow / is large already, then you’ll probably not want all that logic embedded in your pages. As I became more comfortable with LINQ, I decided to take on the task of switching over to the ObjectDataSource to bind to my ListViews. Here’s ...
The project I am currently on encompasses a large push to clean-up and standardize the client's Reporting library. Currently, there are around 70 odd reports that were created and/or worked-on by an assortment of consultants and employees over the span of several years. This process was very organic, responding to the needs of the moment without any over-arcing design philosophy or guidance. As a result, there is very little consistency in how these reports are structured, or how the settings are ...
What is Kerberos Authentication? Kerberos (or Cerberus) was a three-headed dog in Greek Mythology which guarded the gates of Haides (King of underworld God of Death). Kerberos was responsible to prevent ghosts of the dead from leaving the underworld. The Kerberos Protocol was created by MIT as a solution to network security problems like: 1) Insecure unencrypted password over the internet 2) Firewalls, which assumes that the bad guys are outside the network, what about the Bad Guys within the network. ...
This is the final post in a four part series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 3. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight ...
This is the third post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 2. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight Toolkit using ...
I was doing some new CLR Stored Procedures in SQL Server 2005 and at a certain point received error: CREATE ASSEMBLY failed because method 'MyMethod' on type 'StoredProcedures' in safe assembly 'MyAssembly' is storing to a static field. Storing to a static field is not allowed in safe assemblies. Interestingly, despite all the procedures inside SQL CLR stored procedures have to be declared as static, no static fields are allowed outside them. So in my case declaring a static variable outside SqlProcedure. ...
The last 2 months have been a whirl. The company I'm with is busy building out our business intelligence team and I'm catching up on SQL Server 2008 internals. We've got ETL packages in SSIS grabbing data from service providers in Excel and have been dealing with Jet / unicode issues. Gotta love "IMEX=1" in your connection string.... So this is my first blog entry, ever. About me: I'm a SQL database project manager in the Asset Management business. The company purchases or manages pools of sub/non-performing ...
Many times, I installed SQL Server 2008 and failed with just the error message “Access Denied”. One of the cases I found is that my Administrator account doesn’t have SeDebugPrivilege especially when GPO policy is in effect. I still don’t understand why anyone should be admin but cannot debug things :( Check out the following links for more information: http://blogs.msdn.com/joaol... http://social.msdn.microsof... ...
Microsoft Community in Bangladesh proudly presents Microsoft Day @ Dhaka. This is a special day dedicated to all Microsoft technology professionals and students in Bangladesh. We will be having the best Microsoft community technologists from Bangladesh - Microsoft Most Valuable Professionals (MVPs) delivering sessions at the event. This technology marathon is a great opportunity to learn from the best and network with each other. Both Microsoft developers and networking professionals would find the ...
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 ...
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 ...
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 ...
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 ...
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 ...
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') ...
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... ...
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 ...
. BizTalk 2009: notorious Microsoft ADO MD.NET 9.0 and 10.0 When I was installing the BizTalk 2009 the Setup asked these prerequisite components: Microsoft ADO MD.NET 9.0 and Microsoft ADO MD.NET 10.0 I did not have Internet access and I had to manually search for these components. Seems it is not a simple googling. :) After painful search I've found them here: 1) ADO MD.NET 9.0: Page "Feature Pack for Microsoft SQL Server 2005 - November 2005" - http://www.microsoft.com/do... ...
Major Highlights Add Office 2007 File Extensions to default allowable file extensions in Host Settings Add reference to SQL Server 2008 to Install Wizard to make it clear that SQL Server 2008 is supported Moved Whats New Module/Page to Host menu as it contains content which is not applicable to the Administrator Corrected a problem with "Auto" installation option which would occur when using a non-dbo database user Inline updates to Text/HTML were not HTML encoded when stored in the database App_Browser ...
We have a number of upcoming IT and Business Application courses, and I am willing to make a deal! Email me to get signed up and to start the bargaining! 6215 Implementing and Administering Microsoft Visual Studio 2008 Team Foundation Server Apr 23 - 24 1327AI Citrix Password Manager 4.5: Administration Apr 23 - 24 Mastering SharePoint Server 2007 Administration Apr 20 - 24 6451 Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 Apr 20 - 24 6232 Implementing a Microsoft ...
April 21, 2009 3:00 PM - 5:15 PM Minnesota SQL Server User Group Drive Your Way to the DMV Speaker: Jason Strate, Digineer Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches a walk through of some of the more useful DMVs and a practical look at what they all really mean. ...
I wanted to make sure and draw attention to the effort that Brandon King in Harrison, Arkansas has given towards promoting this event. There are some major giveaways, and we will be arranging a carpool from Springdale to drive the 1:30 to give a good showing from the NWA DNUG crew. Details: Who: CLAUDIO LASSALA What: Details at http://odnug.org When: April 2nd 5:30 PM – 8:30 PM Where: North Arkansas College (Center Campus - Durand Center - Old Regions Bank Building), Harrison, AR Grand Prize Inspiron ...