Tag | SQL Server Posts

The Goals of ASP.NET 2.0 Developer productivity – Eliminate much of the tedious coding that ASP.NET originally required and to make common ASP.NET Task easier. Take an example, in ASP.NET 1.x you need to write number of lines code to just enable paging in datagrid control. Now you can just specify “AllowPaging=TrueR... Administration and Management -This release of ASP.NET focus on the developer, and little thought was given to the people who had to administrator and manage all the ...
Rajiv has written a good article on Using Query Notifications in .Net 2.0 Basically the article is about the new notification service of SQL Server 2005 which notifies the .Net code when any DML operations are performed on a specified table. Detailed article can be accessed at: http://www.codeproject.com/... ...
Here’s a good white hat article on how to defend your SQL Server from malicious attacks. It’s pretty high level, and definitely just a starting point. Careful DBA’s will definitely do some more research in this area. You’ll also probably want to use some of the recommended tools rather than just flying by the seat of your pants ...
Two days ago I took BizTalk exam and passed it. My socre was 737 (700 is required for passing). Test contained 40 questions. It was my first Microsoft exam, and I can say it was pretty hard. I've been studying quite hard. Mostly I used BizTalk 2004 Unleashed" which is a great learning resource. Surely you are wondering what kind of questions are in the test ? (that's what I was looking on blogs, but couldn't find too much information). So I can tell you that there are some pretty easy questions (too ...
Arguably one of the most common things you will do in SQL Server stored proc's after writing SELECT, INSERT, UDPATE & DELETE statements is to retrieve the new record ID of the row of data that has just been inserted. For sometime now the most popular way to do this is @@IDENTITY, but @@IDENTITY does have a flaw and that is it will return the ID of the last record created anywhere in the database, so if another process is inserting a record somewhere else, you could receive that ID instead. With ...
Microsoft is getting their new MCITP certifications going. They’ve released two new exams: Last Friday, February 10, the company released Exam 70-444 PRO: Optimizing and Maintaining a Database Administration Solution by Using SQL Server 2005. Then on February 13, Microsoft released Exam 70-443 PRO: Designing a Database Server Infrastructure by Using SQL Server 2005. These two exams, as well as the Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance exam that was ...
We're using SQL Server 2005 reporting services to build reports using Sharepoints web services. For a few days I was scratching my head on a strange problem. The library we were reporting on had well over 500 forms in it, but our reports seemed to be excluding some of them. After some searching we realized that the default view in the library had a limit of 100. You would think that querying through the Sharepoint web services wouldn't be constrained by limits on views, but they are. So keep that ...
We back up our SQL Server databases to a central storage machine using UNC paths in the BACKUP statement (BACKUP DATABASE db1 TO DISK='\\storage\Backups\db1... For a while, backups were failing with the message: BackupDiskFile::RequestDura... failure on backup device '\\storage\Backups\db1\db1.... Operating system error 64(The specified network name is no longer available.). I struggled for a while to find a solution and finally found this thread on www.msce.ms. Unfortunately that ...
Oh my, I'm so hopelessly addicted to ReSharper it's not funny. Now that I'm coding VS 2005, I miss it so and I know a new version is in the works but, I simply cannot stand waiting for it. Now that I have that off my chest, I digress. Let's talk about Windows XP Professional x64. Yes, the OS that I'm using now, the OS that I'm running with extreme pleasure. It's so nice. No, it's seriously, indulgently, over-the-top nice. THERE, now I'm finally done...honest. Anyway, I've been working on a project ...
VSLive returns to Toronto for the third year this spring. The conference will take place at the Toronto Congress Centre from April 24 to 27. VSLive! Toronto will bring together Microsoft insiders and industry experts for four days of real-world insights and demonstrations on Visual Studio.NET, ASP.NET 2.0, Visual Studio 2005, SQL Server 2005, Windows Communication Foundation (Indigo), VB, C#, and more. VSLive! Toronto is designed to address the issues developers face on a daily basis, providing practical ...
Date: Monday, February 20Topic: Developing Managed Code in the Database with SQL Server 2005Speaker: Barry Gervin, ObjectSharp Consulting In this session, we will learn how SQL Server 2005 (code name Yukon) acts as a host for the CLR in a secure and reliable manner. The SQLCLR provides good performance for executing managed code that queries the database within the same process as the database engine. We will learn the techniques for creating optimal queries in stored procedures and triggers, and ...
Don't you wish that the day will go for 48 hours! I wonder why god made it only 24? Yeah, I know its a stupid question because devs like us are used to pressure and to be swamped; this time I wanna share this with you: 1) At BEAT (Company I work with): I have to close 3 projects by the end of this month, not to mention business development and writing proposals. 2) At Jordev: I have to deploy the new site no later than Tuesday 3) At EDC: I have to finalize the EDC CD project, the EDC mobile application, ...
I saw some “interesting” behavior in a plugin system I had written (same culprit I have seen before file locks) was doing some more research and came accross this wonderful blog http://blogs.msdn.com/cbrum... An Abort is performed on all threads that have stack in an AppDomain that is being unloaded. Since we are throwing away the AppDomain anyway, we can often tolerate surprising execution of threads at fairly arbitrary spots in their execution. Even if this ...
I am writing this after a failed initial attempt to install Microsoft Business Scorecard Manager Evaluation Kit. My problems started because I tried to fly by the seat of my pants using the 5 DVDs that should have combined to form a usable BSM environment. Unfortunately, not quite everything you need is included and part of my problems had to do with the use of evaluation software. Also, there are still some legacy requirements left over from the original development of BSM that used SQL Server 2000 ...
Microsoft is offering free E-Learning courses on SQL Server 2005. The web page says that the courses will be free until November 1, 2006. Course 2936: Installing and Securing Microsoft® SQL Server™ 2005 Summary: This course will provide you with a technically deep learning experience on installing and securing Microsoft® SQL Server™ 2005. The course provides detailed reference content and in-depth practical and hands-on activities for database administrators with Microsoft® ...

Here’s a great article on getting started with DNN.  The article details using Visual Studio Express Edition and SQL Server Express Edition, but the concepts work equally well with Professional, Enterprise Architect, Team Suite, etc.

Here’s my rant on resumes: Why do people lie on their resumes? I recently interviewed a candidate who had ‘SQL server DBA’ on their resume – this so called DBA didn’t even know what an index was. How can someone put something on their resume when they don’t know the first thing about it? Do they think they will be able to ‘fake it’ through the interview? When I interview candidates, I ask a lot of technical questions. Usually after the first 3, I have ...
Hello and welcome to my blog. I’m a SQL server DBA; developer; college professor, and all-around technologist. Here you’ll find rants about technology, interviewing, certification, mentoring and all sorts of other technical stuff. I hope to post every few days but who knows? ...
This has been a long day. You’ll notice that yourself. All the knowledge I gained was of the tricky little, not clear or notable, yet highly beneficent. We’ll see that as we go. I started the day with Stephen Forte; the guy is another geek. I guess he and Patrick are brothers or something not just friends, as they both have the same geek soul and extremely high sense of hummer. When it comes to fun and jokes, you have to remember Stephen. I spent the 2 first sessions with him. In the ...
This is one of the "Questions for interview" articles. Part 1: "BizTalk 2004, Questions for interview without answers" http://geekswithblogs.net/L... Part 2: "BizTalk interview questions and principle" http://geekswithblogs.net/L... Part 3: "WCF: Questions for studing and interview" http://geekswithblogs.net/L... BizTalk: Ports: Questions for BizTalk ...
[Crosspost from Managed World] In an earlier post of mine, I linked to this article by Jim Shore on how building software is nothing like construction. This is a topic I've been thinking about a fair amount lately and I've come to a conclusion: I don't agree entirely with Jim. Here's one of the quotes that have been hanging around in my noodle as of late: " In the software world, there is no reason for us to follow the practices of an industry limited by Newtonian laws. We have no gravity. There ...
I recently restored a SQL Server 2000 database into SQL Server 2005. When I tried to create a database diagram I got the following error: "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. " After repeated attempts to to assign a valid login user ...
While checking out the SQLExpress Advanced Tools Beta from my previous post, I found some gold. I've heard this question asked a few times by customers and people at user groups, and lo' and behold, this is what I found: There are a lot of people downloading and installing SQL Server Express. One of the common questions we get is “What should I do next?” We’ve worked hard creating a great product that easy to use, free to download and distribute, and bundled with good guidance and ...
Microsoft is looking for beta testers for the new SQL Express with Advanced Services. From the SQLExpress weblog: Announcing: SQL Express with Advanced Services Beta Are you using SQL Server 2005 Express Edition and want to contribute to helping us continue to improve it? Now is your chance. We are about to start a beta program for the next update to SQL Express and are looking for beta testers who have experience working with MSDE or SQL Express and who are interested in testing out the next update ...
First of all, to be able to follow me up in this post, I think you should take a look at the first part of it before you continue reading. After the session of Dr. Ahmed Bahaa and a quick talk to him, I took a colleague from GNS Egypt and went with her to TOP IT session “Data Access in ASP.NET 2.0”, I looked at the guy speaking out there and returned to my previous belief that I should focus on other sessions than ASP.NET related, as I believed that I’ve seen enough, while there ...
I love the new Microsoft SQL Server 2005 sample databases (AdventureWorks and AdventureWorksDW). Compared with the Northwind and even worse the Pubs databases, they're amazingly more real-world. They show best practices and demostrate a good portion of the 2005 features. The problem lies in a lot of the SQL Server 2000 examples on the Internet still work in SQL Server 2005 and content that's specific to 2005 is still being produced. So, what to do while you wait for the examples to be updated? Why ...
The best made plans. Oh well, it is our busiest time of the year… FYI, you may want to be careful when using two user defined functions in TSQL that return tables and doing a join. You may think that they were going to be processed like any other join; however, in a recent assignment I tried to simplify and extend a complex query by creating a single table (from a complex join) within a UDF and joining it with another UDF (created from another complex join). What happened was quite concerning. ...
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 ...
Attend the three-days East Med Developers conference and learn from experts from around the world. It is the perfect opportunity to brush up on the new tools and advanced technologies you will need to develop innovative, new applications. At this very special event, you will also be able to see in depth the brand new releases of Microsoft latest technologies – SQL Server 2005, Visual Studio 2005 and Biztalk 2006. Register Now http://www.microsoft.com/mi... ...
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 ...