Tag | SQL Server 2008 Posts

If you are installing SQL Server 2008 (or anything for that matter) and it won't let you continue for the following reason: Rule "Performance counter registry hive consistency check" failed. The performance counter registry hive is corrupted. What does this mean? This may mean that the value in HKEY_LOCAL_MACHINE\SOFTWARE... NT\CurrentVersion\Perflib under Last Counter and the last number value in Counter under HKEY_LOCAL_MACHINE\SOFTWARE... NT\CurrentVersion\Perflib\009 ...
For those of use with MSDN or Technet subscriptions, SQL Server 2008 is available for download now and you have probably heard this from multiple sources already. (is there an echo in here?) But for anyone that wants to work with the BI tools and who already has VS.NET 2008 installed you will need to wait until VS.NET 2008 SP1 is released (see http://support.microsoft.co... which will hopefully only be a few days. This is because BIDS in 2008 is based on the VS.NET 2008 SP1 build. If you ...
An RTM of MS SQL Server 2008 has finally been released today! Being an MCITP in SQL Server I will definitely give it a try especially when Microsoft is so nice with providing a free 180 Enterprise evaluation version that you can find here: http://www.microsoft.com/sq... I will be trying out first the data encryption capabilities. Update 1: The download come as an image, and It took quite a while to set the things up as I decided to try it on a non production machine ...
Considerations of Using Excel Data Sources in SSIS 2005 & Designing a Secure SQL Server 2008 Solution Date: August 19, 2008 Time: 4:30 PM - 7:30 PM Visit www.mnssug.org to register Topic One: Considerations of Using Excel Data Sources in SSIS 2005 Speaker: Mark Vaillancourt, Digineer When connecting to Excel, SSIS uses the Jet provider, which expects an Access database by default. Since Excel is not a database, nor does it tend to act like one, particularly with respect to data type consistency ...
Microsoft last week rolled out the first Release Candidate of SQL Server 2008. The RC0 bits are available for public download here. I have been playing with SQL 2008 RC0 for a few days already, and I would like to share my experience in this quick blog post. First of all, I have to warn you that my RC0 installation experience was not pleasant at all. If you are an early adopter of new releases like me, you will very likely run into the same troubles I had. Previous CTP releases of SQL Server 2008 ...
Unisys High-Volume ETL Techniques & SQL Server 2008 Policy-Based Management June 17, 2008 4:30 PM - 7:30 PM Visit www.mnssug.org for more information. Topic: Unisys High-Volume ETL Techniques Speaker: Bob Murphy, Unisys Unisys and Microsoft recently teamed to demonstrate that SQL Server 2008 can load 1 TB of Business Intelligence data in less than 30 minutes on an enterprise class system. In this talk we present the practical techniques, common tools, and queries used to discover and to eliminate ...
Imagine that every project in codeplex had to be decomposed into codeplex hosted unit tested functions which complied to some xunit standard - that would go along way towards code reuse, and move away from reinventing the wheel. worked on 2 Silverlight projects recently - see screenshots: and Last 3 months learned the following: NET Components revise – reread Yuval Loweys book – revised best mechanism for interface usage, delegates (circa .NET Framework 2.0), threading. The Interface stuff leads ...
I have been playing with SQL Server 2008 "Katmai" for quite a while. Although the new management studio designer looks almost the same as that of SQL 2005, there're actually many new features under the hood, and some of them are quite thoughtful. I have just been discovering these goodies here and there everyday. What I found today is also pretty interesting. By default, SQL Server 2008's designer no longer allows saving changes that require table re-creation. You will need to turn off this safety ...
Finally after spending hours building 3 servers (to do the job of the primary, mirror and witness) and installing SQL Server 2005 Enterprise with SP2 all sitting in the same domain. I was ready to try out Database Mirroring which arguably is one of the main reason people can justify the cost of purchasing the Enterprise edition. It should be easy, fill in the wizard and bob's your uncle, your trusty database is ready for instant uninterrupted failover goodness. In my case it all fell over with the ...
I finally got the nerve and installed Windows 2008 Server on my x64 laptop. It is rocking so far! It was a little confusing at first because there are lots of things turned off by default (it IS a server OS after all). But I found a post on Building a Windows 2008 x64 Laptop and it worked. First, it is NOTICEABLY snappier than Vista Business x64. Maybe because there is nothing set up by default. I almost cried when my Windows Live Writer told me it didn't support Windows Server OS and I thought I ...
I have vastly been neglecting my blogging. So as not to be outdone by Chris Koenig .... I was able to meetup with the organizers of the event, Jason Pluenneke, Curt Wolfe, Boyd Evert, & Dennis Berk several weeks ago. I am personally very excited about this new user group starting up. Partly because of my small part in helping them (one of my roles as the INETA Membership Mentor), but mostly because of my passion for databases. I'm really looking forward to what will be coming out of the group. ...
Microsoft recently announced a new version for BizTalk Server. It will be called BizTalk Server 2006 R3. Main aim of this version is to have parity with other related technologies and tools like .Net 3.5, VS 2008, SQL Server 2008 and WIN Server 2008. For more details: http://blogs.msdn.com/bizta... ...
Yesterday one of my colleague forwarded one email about new release coming up in biztalk server family. I am sharing that email content with you all. What did you announce? On Tuesday 22nd April 2008 we announce publicly that there will be an R3 release of BizTalk Server 2006, name: BizTalk Server 2006 R3. What is BizTalk Server 2006 R3? ‘R3’ is our planned release to enable customers to take advantage latest wave of 2008 products (Windows Server 2008, .NET Framework 3.5, Visual Studio 2008 and SQL ...
I am out at DevConnections this week and so far I have been impressed with the improvements and new features that are coming in the 2008 product line. I will post recaps of the sessions I attended as time allows... - Data Warehousing in SQL Server 2008 by Christian Kleinerman – this session focused primarily on the new features and performance enhancements that were made in the SQL engine. ETL Enhancements: 1. The new MERGE statement – this powerful new statement combines DML statements into one ...
WoW, it took a couple weeks to get everything in order; but we are excited to be hosting Heroes Happen {Regina} April 30th in Regina, Sask, Canada. I worked with the local IT Pro user group to create this night of community run technology sessions. What is interesting, is that we are holding 3 sessions concurrently, then we are running the same session again so attendees can participate in 2 of our 3 sessions. They layout will look like this Windows Server 2008; Room X SQL Server 2008; Room Y Visual ...
Finally, the long awaited IntelliSense arrived with the SQL Server Katmai. Not sure if it is because SQL 2008 is still in CTP, but the IntelliSense is nowhere near the RedGate's SQL Prompt. But if your evaluation of SQL Prompt has run out and you don't have a license, the SQL 2008 IntelliSense should be good enough for your day to day work with the query analyzer. To see the IntelliSense and other cool IDE enhancements in action, download the SQL Server 2008 "Katmai" Feb 2008 CTP here. Here are a ...
The SQL Server 2008 CTPs came out after Visual Studio 2008 was released. There's a compatibility issue when you try to open a database connection to SQL 2008 from the VS 2008 designer tool. You may receive the following error message: “This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.” This happens when you select the the server, the database, and then click on "Add" to create the database connection. Fortunately, Microsoft released a CTP to address ...
Microsoft EDC 2008 Website is UP. You Can Click Here To Register. EDC will be April 13 and April 14 - In Cairo International Conference Center (Agenda) But Watch out. The Attendance Fee is 100 EGP. There're Invitations Available. An Invitation Code is required to register, and you get that by calling the guy mentioned in the right top part of the registration page, and you can call his mobile phone only on Egypt working hours. I've written about Microsoft EDC 2008 (Egypt Developers Conference 2008) ...
So, Mike Wells was kind enough to pass this information on to me so I will do the same… Register to Be the "First to Know" and Save on Your Exams (Worldwide) Know when Visual Studio 2008 and SQL Server 2008 exams are available and save 40% on selected exams in your track. Try Your Choice of Microsoft E-Learning for Free (U.S. only) For a limited time, you can try Official Microsoft E-Learning for free! Choose from 1,400 hours of IT professional and developer content covering all of the latest technology ...
I just spotted an interesting post on the Analysis Services forum. It was titled "Analysis Services Team Update" and was posted by Ariel Netz, Group Program Manager for Analysis Services. He starts off with .. "I could never understand people’s fascination with blogs." ...which just begged to be blogged about. :) In it he talks about how Analysis Services is looking for the SQL Server 2008 "Katmai" release "In all honesty, things are looking good. In fact, looking very good (relative to where we ...
It's very nice to know that the launch event is not merged with EDC 2008, but comes before it. The 2008 launch event covers VS 2008, Win 2008 and SQL 2008. It'll be held March 24th @ Intercontinental City Stars Hotel (Register Now) The agenda: Time General Sessions 09:00 AM - 10:00 AM Registration / Coffee 10:00 AM - 11:15 AM Keynote Speech 11:15 AM - 11:45 AM Break Infrastructure Track Database & Development Track 11:45 AM - 12:30 PM Windows Server 2008 Overview Breakthrough software development ...
As Microsoft readies Windows 2008 for launch coupled with SQL server 2008 launch and the re-launch of Visual Studio 2008 ?? I am left feeling a little uneasy... When Visual Studio 2008 hit the streets it quickly became apparent that it was incompatible with a number of other products not least BizTalk 2006 R2 on recently launched!!! It is now also clear that Microsoft aren't supporting BizTalk 2006 R2 on Windows Serve 2008 either and of course it goes without saying that BizTalk will not support ...
I was asking myself this question recently and while I could not find anything in Books Online, it is not too hard to figure this out for ourselves. The following comparison was run between SSAS 2005 SP2 and the February CTP (CTP6) of SSAS 2008. I really love the way that you can discover the metadata in SSAS, all I had to do is to run a DISCOVER_SCHEMA_ROWSETS XML/A command against each server and then use XMLNotepad 2007 to compare the resulting XML. In the SQL Server 2008 you should find that ...
Just a quick follow-up on Chris Webb's recent post about the release of CTP6 for SQL 2008 and CU6 for SQL 2005. Chris mentions that there is still no suggestion that SP3 for SQL Server 2005 is in the works despite having released 6 cumulative update packs. If you would like to see a Service Pack 3 you can add your voice to the push for SP3 by voting for it on connect here: https://connect.microsoft.c... The other interesting thing about the release ...
Heroes Happen Here !!! Yeah that is the theme we chose for this launch. After all, arent you guys the Heroes, going out and solving the customer problems that keep creeping in day-to-day? I had in my earlier post talked about the Visual Studio 2008, SQL Server 2008 and Windows Server 2008 and the sessions I am delivering over the same. Also, we have a community launch that happens across 14 cities. The agenda for the same should be out shortly at the Heroes Happen Here website, keep checking for ...
Yes, we would launch three in a row! Visual Studio 2008, Windows Server 2008 and SQL Server 2008 Launch would be happening on March 4th, 5th and 7th at Bangalore, Mumbai and Delhi respectively. This launch marks one of the biggest launches we have ever done and we are working hard at it. There are a flood of events planned starting with our pre-launch webcast series happening starting next monday. You can register for the same at http://www.microsoft.com/in... (check the Visual Studio 2008 ...
Just thought I'd give you an idea of some of the content that will be presented at the Raleigh Code Camp 2008 this Saturday. Jim Wooley - What's new in VB 9 Richard Campbell - Performance and Scalability Mark Dunn - BizTalk Miguel Castro - How to Work with Recruiters Rob Zelt - Silverlight Bill Jones - LINQ in VS 2008 Josh Carlisle - Customizing MOSS Publishing Brian Gough - Wrapping a User Control in a SharePoint Web Part Josh Carlisle - SharePoint for ASP.NET Developers Kevin Boles - SQL Server ...
Today was .NETwork usergroup second gathering. The usergroup is the first and only large/effective "offline" usergroup in Egypt (although there're many others in INETA). They had a great success in their first gathering when they brought Steven Forte to talk about SQL Server 2008 new features for developers and ASP.NET MVC design pattern. I had a detailed post about it in my GWB blog at that time. Check it out for details. Background: First To Second Gathering (Warning: Boring Part!!) The .NETwork ...
Here are some more FREE Partner Partner Training Labs: Microsoft SQL Server 2008 Virtual Training (6 parts) What's New in SQL Server 2008 for Database Administrators Implementing Change Data Capture (CDC) in SQL Server 2008 Working with the New DATE Data Type in SQL Server 2008 Administering Servers by Using Declarative Management Framework (DMF) Policies Learn How to Build Occasionally Connected Applications Authoring Reports Using Microsoft SQL Server 2008 Reporting Services Microsoft Visual Studio ...
Inspired by Scott Hanselman and his relation from Visual Studio 2008 InstallFest in Portland Polish user groups started the series of events in Poland. First such event was organized by Szymon Kobalczyk in Kraków and you can read about it on his blog. I was one of the organizers of the event so I cannot tell I liked it because I loved it. It was a huge fun for me. I believe it was a great success. At the moment there was a second InstallFest in Wroclaw. I was there, and I think it was also well organized. ...
To all Sql Server devlopers .DBA's etc.. I came across this article describing about some useful and new datatypes in SQL SERVER 2008 Like date, time, datetime, datetime2 and datetimeoffset datatypes You can get to it here .Although the article is based on SQL Server 2008 - Nov CTP but lets hope it will be in the finished product. Hope it will make your jobs easier ...
Last week I was present at the MCT Summit in Berlin. Had fun, saw great presentations. A big applaus was given to Marcel De Vries for his LINQ presentation. Which was deserved, this was the best LINQ presentation I had ever seen. Altough the summit was more focused on ITPro and SQL stuff I had a good time. I was introduced by MCT collegeaus to the world of virtualization and Microsoft Hyper-V. Some 400 MCT’s from the EMEA region where there. About 10 belgians quickly joined together and started thinking ...
As noted today, you can now register for the Launch of Visual Studio 2008, SQL Server 2008 and Windows Server 2008. You can find the closest event to you from here. For all you DC folks like me, our event is March 25th and you can find that registration information here. Here is the basic information: Take a test drive Come to an event and test drive Windows Server® 2008 operating system, Microsoft® SQL Server® 2008, and Microsoft Visual Studio® 2008. Meet the experts Enjoy hands-on labs, face-to-face ...
Just noticed that Microsoft SQL Server 2008 has its own learning portal on microsoft site at http://www.microsoft.com/le... The following is some of the content to know and learn about Sql Server 2008. Get ready for Microsoft SQL Server 2008 now. Special Offers: * Free e-book offer: Get free excerpts from Introducing SQL Server 2008 by Peter DeBetta. * Free e-learning: • Collection 6187: What's New in Microsoft SQL Server 2008 (includes three free clinics) * Classroom training: ...
I just signed up the Philly.net Code camp. Did you? There are only 400 seats available! Here are the details: Our first installment of the 2008 Code Camp series will be held at the DeVry University campus in Fort Washington, PA on Saturday, January 12 from 8:00-5:30. Please register on our web site.-->Detailed directions are on the DeVry web site. Lots of code, just say no to slides! 9 hours 48 sessions (8:00, 9:30, 11:00, 1:00, 2:30, 4:00) 8 tracks 400 seats with tables (laptops welcome) Free breakfast, ...
Last Tuesday night witnessed a relatively new kind event held in Microsoft Egypt building @ smart village. It was said to be "announcing dotNETwork user group" which I thought was some Microsoft Egypt initiative for a new offline user group model of developer community. I was so excited about so, and it was even better! The Idea The dotNETwork group is just am offline user group that's done right. It just happened to have Microsoft Egypt host the group gathering, as this is the hardest issue to maintain. ...
Sadly, this is Microsoft's official position. http://forums.microsoft.com... From MVP Teo Lachev: "VS.NET itself doesn't support BI project types. They get added to VS.NET when you install the SQL Server client tools. Since SQL Server 2005 client tools don't know anything about VS.NET 2008, nothing gets integrated with VS.NET 2008. I believe that working with SQL Server 2005 projects will require you stick with BIDS 2005 or VS.NET 2005. That's because when ...
I guess, there are too many changes in sql server 2008 to put them in one part, so i am trying to capture them in parts. Here is the part 1. http://geekswithblogs.net/Sreeblog/articles/117576.aspx
SQL Server 2008 Product Overview: For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support their data platform vision: mission-critical enterprise data platform, dynamic development, relational data, and business ...
Quoting Microsoft Connect Email: The Microsoft SQL Server Team is proud to announce SQL Server 2008 Katmai November CTP! Many of you have anxiously waited for this day. The SQL Server Connect Team in conjunction with the SQL Server Product Team are proud to announce the release of the November CTP of SQL Server 2008 Katmai. We know, we know. Where are the bits? Here is a direct link to the download on the Download Center. Yes, we have installers and media ISOs available. Along with x86, x64, and ...

The November CTP for SQL Server 2008 has been released. You can get the ISO downloads from here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en

D

BI has always been a rich vain of the IT industry. Rich because there was so much excellent competition. The really cool thing about many BI products was that they effectively could bolt onto most of the popular databases so it was pretty straight forward to chop and change and to also build your capability into one tool! The larger IT vendors however where not leaders in the BI space. The leader were the specialists, the experts. Now sadly the bigger BI vendors and market leaders are nearly all ...
TechEd Developers is really giving us an opportunity to put everybody together – board members, volunteers, the speakers, users who would actually go to meetings, user group leaders – and to relate with Microsoft and vendors as well. Our booth is based next to the MVP and RD booths completing the "TechEd Community Lounge" and allowing us to network with a majority of MVP and RD representatives and program members. Our booth (aka INETA POD) is the place where attendees can come and meet the current ...
This post is mainly for those people that were at my presentation at this years SQL Down Under Code Camp. I said that I would post the slides and the sample project (there are links at the end of this post) and here they are. a Powerpoint 2007 version of the presentation [link 2] a Powerpoint 97-2003 version of the presentation [link 2] and the sample project I was using for all the demos [link 2] Note: Some of the demos are using the trash destination and the data generation data source from www.sqlis.com ...
Yes, we have Windows Server 2008 coming. Yes, also SQL Server 2008 and Visual Studio 2008, the .NET Framework 3.5, and more - but probably one of the more exciting new items to come at this same time is IIS 7. As Scott Guthrie states in his recent blog post on IIS, this is a major update to the technology. IIS 7 will allow for a plug-in architecture and allows you to take out all the pieces of the IIS stack that your applications don't need. It also allows you to build your own extensions and plug ...
"Good morning everybody, you're tuned to Computers 2K7 on sports radio 850 The Buzz" and so began this mornings show as we do every Sunday morning from 8am - 10am here in Raleigh, NC. You can download the show from the show's website. How to Print Contents of a Directory Here's a link to the Microsoft Word MVP FAQ Site that contains the steps to print the contents of a directory. Scroll down and check out the "If you don't have Outlook" section. That page is contributed to by fellow Microsoft MVP ...

Big news....

Visual Studio 2008 ("Orcas"), Windows Server 2008 ("Longhorn"), and SQL Server 2008 ("Katmai") will all be shipping on February 27, 2008 according to Kevin Turner, Microsoft COO at the Worldwide Partner Conference 2007.

Have a day. :-|

It appears as though we will have a new version of SQL Server 2008 next February 27th. This is well ahead of what my sarcastically titled post on SQL Server 2008 predicted. So much for my career as a technical psychic... It will also be the launch for Visual Studio 2008 and Windows Server 2008. That should be one heck of a party. Hopefully I can find some launch event that will be serving free beer (preferably a nice stout or porter) ...

Although the big buzz is around VS.NET 2008 launching in the new year, there's also an updated database platform as well!

Make sure to check out the SQL Server 2008 page on Microsoft's website for updates:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

D

Windows Server® 2008, Visual Studio® 2008 and Microsoft SQL Server™ 2008 will launch together at an event in Los Angeles on Feb. 27, 2008, kicking off hundreds of launch events around the world. As the next wave of innovation from Microsoft’s Server and Tools Business, these three products will provide a reliable and security-enhanced enterprise platform, serve as the foundation for the next generation of Web-based service applications, and broadly support virtualization and business intelligence. ...