Tag | SQL Server Posts

I was trying to install Microsoft SQL Server 2005 Developer edition and received an error during install. The file C:\Windows\Microsoft.NET\Fr... could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program. Where #### where asian characters. Turns out it's a known issue by Microsoft. Here's the Microsoft Knowledge Base: http://support.microsoft.co... Have fun. Pat ...
Wow it looks like SQL Server Express is supported! My host had the following on their Knowledge Base. 1) Please make sure you have Initial Catalog=xxxxx in your connection string. You may sometimes receive an error regarding the log file. You can simply rename or remove the old log file, the application will attempt to create a new one. If it doesn't work, please try the following connection string as well: 2) Make sure you grant the folder "app_data" with read/write/execute/modify (or delete) permission ...
Trying to figure out the best way to connect to SQl Server express for VS2005 Web development is quite interesting. You may be able to connect from vs2005 and the new SQL Server Management studio but when it comes time to run your aspx page against a connection you need to do a little extra work. First thing is security. If you are using integrated security the ASPNET account needs access to your database. I found there is more than one way to do this which adds to the confusion. Option 1) Attach ...
Silver Key is known as a big fan of smart people, especially developers. You can realize it from our exams we do publish to the developer community, or from checking the geeks at the office working with the latest technologies, even if these are not in final releases. We use Visual Studio 2005 and SQL Server 2005 to develop applications using .NET Framework 3.0, Iron Python, and ASP.NET 2.0 Ajax Extensions (formerly known as ATLAS), applying some important methodologies like design patterns for coding ...
Microsoft has released new version of .NET Pet Shop application. The .NET Pet Shop application is designed to show the best practices for building enterprise, n-tier .NET 2.0 applications. Full source code is available for download. This version is designed specifically for ASP.NET 2.0. . By using this new 2.0 features code base was reduced by 25%. These are the main changes in 4.0 release System.Transactions instead of Serviced Components. Generics for strongly typed collections instead of loosely ...
While designing DAL layer we normally stuck with one debate, Stored Procedures or Embedded SQL Query? I also faced the same problem. I searched on the internet, read some books and discussed with some friends. I am trying to compile all these discussion in single post. Stored procedures require only use the SqlCommand object to execute. Other way is to deal with SQL is to store your SQL statements as text (Embedded SQL Query) to be executed with SqlCommand objects. Different people will give you ...
In three tier architecture when BL class calls DAL to retrieve data from the DB we are having two options to get these data one is DataSet/DataTable and another one is DTOs (Data Transfer Objects). DTOs are classes which mapped to the DB tables. For example if Category table in Db having fields ID, Name and Description in this case DTO class will only have three properties named ID, Name and Description. DataSet also having two options one is typed Dataset and another one is untyped dataset. We will ...
I have been working in SQL Server 2000 for previous several years. Of course it's a nice tool, where I can compile the top level requirements to physical implementation layer in much professional way. Well, as a developer, I have been faced a common problem in multiple projects, where I got confused while seeing the database diagram of an existing system, after a long time while I designed the database. Using database diagram, I can easily see the data fields, analyze the relations etc. But the ...
I'm looking to hire a C# .NET developer for a full time position in our Lenexa, KS office. You would be working for SAIC. SAIC is a leading systems, solutions and technical services company. We solve our customers' mission-critical problems with innovative applications of technology and expertise. I'm looking for someone very fluent in C# and the .NET framework. ASP.NET, SQL Server and/or Oracle experience are definite plusses. C++ in a Windows environment is a plus also. Email me at taylorrich@saic.com ...

MSSQLTips.com is your resource for daily SQL Server tips brought right to you. Each issue includes only one new tip and something that you can use immediately.
The DataReader provides forward, read-only access to the data read from the database. It provides no mechanisms for randomly accessing the data. A DataAdapter, along with a DataTable or DataSet, provides random access to data. In addition, the data can be changed in the DataTable or DataSet, and the DataAdapter can be used to update the data in the database. Of the two access methods, the DataReader is the lightest and fastest and is preferable when you need to only read the data, as reflected in ...
We talked about the fact that the classic ASP Session_OnEnd handler is widely known to be pretty unreliable. However, in ASP.NET the corresponding Global class handler, Session_End, is very reliable. Then we talked about "what if" scenarios, such as what if the ASP.NET worker process was recycled? If so, I reasoned, it didn't matter whether you were using Session, Application or Cache, all of your stuff would be lost. The only exceptions to this would be if you were using the ASP.NET State Server ...
classes MUST follow. It defines method signatures but cannot have any implementations; the latter must be provided by the classes that implement the interface. C# differs from C++ in this regard because C++ lacks native language support for interfaces. As a C++ programmers you have to create an interface by defining an abstract class with pure virtual methods. what is an abstract class................. An Abstract class lets you define some behaviors and force your subclasses to provide others. For ...
1) Application-wide registration of custom controls. One of my biggest complaints about custom controls (and this was true of both UserControls and custom controls from a custom assembly) was that you had to put a “” directive at the top of every .aspx page from which you wanted to declare an instance of the control. One of the main purposes of custom controls was to be able to use them from multiple .aspx pages in one application. Since controls typically encapsulate elements like menus, ...
What is normalization? Explain different levels of normalization? What is denormalization and when would you go for it? As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? One-to-One relationship can be implemented as a ...
Q1. Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process. Q2. What’s the difference between Response.Write() andResponse.Output.Write()? Sol : Response.Output.Write() allows you to write formatted output. Q3. What methods are fired during the page load? Sol : Init() - when the page is instantiatedLoad() - when the page is loaded into server memoryPreRender() - the brief moment before the page is displayed to the user as HTMLUnload() - when page finishes ...
This article describes how to configure the SQL Server for .NET applications. By default, the SQL Server denies access to user accounts that have not explicitly been granted access to a database, a table, or a view. By default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application cannot read and cannot update data in an SQL Server database. This article describes the process that you can use to permit an ASP.NET ...
At a minimum a developer wants to be able to cache some (or possibly all) of the pages in her ASP.NET Application. The simplest way to achieve this is to add the @ OutputCache directive to the top of the .aspx file of each page:OutputCache Duration="5" VaryByParam="none" %>Now, that was easy, wasn't it? But - exactly what does it do? You are specifying how long the page is to be retained in the Cache with the Duration attribute, inseconds. In the above example, this page will be rendered on the ...
Like last years Visual Studio 2005, SQL Server 2005 and BizTalk 2006’s community launch initiatives, Microsoft along with communities like INETA and Culminis are coming up with bigger and better community launch event for Windows Vista, Office 2007 and Exchange 2007. This is said to be the biggest joint launch ever. Just like last year, I am part of this community launch initiative both as a UG leader as well as a Virtual Trainer. Virtual training program does not only focus on technology related ...
Call me an anti-java, oracle biggot, but these technologies are driving me crazy. First, Oracle's licensing plans are EXPENSIVE and COMPLEX. As updated January 11th, they now consider different hardware platforms cores to rate at different levels. For example, AMD/Intel cores are rated at .50 of a processor. Have a four core chip? You need two oracle processor licenses, and depending on the version of db you get, that means big bucks ($40,000 per processor for the enterprise version, YIKES!). DB2 ...
UPDATE (12/17/2007): My blog has moved. This post is now located at: http://jason.whitehorn.ws/2... In my last post about NHibernate I mentioned using NHibernate.Mapping.Attributes to simplify things. Since my last post I have had the need to store rather large text data in a SQL Server Text field. My initial attempt was to simply create a C# string property that represented the field as such: [NHMA.Property(Name="SomeDa... public string SomeData { get { return ...
In Addition to the links that I posted previouslyhttp://geekswithb... Here are some more useful links Source: http://www.sharepointblogs.... Free SharePoint Web Parts (3rd Party) ActiveX Scripting Web Part (Simon Mourier) AD Management Web Part (Fabian) Alert Manager, Subweb Viewer Web Parts (Mart Muller) Avail Lists & Libraries (Sig Weber) Blogparts (Steen Molberg) Breadcrumb Site Navigation Web Part ...
After a machine of mine became consumed by a project, I have been building a new set of disks latest for my use during new projects. I always build my VPCs using differencing disk. For those of you new to this concept, it allows you to build a disk off of a parent disk and all changes at that point will go to the new disk. With the environment changing on us constantly with different releases of products, it is critical for you to get your project up quick. Here is my example: As you can see, I am ...
.NET having solution files, project files and web project. Solution file can contains multiple project files as well as web project. Few days back I had to start building new .NET based application. I found few good things and try to share. First of all I am having multiple projects in the solution. Logical layers for my web application are: (user) -> UI -> [AL -> BLL -> DAL] -> (DB) [ -> DTOs ] [ -> ES ] UI = User interface AL = Application layer (handlers, as web pages and ...
By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions: ERROR: MSDTC on server 'servername' is unavailable. RESOLUTIONOn the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL ...
Follow these steps to configure SQL Server 2005 to allow remote connections: 1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. 2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections. 3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, ...
Congratulations to Rob Farley, who runs the SQL Server User Group in Adelaide on recently being awarded as an MVP in SQL Server http://robfarley.blogspot.c... That takes the total number of SQL Server MVPs in Australia up to 5. Rob is a fellow speaker at the SQLDownUnder Code Camp this week end, so if you are going, make sure to congratulate him. And if you look really close, you might still be able to see the scars where the implants were inserted :) ...
I am beginning to create a large specialized content management system for my workplace. This Content management system is for a School District. I have looked at a handful of CMS's and came to the conclusion that in order to get mine to do what I want, it would take more effort to re-work their open source CMS's than to just create one myself. This is mainly due to the fact that this CMS will perform ALOT of specialized functions. I am going to do my best to blog about the entire process, about ...
This is post of is for all of you out there that due to security restriction can't be a Local Admin on your server but still need to be TFS Server Administrators. This addresses the Domain installed TFS not the workgroup edition (WE). I will comment on the WE were appropriate. As we all remember there are three application that need our attention here, TFS (obviously), Windows Sharepoint Services (WSS) and SQL Server Reporting Services (SSRS). For project level security I urge you to use the TFS ...
Re: Rules Driven UI using WF. Someone I used to work with @Avanade (Al) called me yesterday asking about some WCF security stuff. We got onto Workflow and he started asking questions about how to leverage the WF Rules engine from outside of the Workflow runtime. Al, in the past, had leveraged the BizTalk rules engine from outside of BTS Orchestration on a few projects. This is a common question and the market is usually looking for Rules engines that can be leveraged in other applications. So, I ...
Few days back In my project I have to run a batch file which contains the series of piped MS-DOS commands to deals with Active Directory. Running batch file through ASP.NET requires impersonate the user id (for ASP.NET aspnet account), which requires lots of code and require understanding of windows securities. I found one work around which is very easy and no need of extra coding. In MS SQL Server there is one stored procedure named “xp_cmdshell” which executes a given command string as an operating-system ...
An exceptional article on CodeProject detailing an extensible mass emailing framework using the MS SQL Server 2005 Service Broker. I'm not sure about the IM-conversation style of writing, but that's just taste. The content is first-rate. What's the Service Broker? Service Broker is a new feature of Microsoft® SQL Server 2005. It offers asynchronous messaging support, and is tightly integrated with the SQL Server database engine. Service Broker provides a new, queue-based durable messaging framework ...
MOSS 2007 can be installed as a Stand-alone Server application or as a Server farm or as a Web Front End. MOSS 2007 installs WSS v3.0 automatically. If you have only one server, you have no option but to install Stand-alone Type, this will install desktop database engine (SQL Server 2005 Express Edition) along. It will be an independent instance of SQL Server just for the SharePoint application. But this will result in very poor performance. And can only be used by a very small user group or just ...

Probably this is the FIRST ever .Net Technical article (Or probably IT technical article) written in the WORLD,  in a (chat) conversation style. Please Let me know if I am wrong.

Mass Emailing Functionality with C#, .NET 2.0, and Microsoft® SQL Server 2005 Service Broker' http://www.codeproject.com/cs/internet/smartmassemail.asp



 

I have the link here to download some sample reports for Fabrikam with SQL Server 2005 Reporting Services. 

http://www.microsoft.com/downloads/details.aspx?FamilyId=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en

 

I faced this problem while using NetTires which I highly recommend for anyone who wants to quickly generate a Data Access Layer using Microsoft Enterprise Library without having to do the grunt work and writing boilerplate Data Access Code. In my efforts to not digress from the Topic I am going to keep some other data access mechanisms that I've used in the past out of the scope of this post and just state that NetTires is a Decent enough Data Access Mechanism I am currently in love with and am using ...
The query below shows how to create an XML document using FOR XML from a table (based on Sql Server 2000). To start with, run the sql script further below to create the sample table, and populate it with some data. Once the select script is run, data will be returned in the form: <Employees> <Employee> <field1></field1> ... </Employee> </Employees> Query select 1 as Tag, NULL as Parent, NULL as [Employees!1!Employee!xml], NULL as [Employee!2!OfficerId!xml], NULL ...
Today I was playing with the Sql Server 2005 Service Broker funcrionality and created MessageType, Queues, Services, Contracts as necessary and after trying to Send Messages I could not find anything in the Queue. After investigating further found that the Messages are all sitting in the sys.transmission_queue and with the following error. The session keys for this conversation could not be created or accessed. The database master key is required for this operation. After investigating further I ...
Notes for TFS Single-Server Deployment on a VPC, Always refer TFS Installation guide for any details. Create the user accounts and give them the appropriate permissions as listed in the installation guide. Run windows update. Install SQL Server 2005 (choose all except Notification services). I did apply SP1 and the TFS installation wasn't interrupted. Install the SQL Server and .NET 2.0 hotfixes that can be located in the TFS setup folders. Run 'Reporting Services Configuration Manager' and refer ...
Introduction to Service Broker Programminghttp://msdn2.mic... SSBAdmin – Niels B. http://www.sqljunkies.com/W... GotDotNet Code Gallery http://www.gotdotnet.com/co... Inside MSDN: Building the MSDN Aggregation System, by John Mollman: http://msdn.microsoft.com/m... Visual Studio Magazine: Program SQL Server 2005’s ...
With SQL 2005 & ASP.NET 2.0 Microsoft added a great feature that provides a non-polling cache invalidation mechanism. Then there’s the non-polling capability too. Generally, with the polling method, you need to run a few setup steps to extend the table you’ll be polling with a trigger. Then, the framework itself, using configuration file settings polls the table (stub table not the original) for changes. However, with SQL 2005, the framework leverages Service Broker and notification ...
Released just over a month ago: SQL Server Web Tools is a Web-based Administration tool to manage SQL Server databases. With SSWT, you can administer accounts, manage databases and tables, write and run queries and Stored Procedures, and much more. http://www.codeplex.com/Wik... ...
Wow weeee... did I ever just make a blunder! I wanted to do some performance tuning on a SQL Express DB. So I detached the DB from SQL Express and Attached it to SQL Server. I did my tuning (created a bunch of recomended indexes) and was about to reverse the process. When I went to re-attach the DB to SQL Express boom... “Cannot Open User Default Database (error 4606). DOH! My bad. I didn't know the sa password and both my one sql server authentication account and my windows integrated authentication ...
I haven't had much of a chance to play with SQL Server 2005 too much yet, but some of the features are really great, such as inclusion of the CLR. Security guru Dana Epp has a great example of using SQL Server 2005 as an extra layer of highly configurable data validation using regular expressions. Check out the data validation screencast and read more about Dana's Anvil project here ...
Dave Hayden has two good blog entries on this subject: One on Saving and Retrieving Images from SQL Server Using DAAB and ADO.NET 2.0, and the other on Saving and Displaying Photos in SQL Server using ASP.NET. The former details putting the images in your DB and getting ‘em out, while the latter shows you how to display them on your web page once you’ve retrieved them. As always for Dave Hayden, the results are top-notch (well, except for the fact that he uses in-line SQL, but nobody’s ...
• What is SharePoint? Portal Collaboration Software. • What is the difference between SharePoint Portal Server and Windows SharePoint Services? SharePoint Portal Server is the global portal offering features like global navigation and searching. Windows SharePoint Services is more content management based with document libraries and lists. You apply information to certain areas within your portal from Windows SharePoint Services or directly to portal areas. • What is a web part ...
I did Developing XML Web Services and Server Components exam recently and got 968/1000. Think thats enough. Now im going to attempt the SQL Server exam. This time im not gonna let up until i get the MCSD qualification.
After receiving a new desktop for my daily duties I had to install the Developer Edition of SQL Server 2005. Once that was done the first thing I do is install the first Service Pack for SQL Server 2005 that was release not long after the release of SQL Server 2005. Anyway during the installation I received a very "user-friendly" dialog box notifying me that some locked files were found: Apparently the setup bootstrapper of the SQL Server 2005 Service Pack installer does not check for running services ...
Introduction One of the features of Microsoft Windows is performance counters. A performance counter is just an integer managed by Windows; it can be added to, subtracted from, and have its value set. Windows comes with many of these to count things like disk I/Os performed. You can read these, but not change them. You can also create custom performance counters, which can be both read and changed. Custom performance counters can be used to instrument applications, e. g., number of order received, ...
Keith Brown has written a great article for MSDN on how to build identity-aware applications for .NET. From the introduction: What is an "identity-aware" application, anyway? In my mind, first and foremost it's an application that relies upon details of its clients' identity, adjusting its behavior based on those details. That's why the first section of this paper focuses on authentication. Another part of being identity-aware is being directory aware. I'm not here to tell you to throw away SQL Server ...