Tag | SQL Server Posts

chk out my brand new design of MUGH : Microsoft User Group Hyderabad www.mugh.net just in time b’fore the launch! what a suprise it wud be! to my fellow core members. launch Update: The Microsoft User Group Hyderabad Core team is workin day n nite on the community launch of vs and sql server 2005. so heres the core log 2 days before the launch: All systems are a go ! we hope this is also a great sucess just like Devcon ...
BizTalk Server 2004 is not cluster aware, therefore it is not recommended to install BizTalk 2004 on a MSCS based server cluster. However, to achieve high availability of you BizTalk solution, you can still take the following actions. (I assume you are installing BizTalk 2004, SQL Server 2000 on Windows Server 2003) 1. Setup an Active\Passive server cluster based on Microsoft Cluster Services Install SQL Server 2000 with service pack 3a on the cluster. This step is very easy because SQL Server 2000 ...
I had an interesting experience this afternoon which I thought I would share in the hopes that it may save someone else the pain I went through. Today I moved a production Analysis Services server off a machine which was running both SQL Server and Analysis Services onto it's own machine for one of my clients. The repository was in SQL Server, so after installing AS we simply copied the data files off the old server, changed the repository connection string and we had our new server up and running ...
After days on contemplation of whether to install the Team Foundation Server Beta on anything other than a VPC I decided to load it on my laptop. Apparently, the list of prerequisites seems quite… long. I had SQL server 2005 with Analysis and Reporting Services already installed when the Installer prompted an error saying I don’t meet the Pre-requisites. Out of the list that were missing on my laptop, WSPS, WSPS SP1, Reporting Service and Analysis Service were the primary items. WSPS ...
I got this error immediately after installing VS2005 & SQL Server 2005 Express and trying to establish my first connection using the new server - not a good start at all - and by the looks of it, it's happened to many hundreds, if not thousands, of others too. Generally this error occurs if you cannot connect to the SQL server - as the message says (no sh*t). However, what's not obvious is why... First suggestion is to make sure that you specifiy the instance name as well as the server name (christ ...
This is an exciting time for user groups, specifically .Net user groups. With .Net 2.0, Visual Studio 2005, SQL Server 2005, and Biztalk 2006 there is no shortage of things to talk about, let alone try to master. Over the next year we will be reorganizing our group Caparea.net, with the intention of offering better content to our members and more value to our sponsors. This includes developing a new organizational structure, management plans for various aspects of the group, a new website and a more ...
Es sind nur noch knappe zwei Wochen bis zum deutschen Launch-Event von Visual Studio 2005, SQL Server 2005 und BizTalk Server 2006 in Karlsruhe. Eine gute Zeit um einen wohlüberlegten Blick auf die Agenda zu werfen und die Auswahl der Veranstaltungen zu treffen. Hier ist meine Auswahl: (viel Software Architektur mit ein wenig Entwicklung und Datenbank-Administration vermischt...) Mittwoch 08.02.2005 Keynote: Microsoft Application PlatformRick LaPlante, General Manager,Visual Studio Team System, ...

Microsoft has released a SQL Server 2005 System Views Map.  This is a PDF that shows “the key system views included in SQL Server 2005, and the relationships between them.”

Yeah, I'm jumping on the Four-Things Tag-wagon. Four jobs I’ve had in my life: Developer (Geek) System Analyst (Nerdy Geek) Enterprise Software Architect (Business Nerdy Geek) Instructor (Talking Head Geek) Four movies I can watch over and over: Patton -- “You want to know why this outfit got the hell kicked out of it? A blind man could spot it. They don't act like soldiers; they don't look like soldiers; why should they be expected to fight like soldiers? “ Shichinin no Samurai ...
Just finished upgrading our development & testing server to BizTalk 2006. There were no problems. Just be sure to backup master database and all the BizTalk databases, otherwise you might lose everything if something goes wrong. Before upgrading, make sure you install: 1. Internet Information Services 6.0 2. Microsoft SQL Server 2005 or Microsoft SQL Server 2000 Enterprise Edition with Service Pack 4 3. SQLXML 3.0 with Service Pack3 4. SQL Notification Services with Service Pack1 5. Windows SharePoint ...
Today was the end of my humble vacations, and back to work. As I told some weeks ago, I was looking for some time to try ReGhost.NET because in our development portal, many many pages were unghosted. The installation is quite simple, just install in your Sharepoint portal and you´re done. Next, is time to run the application. First is required a SQL Server instance running to select then what "_SITE" database you are going to look for unghosted pages. After that, you will see a listing with all the ...
In my last post I mentioned that SQL Server 2005 provides with you with the flexibility of having an XML document stored into one single column of “Xml” datatype. Just like a int, datetime or a nvarchar() datatype, you can define “Xml” datatype to store the whole Xml document or a fragment as long as your XML is valid. But the catch here is if your XML file has a header something like “ “, and you are sending this document as a string to the database, you are in ...
Over on the Microsoft.Public.SqlServer.XML newsgroup, one Chris Kilmer asked a good question about how to shred a single XML document into multiple tables using multiple stored procedures. Chris's goal with this was to have each stored procedure update one table and pass the XML remaining nodes of the first document off to the next stored procedure. This is actually fairly easy except for one thing: maintaining referential activity between inserted elements. The XML involved is fairly simple: <Invoice> ...
Next week is our community launch event for VS.NET 2005 and SQL Server 2005 to the user group. It was originally going to be another member doing it, but he had a family issue to take care of so the torch got passed to me. I was aware that we'd have to come up with our own method of handing out the discs, and I knew that we weren't getting any money for food/drinks (the materials and training were it)....which is fine...but then I find out that the examples we're supposed to present are the same ...
All XML data type methods (query (), exists(), value() ...) require a constant string as parameter. If you want to pass a T-SQL parameter to XQuery (e.g. in a stored procedure), you have to use the XQuery functions from the sql: namespace: sql:variable() and sql:column (). Simple enough, but there is a catch: you can't use these function everywhere (e.g. you can't pass the sub tree node to the FWOR statement as a sql parameter). The workaround is to use the SQL Server exec () function: define the ...
RV.NUG VS 2005 / SQL Server 2005 Launch .. 18 days and counting...... Back in October it felt like we had all the time in the world to prepare for our event In November I followed the Charleston, SC launch via Chris Williams blog and worked a “little“ harder In December ... I ate lots of non-Atkins food and enjoyed the holidays In January ... it began to feel close... This has been a really great experience so far. We are now receiving items at least 2 or 3 times a week from our sponsors. ...
As the world saw the launch of three milestone products from Microsoft, last year November - Visual Studio 2005, SQL Server 2005 and BizTalk Server 2006, the Technical Communities have their own way of launching them.The MUGH (Microsoft User Group Hyderabad) has its Community Launch and Tech Fest, a combined rare occasion to meet all Community Leads and also participate in contests, brain teasers, win prizes etc., Date: February 4, 2006Venue: Microsoft Campus, Gachibowli,Hyderabad, India.Registration: ...
And you'd thought you'd find *IT* Geek content here? You will... eventually. Promise. But now that I have your attention1... Welcome to the new home for my Techno-Geek Foodie blog “Enjoy Every Sandwich.” I'm Kent Tegels, the Database Curriculum Lead for DevelopMentor. I've been blessed by Microsoft as a Most Vaulable Professional for SQL Server since 2004. So as you can guess, this blog is mostly going to be about .NET, SQL Server and the communities involved with those tools. Well that ...

Interesting article on how SPS 2003 was configured to work with SQL Server 2005: Guide to Reinstall - Migrate SPS 2003 to SQL 2005

There is also a useful link in the article on how to secure your SPS 2003 Portal

I finally got back to reading some of my “Introducing Microsoft SQL Server 2005 For Developers” book and I stumbled upon the topic of user defined aggregates (UDA). I think this is an interesting subject, although probably only useful in very distinct scenarios. The book talks about using it to concatenate a list of strings (e.g. e-mail addresses). While this works after some modification of the code in the book (due to beta differences) it really isn't perfect for this situation, because ...
At work I got installed the new SQL server 2005 express edition, with VS.Net 2005. Through the Visual Studio's server explorer I was unable to connect to my SQL express. After trying different things, I downloaded the SQL Server Management Studio Express CTP. But it had so many runtime bugs, that I couldn't help stop using it. I even tried setting up the TCP/IP and NamedPipes protocol to 'enabled' in the Configuration management tool of SQL server 2005. This is done to enable remote connections. ...
Getting the outlook synchronization to work correctly can get a bit tricky, especially if you are working with an existing CRM database upgraded from 1.2. Here are some tips to help you out: Before installing the 3.0 outlook client, uninstall the 1.2 outlook client Have all your users synch their data Via Add/Remove programs, remove the CRM client Via Add/Remove programs, remove the MSDE engine for CRM (it should be labeled “(CRM)”) Wipe away the program files directory for the 1.2 client ...
This weekend I was tasked with upgrading our production CRM system to 3.0 from 1.2. We had successfully upgraded a development server from 1.2 to 3.0 so how hard could the production server be? I think you all know the answer to that one. Here are some tips to get CRM 3.0 up and running in your environment: Backup all CRM databases and the web site directory where CRM is installed. Check to make sure the SQL server you are using has the correct server name registered as the default instance name. ...
It appears that there is a bug in the RTM release of SQL Server when dealing with a linked server to an Analysis Services server. When you issue a query that has a “WITH MEMBER“ or “WITH SET“ clause like the following simple query: USE master GO /* Add new linked server */EXEC sp_addlinkedserver @server='LINKED_OLAP', -- local SQL name given to the linked server@srvproduct='', -- not used @provider='MSOLAP.3', -- OLE DB provider (the .2 means the SQL2K version) @datasrc='localhost', ...

I've moved from blogger to here, with a news.

Microsoft Users Group, Hyderabad (MUGH) has announced winners for CodeWarriors 2005 and SQL server 2005. Check more at http://www.mvpblog.com/techfest/

 

Scott Guthrie has an excellent example of how to do real-world paging of data records pulled from the DB, using a new feature of SQL Server 2005. Must read ...
So when is a server really a server? On ASP 2 set up you get a nice Steve Guthrie blog entry telling you how to init all the built in providers. Following the bouncing ball I went out to my SQL 2005 and set up an empty database. When running aspnet_regsql.exe, I didn’t see my new database. Inspiration suggested I hook up the new database to VS 2005, but then I got struck by the “dummo ray”. The Server stack is really for servers – machines or IP addresses – and will ...
No rest for the wicked! My first week back has meant clocking up the miles and visiting vendors and attending meetings. One of the software vendors I went to visit was Sybase at their Maidenhead office and particularly their mobility division. I would like to thank Ian Matthews and Tim Roberts for there hospitality. The day visit was a deep dive into the Afaria mobility management product. Afaria, if you have done your homework, is the pretty much the market leader in the mobility management space ...
Error 1: While configuring the databases used by Windows SharePoint Services, might receive the following error, Line 1: Incorrect syntax near 'COLLATE'. (Error code: 170). Solution: Provide the SQL Server Access rights to the BTSService, to do this go to security, logins and add the BTSService (User) which is member of administrator, and add to the all the server roles. Error 2: templatepick.aspx - page not found When you create a new top level site under a parent site in sharepoint, it brings up ...
I've always been puzzled as to why the Web Site Administration tool shipped with ASP.NET 2.0 didn't seem to function nor error out when I had a brand new application being developed on my workstation where SQL Server 2005 Developer Edition is installed. The ASP.NET 2.0 machine configuration has a pre-defined connection string for providers which is tied to the default SQL Server 2005 Express Edition configuration that ships with Visual Studio 2005. I never installed the Express edition because the ...
I'm starting on a new project at work where we're developing for the Windows Mobile 2003 platform using VB.NET 2005. I was really pumped to see all the new controls, especially the editable datagrid becaue they HAD to put one in this time around! But to my shock and horror...the datagrid is STILL not editable! I couldn't believe it! How could Microsoft let me down?! Well, they didn't...sort of. By using all the nifty drag and drop abilities of VS.NET 2005, the IDE will actually create the datagrid ...
From my friends at RVNUG ... which includes me :) Happy New Year! I hope everyone had wonderful holiday season.Our first meeting of the year is just two days away. The meetingis at the Roanoke County Public Safety Building and begins at 6pm.For directions and more information visit www.rvnug.org.Please make an effort to come out and welcome Geoff Snowman. Geoffwill be presenting on Querying XML using XQuery. He has presented atmany MSDN events across the country; so let's show our appreciationfor ...
First thing first, happy new year geeks, may all the best with you. I just reviewed my timeline for this year - 2006. I hope it will be interesting year, with new projects to come, and many more R & D need to be conduct during this year. We will conduct our post-technical review of our projects with our consultant in this month - January. There also some training for developers in the area of migration to .NET 2.0, VS2005, VSTS, and SQL Server 2005. I hope I will not miss it. Also I have 14 days ...

The first NJ SQL Server User Group meeting will be held on Jan. 17th in Parsippany NJ!  Click the link for more info.

DON'T MISS IT!!!!!

--chaz

WoW its been a great year and what a way to finish it with the Visual Studio 2005 and SQL Server 2005 product launches, Amazing Beta releases of Exchange and Commerce Server and man Vista December CTP rocked or what!? well 2006 just promises to be better and one hell of a exciting year, what really excites me about the technologies that are slated for release in 2006 is that they promise to represent a paradigm shift in the way we build and use software and more importantly computing itself. We kick ...
Khurram Aziz, another blogger from Weblogs.com.pk, has just put his hands on SQL Server 2005 RTM (Just like me!) and he is blogging it. The guy is talking about his first impression of SQL Server 2005 including the same comments I'd write!! He also links to a great article about .NET Optimization Services and SQL Server 2005. Nice hit, Khurram ...
One of the uses mentioned for common table expressions (CTE) in SQL Server 2005 is recursive queries. A CTE allows you to define a virtual view that can be used in another statement. At first glance I thought this was awesome. In fact I had just recently implemented a user-defined function to calculate the “pieces per” based on a global trade item number (GTIN), because recursion is necessary to calculate the value. The following article has more information: http://geekswithblogs.net/t... ...
This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005 VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, ...
When pontificating on subjects like SOA, one has usually has to decide which side of the fence to stand on: Unqualified, wild-eyed, bandwagon-riding enthusiasm. This usually involves pronouncements that the new paradigm will make computing infinitely easier and more fun, that it should universally and immediately be adopted for all new development and most if not all legacy systems should immediately be re-written because the new paradigm renders them hopelessly obsolete. In addition any developer ...
VistaDB 2.1 database for .NET has been releasedThis 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005 VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, ...
I've been following Vista DB for a little while now... basically they have built what is a small footprint database engine for cleanly embedding into an application... no MDAC incompatibilities (with Access/SQL Server), no external service that has to be installed/maintained/(another 24/7 virus target!), and runs in the same process space, so restarts are completely under your [application's] control. And I'd like to get my free copy ;-) VistaDB 2.1 database for .NET has been releasedThis 2.1 update ...
This month's Melbourne SQL Server User Group meeting was all about the CLR integration in SQL 2005. There has been a lot of hype about this feature and you can find various views ranging from “use it for everything” to “don't even enable it”. The talk we given by one of our local members, Greg Obleshchuk from A & G Software and I think he did a great job of presenting the good points of the CLR integration and highlighting when to use it and when not to use it. As a general ...
Well it looks like January will be a busy month in the world of mobile. We have even more webcasts and this time Eileen Brown has alerted me to them! Details are on Eileen's blog and also here below: MSDN Webcast: Creating a Windows Mobile Line of Business (LOB) Application (Part 1 of 13): Introduction (Level 200) Wednesday, January 04, 2006 - 11:00 AM - 12:00 PM Pacific Time Maarten Struys, Product Manager, PTS Software This series of 13 webcasts shows you how to create a line of business application ...
A while ago a friend told me that he was having problems rebuilding the master database in SQL 2005 running on WindowsXP SP2. I wanted to verify the steps to rebuild master when runnnig on Windows XP since I rarely work on XP boxes just to make sure there were no hidden gotchas in the process. Here is what I did to rebuild the master db in the environment described above: Step 1. Put SQL Server into Single User Mode The first thing you will want to do is stop the SQL Sever Sevicer (sqlservr.exe) ...
This past Thursday I had a pleasure of attentind a local Launch of Microsoft's Visual Studio 2005, SQL Server 2005 and BizTalk 2006 event in Orange County Convention Center. I had a tremedous honor to be part of ATE[Ask the Experts] panel in the pavilion on the Developer side. First thing I was asked was my area of expertise and with out complicated [and erragant] answer of everything .NET related - I picked Microsoft Express product line. Through out the day I was able to see some cool demos by ...
Hello everybody, Today, a few hours later, I'll be attending the Egyption Edition of Microsoft Visual Studio 20005 and SQL Server 2005 Launch, as one of Microsoft Solutions Summit days. This is as important as MDC, as I know about the summit round the world, and, as I heard from Ahmed Bahaa, the best well known Egyption developer lecturer you can ever see in day 0 of the MDC. I'm quite busy these days, as I handed over a large VB.NET project (yes, it's VB.NET, not C# !!) after a developer who made ...

The following link contains a list of Microsoft SQL Server data types and a list of their .NET CLR equivalents: http://msdn2.microsoft.com/en-us/library/ms131092.aspx

And this link shows the mapping between C# built-in types and the .NET CLR types: http://msdn2.microsoft.com/en-us/library/ya5y69ds.aspx

 

Apparantly ComputerWorld.com has selected my recent blog entry about Gartner's BlackBerry recommendation for one of their IT Blog Watch articles (check the article out here). The compiler of the blog posts made the comment “What about Palm Treos”. The answer, of course, is: Palm Treos will now support Windows Mobile, which in turn will support .NET and the compact framework. I don't think the palm platform is powerful enough to handle the types of applications that the CF and .NET can ...
Today Microsoft launched Visual Studio, SQL Server 2005, and BizTalk 2006 Beta 1 in Denver (These products officially launched Nov. 7th). The event was a great success with about 2000+ engineers in attendance ranging from hobbyists to seasoned professionals. I enjoyed participating in the “Ask the Experts” panel which allowed me to meet many attendees and answer questions about two of my favorite products, VSTS and SQL 2005. Hopefully I helped everyone who asked questions about these ...
I forgot to write about this before the event (sorry) but if you're a cool SQL Server kid in the Vancouver area then you already knew about the Vancouver PASS Caffeinate With Scott event and the informal meeting last week as well (which I didn't get to). Basically it was just a bunch of SQL geeks getting together over coffee, and picking up some SQL Server 2005 training DVDs. I also understand the group managed to raise a bit of money for a worthy cause as well, so thanks to Scott for that. I had ...