Tag | SQL Server 2008 Posts

I needed to downgrade SQL Server 2008 from Enterprise to Standard on a Server 2008 machine, and and kept getting this error when trying to uninstall: SQL Server Setup has encountered the following error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created It turns out the setup utility really doesn't like having ANY other windows open - I closed the Server Manager window and it worked ...
Wow. There were a stack of announcements made at the key note. So I thought I would try to jot then down while I'm just waiting for my first technical session a Deep Dive on PowerPivot to start. The Parallel Data Warehouse Edition of SQL Server 2008 R2 has been released to manufacturing, there was a demo with a query over an 800 Billion record table that was returning in 19 seconds on a 40 node parallel cluster. Yahoo came up and talked about an SSAS cube of theirs, it's 12TB in size and they load ...
Turns out you can't just move a TFS warehouse/cube from SQL Server 2005 to 2008... Once performed we got the following error on the TFS app server tier - when we tried to update/process the cube (both manually and via the TFS scheduler service): Detailed Message: Failed to load adapter Microsoft.TeamFoundation.Wa... Exception Info: \n Microsoft.TeamFoundation.Se... Error encountered when creating connection to Analysis Services. Contact ...
With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2. I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error: Figure 1 - Unable to save table schema changes error With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would ...
Back in April I began to work with Oracle again after a multiple year absence from doing so. So naturally I decided I would install Oracle on my home system so I could reacquaint myself with it. That proved to be more difficult than I expected. I was able to get Oracle 10g Express downloaded and installed but could not connect to it. So, to save someone else some of the grief I went through let me go through the final sequence of steps that resulted in a solid working Oracle development environment. ...
[Source: http://geekswithblogs.net/E... * This post is pure speculation, not based on any special insider knowledge, so don't get too excited * BizTalk 2010 has RTM'd, and the Developer Edition is now free. It seems an unusual move to give it away, with the price point of other BizTalk licences. Enterprises who actively use BizTalk will have an IT budget that will probably stretch to MSDN subscriptions for their dev team; conversely, SMBs who aren't prepared to spend £500-odd on a Developer ...
On Sept 29th, Microsoft made SQL Server 2008 SP2 available for download. Here are the KB article with a description of the fixes and the links to download SP2. KB 2285068 : List of the bugs that are fixed in SQL Server 2008 Service Pack 2. SQL Server 2008 SP2 SQL Server 2008 SP2 Express SQL Server 2008 SP2 Feature Packs SQL Server 2008 SP2 SSRS Add-in for Microsoft SharePoint Technologies SQL Server 2008 SP2 Upgrade Advisor ...
The BizTalk Server team announced today that BizTalk Server 2010 has RTMd. That's a relief, as my reputation was on the line regarding RTM before the end of the month. Just this Tuesday I confidently told a prospective customer to expect an imminent announcement. I've been playing with BTS 2010 for a little while now. It has been my constant companion while writing several chapters for the forthcoming BizTalk Server 2010 Unleashed. It looks great. As well as bringing BTS up to date with Visual Studio ...
Problem As the DBA, you need to determine if there are any databases in your production environment which have not had a full backup in the last 24 hours. In this tip we cover the step by step process for setting up a policy to identify all the databases which are not backed up in the last 24 hours. Solution Database Administrators can use Policy Based Management (PBM) to identify databases which have not backed up in the last 24 hours. You can follow the below steps to create and evaluate the policy. ...
This is a quick post … after a lot of challenges with a recent deployment of BizTalk Server 2009, it is important to keep the following very much in mind. BizTalk Server 2009 and SQL Server 2008 R2 are not the best match, work with SQL Server 2008 with SP1. .NET 4.0 has the ability of breaking a not yet configured BizTalk deployment. Where? Enterprise SSO configuration will refuse to talk to the SSODB (mind you, the process will create the DB). There are fixes for this last one, just make sure you ...
The road to learning is such an awesome thing! Yesterday, while browsing the MSDN Forums, I came across some people having frustration with SQL Server Express, Visual Web Developer 2010 and the Web Installer. The Issue After installation, if you create a New Website with VWD 2010, follow the steps below: Access the Web Site Administration Tool (Solution Explorer Toolbar) Click on Provider Configuration (Once the Web Site Admin Tool opens) Click on Select a single provider for all site management ...

Came across this excellent demos and HOLS here  for SQL Server 2008 R2
Enjoy

Introduction Let’s pretend you are being interviewed for the DBA or T-SQL Programmer job and are asked a question like this: What is the precision of the GETDATE() and/or SYSDATETIME() function? If your answer is …: Well, GETDATE() function returns DATETIME data type so the precision is 3.33 ms, the SYSDATETIME() function returns DATETIME2 data type so the precision is 100 ns. …read on to find out if you are correct. Testing precision of GETDATE()… In order to find out what the correct answer should ...
I recently received an email from a self-described “old school” developer who had attended one of our Visual FoxPro classes from a number of years back (2001?). He had some questions about working with SQL Server 2008 and T-SQL. He asked about a number of built in VFP/xBase functions that don’t have a counterpart in T-SQL, specifically some that deal with dates and strings. I too went through that migration waaaaay back when and have since created some UDFs that reproduce some familiar and very useful ...
A while back it was clear: Roses are red, violets are blue … if you are a dev you use Visual Studio. Now: Roses are blue, violets can be red … if you do SharePoint,Visual Studio is the right tool for you. I am not a poet, nor do I pretend to be one on TV. But I have invested time in fine tuning virtual machines and physical deployments in figuring out what goes where and what is needed. We see dependencies of every type, in every place and every product pretty much. If you are doing SQL Server 2008 ...
Today I put out a new release for PowerSSAS. This release adds the following new cmdlets: backup-ASDatabase clear-ASCache get-ASConnection get-ASRole restore-ASDatabase It also includes a Powershell v2 .psd1 module file and includes the option to just download a zip file which can be copied into a folder your modules folder. So you can now install PowerSSAS without needing to have admin privileges. There are instructions on installing PowerSSAS as a v2 module here. I have also done some preliminary ...
I was recently on a project that required me to move SharePoint content to SQL Database. As I searched the best way to do this, I thought of a timer job that would run nightly and move the data to SQL, a co-worker who is a SQL expert suggested I use SSIS to move the data over. I started searching online and came up with a couple of options the most notable being the technet article. The problem with the example on technet is that it uses a custom connector that connect one Document library or List ...
My reading focuses very much around the technologies I work with. During TechEd 2010 North America I found some very good reads that are helping me prep for the new things out and also to establish recommended practices in their implementation. Here are the titles. It looks like a spot for Wrox, but they have hit hard and early with great content, and some friends happen to have participated in their creation ...
I was thrilled to find a free ebook: Introducing Microsoft SQL Server 2008 R2,by Ross Mistry and Stacia Misner The purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both the new and the improved in the latest version of SQL Server. Great info and they are sharing it for free. Feel free to follow the authors and ask quesitons on Twitter. @RossMistry @StaciaMisner Here is the link to the book: http://blogs.msdn.com/b/mic... ...
It’s been more than a month since SharePoint 2010 RTMed. And a lot of people have downloaded and set up their very own SharePoint 2010 development rigs. And quite a few people have written blogs about setting up good development environments, there is even an MSDN article on it. Two of the blogs worth noting are from MVPs Sahil Malik and Wictor Wilén. Make sure that you check these out as well. Part of the bad side-effects of being a geek is the need to do the technical stuff the best way possible ...

Recently participated in a conversation that asked about what thoughts were around the advantages of SharePoint 2010 and SQL Server 2008 R2.

I guess we can really dive in by exploring a document on TechNet by the name of SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper)

Over the last couple of days we have seen posts and “rumors” of the Beta availability. There was a link to the bits from the Download Center, but then they were not. Documentation for it is available now at: BizTalk Server 2010 Documentation – Beta Microsoft BizTalk Server 2010 ESB Toolkit Documentation – Beta BizTalk RFID Server 2010 and BizTalk RFID Mobile 2010 Documentation – Beta But what about the bits?!? From the Biztalk Server Team blog: “We will be announcing the public Beta of BizTalk Server ...
From the KB Article ID: 981355 “Cumulative Update 1 for Microsoft SQL Server 2008 R2 RTM contains only hotfixes that were released in Cumulative Update 5, 6, and 7 for SQL Server 2008 Service Pack 1 (SP1). Cumulative Update 1 for SQL 2008 R2 RTM is only intended as a post-RTM rollup for Cumulative Update 5-7 for the release version of SQL Server 2008 SP1 customers who plan to upgrade to SQL Server 2008 R2 and still keep the hotfixes from Cumulative Update 5-7 for the release version of SQL Server ...
What is available to us through those links? Have you taken the time to explore and identify what could be useful to you? One of many gems that has come to my attention is the possibility of provisioning SQL Server to work in an image based environment (hint: Virtualization Template perhaps?!?). Planning: Includes requirements information, documentation, how to guides, online documentation installation and other tools. Among the other tools you will find the System Configuration checker and The Upgrade ...
At my previous employer, when developing for BizTalk Server 2004 using Visual Studio 2003, we made use of separate development and deployment environments; developing in Visual Studio on our client PCs and then deploying to a seperate shared BizTalk 2004 Server from there. This server was part of a multi-server Standard BizTalk environment comprising of separate BizTalk Server 2004 and SQL Server 2000 servers. This environment was implemented a number of years ago by an outside consulting company, ...
For a long time when creating images for my development environment, I had to install the OS and then sysprep. Only after that would I then create a differencing drive/image that would have SQL Server. So, the thought of having a base/core image for SQL Server as a template was not easily done. Well, how do things change? SQL Server 2008 R2 gives us the option now. Check this HOW TO provided on the library docs at TechNet. http://technet.microsoft.co... ...
Geekswithblogs.net - May 2010 Newsletter Was your newsletter messed up? If the first newsletter we sent was all white with links all over the place, I apologize. We haven’t sent a newsletter in quite some time and I forgot the rules of theming for email clients. TechEd 2010 New Orleans - Who is coming? John and Jeff will be at TechEd 2010 New Orleans for a short time to pass out shirts to our bloggers. These are the standard GWB shirts you see some of our other bloggers wearing and one could be yours ...
Yesterday, Microsoft held its flagship launch event for Office 2010 in Manhattan. Today, the Redmond software company is holding a local launch event for Visual Studio (VS) 2010, in Brooklyn. How come information workers get the 212 treatment and developers are relegated to 718? Well, here’s the thing: the Brooklyn Marriott is actually a great place for an event, but you need some intimate knowledge of New York City to know that. NBC’s Studio 8H, where the Office launch was held yesterday (and from ...
Sometimes an application needs to have every last drop of performance it can get, others not so much. We’re in the process of converting some legacy Visual FoxPro data into SQL Server 2008 for an application and ran into a situation that required some performance tweaking. I figured the Making Microsoft SQL Server 2008 Fly session that Yavor Angelov (SQL Server Program Manager – Query Processing) presented at PDC 2009 last November would be a good place to start. I was right. One tip among the list ...
During the last year, we (Tellago) have been involved in various business intelligence initiatives that leverage some emerging BI techniques such as self-service BI or complex event processing (CEP). Specifically, in the last few months, we have partnered with Microsoft to deliver a series of events across the country where we present the different technologies of the SQL Server 2008 R2 BI stack such as PowerPivot, StreamInsight, Ad-Hoc Reporting and Master Data Services. As part of those events, ...
Last October I learnt my company wanted to put together a new blog/social networking policy. I decided that out of respect for my employer I wouldn’t blog until this was sorted out. This was perhaps was an easy decision to make as I was separating from my ex-wife at the time and frankly needed the time to concentrate on other things. So now the company has a brand new policy and I’m back into the dating game I thought I would blow off the cobwebs and get back to what I enjoy doing. First and foremost ...
Microsoft is planning to release the second edition of SQL Server 2008, the new edition will named SQL Server 2008 R2 due to be released by May 1st 2010. Amongst the change on the edition is pricing which is anticipated to go up by 25% for the Standard Edition and about 15% for the Enterprise Edition. As for the features, there are some very cool additions including PowerPivot for SharePoint, Master Data Services and Multi-Server Administration. There is also enhancements on the Database Engine, ...
Fellow Blog Readers: I figured I use my first blog post on GeeksWithBlogs to introduce myself. I recently relocated from Long Island, NY to South Florida where I joined a local company as Software Engineer specializing in technologies such as C#, ASP.Net 3.5, WCF, Silverlight, SQL Server 2008 and LINQ, to name a few. I am an MCP and MCTS ASP.Net 3.5, looking to get my .Net 4.0 certification soon. Having been in industry for a few years so far, I figured I would share with you my take on the importance ...
Microsoft has renamed BizTalk Server 2009 R2 as BizTalk Server 2010, and is now telling customers that the evolution of the product recommends it as a major version versus a minor update. BizTalk Server 2009 R2 was designed mainly to bring to the table support for the company’s latest technologies, including Windows Server 2008 R2, SQL Server 2008 R2 and Visual Studio 2010. Following is list of key capabilities added to the release 1. Enhanced trading partner management that will enable our customers ...
[Did I overdo the use of FREE in the title? :-)] April 12th to 16th is Microsoft Tech Days – 5 days of sessions on Visual Studio 2010 through to Windows Phone 7 Series. Many of these days are now full (Tip - Thursday still has room if rich client applications is your thing) but the good news is the development community in the UK has pulled together an awesome series of “fringe events” during April in London and elsewhere in the UK. There are sessions on Silverlight, SQL Server 2008 R2, Sharepoint ...
Sorry for the rather lengthy post here. I get asked this all the time so I decided to post it…Visual Studio 2010 editions will be available on April 12, 2010. Product Features Professional with MSDN Essentials Professional with MSDN Premium with MSDN Ultimate with MSDN Test Professional with MSDN Debugging and Diagnostics IntelliTrace (Historical Debugger) Static Code Analysis Code Metrics Profiling Debugger Testing Tools Unit Testing Code Coverage Test Impact Analysis Coded UI Test Web Performance ...
MIX day 1’s keynote was all about Windows Phone 7 (WP7). MIX day 2’s was a reminder that Microsoft has much more going on than a new mobile platform. Steven Sinofsky, Scott Guthrie, Doug Purdy and others showed us lots of other good things coming from Microsoft, mostly in the developer stack, that we certainly shouldn’t overlook. These included the forthcoming IE9, its new JavaScript compiling engine and support for HTML 5 that takes full advantage of the local PC resources, including the Graphics ...
Hello everyone, long time no blog… I’ll try to get back in the game soon but with 2 customer and user group and life in general let’s just say I’m busy. In the meantime I’m passing along this great offer. Microsoft Visual Studio 2010 Professional will launch on April 12 but you can beat the rush and secure your copy today by pre-ordering at the affordable estimated retail price of $549, a saving of $250. If you use a previous version of Visual Studio or any other development tool then you are eligible ...
For Visual Studio 2010 Professional Microsoft Visual Studio 2010 Professional will launch on April 12 but you can beat the rush and secure your copy today by pre-ordering at the affordable estimated retail price of $549, a saving of $250. If you use a previous version of Visual Studio or any other development tool then you are eligible for this upgrade. Along with all the great new features in Visual Studio 2010 (see www.microsoft.com/visualstu... Visual Studio 2010 Professional includes a 12-month ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...