Tag | SQL Server Posts

Yes, I know. I never post to my blog. I am not making a conscious effort to be more active. blah..blah..blah. I don't want Hal Hayes to rag on me during any more caparea.net user group meetings. Jim Duffy gave an enthusiastic presentation on what's new in ASP.Net 2.0. I haven't heard Jim speak before, but had heard that he was quite the entertainer. He did not dissapoint. If you get a chance to here Jim speak or take some of his training course at TakeNote, you won't be dissapointed. Thanks again ...
Unless you have been hiding under a rock you have seen the numerous articles out there pitting Microsoft against Google. A think a lot of the fools buying this bunch of crap are Microsoft haters still lamenting the downfall of Netscape and still wondering why Apple isn't the corporate desktop standard. I know rich web apps, software as a service, and open source is a threat to Microsoft's current marketshare but Office, Windows, IE, SQL Server, Visual Studio, etc, etc, etc are safe for a very long ...
These days I am conducting trainings as a part of "Microsoft Touchdown " for VS 2005 (Whidbey) and SQL Server 2005 (Yukon) Launch program. These trainings are being conducted by Microsoft Pakistan at a training fascility provided by Kalsoft's KalAcademy. Participants have been invited from Microsoft ISV partners. I am conducting these sessions on the behalf of Kalsoft which happens to be employer and Microsoft's Gold Certified Partner.Yesterday I conducted two sessions. One on SQL Server 2005's Web ...

Where, I don't know.  It isn't yet on MSDN.  Robert Scoble said that it (and SQL Server 2005 + BizTalk 2006) are done in Three VPs on Channel 9.  Tonight is the shipping party.

Congratulations to all of the teams at Microsoft that have been working on this!

So in the same vein, there is also a page regarding MS Issues, start here or pick a link below? Microsoft Updates and Information (Relating to Citrix and Terminal Services) This is the central location for Microsoft and Terminal Services related resources that specifically apply to Citrix administrators. Microsoft Updates Known Issues with Microsoft Windows 2003 Service Pack 1 Users Unable to Connect to Presentation Server After Installing Windows Server 2003 Service Pack 1 Unable to Connect with ...

This is a bookmark for myself as much as anything else, but here is Raymond Lewallen's script for generating a text based dependency report for a SQL Server database.

Sql dependency report from query analyzer

I recently had the need to insert some binary data that was encoded as Base64 into a SQL Server image column. Since I was using BizTalk, I was hoping it would be relatively straight forward - I was wrong. There's a bit of information here on how I came to this problem and some BizTalk stuff, so if you just want the solution, jump to here. The Background I was using BizTalk to pull a record from one SQL Server, do some processing on the data, and then insert the processed record into another SQL Server. ...
SPS SP 2 has been released. SPS can now: Support for running on 64-bit machines in 32-bit emulation mode Support for Reverse Proxy and Alternate URL support Support for IP-Bound virtual servers Support for off-box SSL termination Support for SQL Server 2005 Kerberos-enabled by default Download @ http://www.microsoft.com/do... NOTE: Before you install SharePoint Portal Server 2003 SP2 on a computer that is running Microsoft Windows Server ...
For sometime now my home PC hasn’t really been behaving itself. It’s been slow in parts and mysterious errors have surfaced in commonly used applications. A whole bunch of those repair and optimisation utilities have been thrown at my PC over the years but the simple fact was that the machine was suffering from to much clutter. I had released a while ago that I had never completely rebuild my machine from scratch I had always upgraded my PC with each new version of Windows from 98 to ...
It is just a month before the official launch of VS2005 and SQL Server 2005 here in Malaysia. I just realize that the are a lot of new features from the VS2005 beta 2 the RC release. I hope there should be no problem to port my apps into the final realease of VS2005 from the current version.I'm still seeking for new cool UI control for my app showcase nextmonth. Seems like Genghis or MagicUI did not fit my requirement.With the delay of Windows Foundation Server until next year, I'm thinking to use ...
We are here at Malaysia also getting hot to wait for the official launch of the VS 2005 and SQL Server 2005. Here the official launch will be held on 15th November 2005 at the KL Convention Center. According to some folks at Microsoft Malaysia, they have invited some of the very high Microsoft 'executive' from to come at the launch. While some of the Microsoft partner will be participate in the VS 2005 and SQL Server 2005 showcase, including my company. We have already port our apps into the .NEt ...
Whew! In addition to the Professional ASP.NET 2.0 book I have coming out this month, I also co-authored two other books coming out this month: Professional C# 2005 & Professional VB 2005 Both these books were reworked for the lastest release of both of these languages. The table of contents for the Professional C# 2005 is as follows: PART I: THE C# LANGUAGE.1. .NET Architecture. 2. C# Basics. 3. Objects and Types. 4. Inheritance. 5. Operators and Casts. 6. Delegates and Events. 7. Memory Management ...
From TheServerSide.NET: Microsoft has released Service Pack 2 for Microsoft Office 2003. This service pack contains significant security enhancements, in addition to stability and performance improvements. Also included is support SQL Server 2005 in InfoPath and SharePoint 2003. Some of the features included are: Improved Security – SP2 includes an enhancement to Outlook to help prevent “Phishing.” Outlook has also improved the handling of “Junk” email. Junk messages ...
I went to a TechNet briefing today on SQL Server 2005 by Matthew Hester. Matt was an excellent speaker and showed us some really great stuff that is coming in SQL Server 2005. Who knew SQL Servers were pessimistic and optimistic? Jaded perhaps, but . . . Anyway, he did a great little slide on physical security which he highlighted with video #5 from Trunk Monkey. I had never heard of them before this so I had to roll on out to the site and check it out. Videos 4 and 5 had me rolling on the ground. ...
The top 5 reasons to... pre-register for the Visual Studio 2005 & SQL Server 2005 Product Launch Event (being held by GC.NUG on November 10th...) #5 If you don't, we won't have ANY attendee materials prepared for you. #4 That means no DVDs... #3 No Hands on Labs... #2 Possibly not enough pizza... #1 You won't be eligible for the big drawings! We have 5 (FIVE) FULL COPIES of Visual Studio 2005 and SQL Server 2005 to give away at this event. If you don't pre-register, your name won't be in the drawing. ...
There are a number of different methods available for backing up your Analysis Services 2000 database. I recently pulled together this vbscript for automating the calling of msmdarch.exe and thought I would post an article on the full range of backup/restore options. Analysis Manager This is the method that most people are aware of. It is fine for migrating databases, or for restoring databases. But for archiving/backing up databases you really want something that can be automated. If your database ...
Pro C# 2005 and the .NET 2.0 Platform, Third EditionBy Andrew TroelsenPublished September 2005ISBN: 1-59059-419-31032 pp.$59.99http://www.apress.... Pro SQL Server 2005By Thomas Rizzo et al.To Publish: October 2005ISBN: 1-59059-477-0 550 pp.$49.99http://www.apress.... ...
Registration for GC.NUG's Microsoft Visual Studio 2005, SQL Server 2005 Product Launch Event is now open.

Click here for more info.

WSS SP 2 has been released. WSS can now: Support for running on 64-bit machines in 32-bit emulation mode Support for Reverse Proxy and Alternate URL support Support for IP Bound virtual servers Support for off-box SSL termination Support for SQL Server 2005 Support for ASP.NET 2.0 Download @ http://www.microsoft.com/do... NOTE: Windows SharePoint Services SP2 should not be used until Microsoft Office SharePoint Portal Server 2003 Service ...
The hell of custom configuration sections Configuration is changed somewhat, none of our custom configuration section code worked anymore. I’m not sure if this one was for the better. Implementing custom sections in configuration files have got to be one of the most painful experiences I have had coding since Method ~ of ~ failed in the old DCOM days. How come it takes 200 lines of code to read 20 lines of configuration in an xml file? Thanks to Reflector from Lutz Roeder I disassembled the ...
Coming to the Greater Charleston .NET User Group on November 10th... All attendees will receive the following: Attendee DVD which includes all the slides/code from the Developer and IT Professional training plus additional content from Visual Studio, SQL Server, BizTalk Server, Windows Server, Mobility, Patterns & Practices, and many others. VPC images of hands on labs providing over 50 self-paced training sessions on Visual Studio, SQL Server, BizTalk Server, Mobility, Security, and many others. ...
I got waaay behind on reading my "MSDN Just Published" feed. So after browsing through the > 100 articles mentioned (yes, I "filtered" them via headlines first), I found a few that sounded relevant and interesting. I'll throw them at you randomly: Common ASP.NET 2.0 Conversion Issues and Solutions Windows Vista - get the Beta Coding4Fun - Some Assembly Required: Is that you? Writing Better Software for Cool USB Hardware Coding4Fun - In the Box: Giving Computers a Voice MSDN TV: Intelligent Applications ...
In this post I would like to share how's our life here at university developing the VUES (Virtual University and Expert System, pronouced as "views") which you see at www.aiub.edu. Well, you will have to login to see how big it is.Let's start with this semester's (Spring 2004-2005) registration experience:We have a central server which hosts the MS Sql Server for VUES and Oracle for PLegacy Registration System and Accounts. That server for some reason crashed just before the registration day. The ...
Ok like promised here are a few thing to do in order to successfully create a Single Server install of Team Foundation Server B3. Follow the documentation available on the DVD and also available here it has been greatly updated since the last release and has some good information. What I used to do was to create a Virtual Machine with Windows 2003 Server SP1 (apply Windows Update) and then promote to a DC. Install IIS, then install SQL Server 2005, Windows Sharepoint Services and Finally the ATDT ...
This article is in continuation with Part I, Part II & Part III of the series related to solving the error "This document already has a DocumentElement node." which arises when we try to use XmlReader or an XmlDocument to load the XML Data returned by the FOR XML SQL Query.The FOR XML EXPLICIT is one of the toughest techniques in returning XML Data from SQL Server using FOR XML. But it also has the greatest flexibility in controlling the XML Format that is being returned contrary to the XML Fragment ...
This article is in continuation with Part I and Part II.In Part II, we examined how we can utilize the DataSet's intelligence to handle XML Format to overcome the "Document Element" issue while reading XML Data from SQL Server using FOR XML queries.We will examine a much more efficient way of handling SQL XML using the SQL XML Managed classes provided with the Microsoft SQL XML Managed Provider (Available for free download from Microsoft).Microsoft SQL XML introduces powerful set of Properties/Methods ...
As the day started through the mists of the 'Universal' hangover I wondered what Uncle Bob Muglia had install for us... Well for starters: We got the 6th disk from 'Goods'- Longhorn CPT Sept . We got the promised RC of Viz Studio 2005 And we got the promise of a SQL Server 2005 standard edition - (if you are form the US or Canda {read small print on registration site!} - not JASJARGate again!!) So on to the keynote: The “share the pain” video - well done theboys and girls at TVP UK was ...
Hosting.com is pleased to provide FREE hosting plans for ASP.NET 2.0 and SQL Server 2005 Express Edition. Start working with the advancements Microsoft is making today. As a Microsoft Certified Partner we have relied on our strong relationship with Microsoft to provide our clients with the best possible hosting plans. Our experienced and certified support staff ensures that your Hosting.com experience is nothing but the best. The free hosting plan includes 200MB of disk space, 50MB of SQL Server ...
Another interesting day. Have installed Acrylic, and now need to start playing with it. Picked up the VS2005-RC1 (which seems to have a version of SQL server on it, which is good since I use both), which is going onto my laptop this weekend. Also got to log on, to register for beta of Office 12 once it comes out. Finally had some time to have a good walk arround the sponsers, and have a chat with some of the Microsoft people about a couple of issues. The main being one which I found recently, but ...
Updated I found this great post on John Galloway's blog about compressing Microsoft Virtual PC *.vhd files. You can find the original post at the following link ([VPC] Compressing VHD files [VPC] Compressing VHD files). The problem John discusses is one I think we have all found to be true. We have definitley struggled with this one for a while. Our solution has been to use WinRAR to create a multiple file executable. That way if we are too large, then atleast we can break the unzip onto a couple ...
Finally it is Here Downloads. To download an edition of SQL Server 2005, please select an edition in the Downloads box in the upper right and click Go. Although the previous June CTP version is provided for continued testing, we strongly recommend that you download and use the current September version All four Editions are available Enterprise , Standard , Developer and WorkGroup Edition http://www.microsoft.com/sq... Good Luck ...
News coming out of the PDC about an exciting new a set of standard query operators for use in working with data regardless of the data source! In essence they are a set of .net libraries that will extend C# and Visual Basic, from the examples on Microsoft site there is a strong impression that this is a sort of SQL type addition to the languages, that still happily works in a OO fashion. For example extracted from the Microsoft website. Where - Simple 1 This sample prints each element of an input ...
After a long time I'm back writing, mostly because I have something to write about - mostly time has passed by uneventfully... At work, something has changed, actually two things. one is that we have moved to a new office building in a different area, this one is brand new, and has everything that was missing from the old one, especially the fact that I now share an office with a friend - opposed to sitting in an open-space environment, which in my opinion is unsuitable for developing anything but ...
You may receive the error "This document already has a DocumentElement node." while trying to read XML Data retrieved using the FOR XML clause.SQL Server 2000's FOR XML Clause provides great support in querying SQL Server Data and retrieving it in the form of XML. In other words, you can get an XML representation of the Result Set using the FOR XML Clause.So, if a select statement of select * from customers retrieves results in a sequential way, select * from customers FOR XML AUTO will retrieve ...
Seems I missed the excitement of the power outage today; the cabbie relayed the story to me as we creeped up I405, feeling the after-affects of the heavy congestion that was only worsened by the lack of traffic signals. Unfortunately I had to reserve the my room at the hotel that is the further from the Convention Center, but that Sheraton Universal City is treating me well (better than Scoble at the Westin, it seems, but not as good as Casey Chesnut from the Channel 9 crew). I'm posting the my schedule ...
I opened IE7 a few minutes ago and was notified that Microsoft Update is now available. This new service replaces Windows Update and adds patching for Office, Exchange and SQL Server all in one place. Microsoft intends to add more if not all of their applications to the list. I hope Microsoft will make it easy for other applications to tie into this service so we can have one update service for all of our software. And of course ti should be free ;) For more information visit http://update.microsoft.com ...
Like all good computer geeks, I try to download and trial all of the latest and greatest versions of software as soon as it is made available by the great geek god MiSDeN (may his code always compile). Vista was no exception. At 2.4 GB, even over a broadband connection the download took several hours. Finally got the ISO, burned to a DVD and installed on a separate partition (of course). After I finally got it up and running, started to play around with it. My goal was to put all of my beta’s ...
After reading several good things regarding Subversion and TortoiseSVN I decided to give it a try. The “final straw” came while looking into Ajax.NET which is housed in SVN and required installing TortoiseSVN to obtain the source. The process was so smooth and easy I decided it was worth a shot. The scm options facing my little company are very typical: Continue using VSS with it's warts - extremely slow client, requires either VPN access to servers in office or a 3rd party product such ...
I've uploaded Beta 2 of the BizTalk Peformance Tester (yes, I've changed the name) to GotDotNet. This release fixes the following reported bugs: Added configuration menu item to support post-install configuration changes via the UI Fixed bug in configuration UI where the delete timer value was being misrepresented Updated the documentation with a run-time screenshot of the configuration dialog Scripted the creation of the required SQL Server database during installation Please uninstall the previous ...
I just read Bill Evjen's Learn ASP.NET Page, and it has a lot of good information you should check out. For some reason the comments on his page were not working. I couldn't get anything to post. So, here is a quick blast of items that I have stored in Yahoo! MyWeb related to .NET 2.0 Books There are not a lot of books out yet, but if you are familiar with ASP.NET already, check out ASP.NET 2.0: A Developer's Notebook. I leave it sitting on my Safari Bookshelf. They also publish a Visual Basic and ...
So what could be better than going to Las Vegas to geek out for a week? NOTHING YOU FREAK!! As you may have heard that there is a little product launch in November from Microsoft releasing VS2005. It shouldn't be that big of deal. Get a few people together and a keg and the next thing you know you have a DevConnections Conference. :) Actually, the truth is that ASP.NET DevConnections is got a very nice line up for their conference in Las Vegas. They have lined up some really great speakers and some ...
Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server The devil is always in the details J The following I wanted to share because this individual sorted through this error and his resolution may help someone else. I am posting a summary of our correspondence. PROBLEM: BizTalk Deployment Failing – Error: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group ...
ugh. i'm really wishing that sql server 2000 dts package execution had a "start and run from this step" type of deal. I have this huge package (hehehe......sigh) and when it crashes in the midst of it, i'd like to be able to correct the sql/activex script and then resume it. but nope. i gotta execute each step individually if i want to continue down the road. otherwise i'd have to start the show over. unfortunately, this show runs about 3 hours, so i'm not really up for that....also...when you execute ...
Back in 2004 I wrote a small command prompt utility, called SqlDoc, to document SQL Server databases. I posted that tool to CodeProject. I wrote it for my own use and soon I found it extremely useful. The idea of improve that tool and even transform it to a commercial product was rounding my head for a long time. This summer I've spent many hours to make that idea a reality, and it's finally here: dbdesc v.1.0 Some differentiating features with the rest of commercial products out there are: It uses ...
So you wanna use Sql Server 2000 DTS to go out and pull down some files via an Ftp site? Simple right? Well what if your vendor is using dated filenames (i.e. 050805.zip)? not so simple anymore. i had a really hard time finding information on todays task and i'm passing the solution on to others: 1. Create your new DTS package.2. Drag an FTP Task on the package. 3. Enter in the Non-changing static information on the first tab (ftp site, username, password and dump location) - Dont select any files ...

From Scott Gu's Blog:

One question I’ve seen asked a few times by people over the last few weeks is “how do I setup the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of SQL Express?” This blog entry walks you though a few simple steps on how to-do this.

Deploying BizTalk Server 2004 - Complete / Clustered - Production Setup (NOTE: If you find any errors here - please feel free to point them out - I worked hard to document each step and leave nothing out. Some of the steps that are not detailed are so because the process is pretty straight-foward.) This document takes the following considerations into account. Please note: You need to be familiar with basic network naming conventions for this setup. Before beginning the processes to setup BizTalk ...
There exists a lot of literature written on Free and Liberal Open Source Software(GNU/FSF). This is what I feel about it. I had recently been to a school to give an introduction about computers to some kids in a village near Pondicherry. I had access to a laptop and showed them a quick presentation on the basics of computers. I was aware of the fact that the school syllabus has Microsoft Windows as the primary platform for education. Most kids think paint is cool. What would they say if they saw ...

Most of the time, we end up using Crystal (shudder) or SQL Server Reporting services, but this might be a good alternative for simple reports.

 

Just wrote a very quick and dirty utility to allow a SELECT from a SQL Server database and save to CSV. It was for a one off data extraction for a client for a query not currently in the main web based application. Due to using MSDE there are no SQL client tools to use to do this job, and I didn't have the MSDE manager at hand. Anyway full details and source code for the utility are now at http://codecorner.tigernews... ...