Tag | SQL Server Posts

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 ...
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 ...
I've had a little frustration lately with Team System as a result of not using the complete Team Suite version. When the licensing for Visual Studio changed last year to the role-based versions and/or Team Suite, we considered the options and decided that VSTS For Developers should be all we need. We do not do any web or load testing (just unit tests), and we do not have a need for the designers available in the Architect version. Since then that has held true for the most part. Except for some important ...
Bruce Johnson of Object Sharp writes about a puzzling performance issue that took a little head-scratching to solve. In the end it came down to a data type mismatch between the parameter variable and the field definition. The parameter was nvarchar(40) and the field was defined as char(36). SQL was converting the field values to nvarchar(40) instead of converting the single parameter value to char(36). It makes sense that it would convert the char(36) to nvarchar(40) because converting the other ...
Here are some hints for securing sql server.... here's my rant for today (it's been a while) Why is it people ignore the basics? Why do they insist on ignoring the principle of least privlege? Here's a couple of simple things you can do to help secure your SQL server (when developing code) Connect to the SQL server with a non-DBO account, grant it execute rights to Stored procedures and thats it! Don't use inline SQL and don't grant it Select insert update and delete on views or tables. By doing ...
In my little corner of the world, I have seen this issue come up three times by three different people in the past 7 days so I thought I would posts this. I actually just went through this myself a little bit ago: Open Microsoft SQL Server Management Studio Express Create a database for the import, if necessary Open the Microsoft Access database that will be imported into SQL Switch to “Tables” in Microsoft Access Right click on the Table to be exported Select “Export” In ...
Microsoft Team Foundation Server - I read a lot about it and I've always wanted to have one VPC image. Now that I've downloaded the trial version, I've started building a VPC for it. I've almost got a clear install of Windows 2003 Server, SQL Server 2005 Standard Edition and Windows Sharepoint Services SP2. For somereason, my VPC has allocated itself only 20 gig of total space and I have to have 8GB to run TFS. I hope I could get it installed and running ...
Developer Support has been working hard over the last month and generated a bunch of new KB articles: HOWTO: Use themes and skins to style NetAdvantage ASP.NET controls (updated):<http://devcen... HOWTO: How do I deploy an ASP.NET application for NetAdvantage 2006? (updated):<http://devcen... HOWTO: Basics of using Infragistics controls in Master and Content ...
Someone asked me a very simple question, and I was so surprised at how difficult it became to answer. They wanted to know how to tell if a number is evenly dividable by another number. (e.g. If you have a case of 24, you can sell it in 6 packs, but you can’t sell it in 7 packs.) I quickly said to use the MOD function and check for a zero return value. I walked away with confidence that this issue was resolved. I’ve done this before, I know it works....somewhere. The problem is, that in ...
Programming hotel reservation software can be a huge challenge. Guests stay between an arrival date and departure date, but that only includes the nights, so it technically does not include the departure date since the room that night is available for another guest. Most hotels close books at midnight. Guests can share rooms and sometimes split the fees. Guests can pay via multiple payment methods, including company and personal credit cards, coupons, and, of course, cash, at multiple different places ...
The UltraWebChart has two in-the-box options for deployment: FileSystem or Session. The FileSystem option basically writes the rendered chart image to the web servers disk drive, and renders a standard image tag to the web page which points to that image as its src: <IMG id=UltraChart1_BaseImage src="/devin/ChartImages/Cha... .../> While a simple and reliable deployment option, the FileSystem option does have some drawbacks. 1) It requires that you give the ASPNET user Write ...
SQL Server 2000 Performance Tuning Tools original article: http://www.sqlteam.com/item... This article comes to us from Brad McGehee at www.sql-server-performance.... SQL Server 2000 includes several tools you may find useful when performance tuning your SQL Server applications. Query Analyzer Profiler Index Wizard Performance Monitor SQL Server 2000 Query Analyzer for developing and debugging Transact-SQL code for performance tuning Transact-SQL code. Show Execution Plan Whenever you ...
There are not a lot of example XMLA queries available, so I thought I might work through some examples on my blog. This first example was prompted be a question in the Olap newsgroup and demonstrates how to get a list of databases and cubes. Getting a list of the databases from Analysis Services is fairly easy with a simple XMLA query like the following: <Discover xmlns="urn:schemas-microsof... <RequestType>DBSCHEMA... <Restrictions /> ...
While configuring BizTalk 2004 on one Virtual machine (on windows 2003), and SQL Server is located remotely on another VM, I came across this kind of exception, which doesn’t give you much of information, except that the transaction has already been implicitly or explicitly committed or aborted, search on google doesn’t either give you any information, hence I have listed it over here, Error: c:\depot4000\jupiter\source... FAILED hr = c0c025b3 [7:30:26 ...
I had an issue yesterday with SQL Server 2005 installation of the Notification services. The error that I was getting was: - COM Plus Catalog Requirement (Warning)MessagesCOM Plus Catalog RequirementIf SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup. Well I did as the article said and this didn't help ...
I have the following scenario. Vendor has a database with table having some vendor-provided data inserted. Customers have a copy of the database with ability to add new rows to the same table, but they should not delete some vendor-provided records. Periodically vendor sends patches/updates with additional records to be added to the same table. Someone can say that a better design will be to store vendor and customer data in separate tables, but the structure of both types of records is identical ...
I had an interesting thing to solve: working on an enterprise solution in financial services, volume tests were planned to be executed on a test database on SQL server 2000 SP3. The database has around 70 tables, but some of them are estimated to be filled with millions of records in the next few years. The setup of the database requires quite complex reference data on which the mass data is inserted in around 10 tables, but in order to simulate the real life scenario, it is important to obey to ...
OK so I have been having a play with SQL Mobile (Recently re-named with the CTP as SQL Everywhere) for working on a device from a CF card. Now there is a nice little note in the MS documentation for SQL Mobile: Note: "SQL Server Mobile installation works only on the main memory of a device. If an attempt is made to install SQL Server Mobile on SD/CF card, then SQL Server Mobile installation does not work." SQL Server 2005 Mobile Edition Books Online Then I found an article about how you can actually ...
I came across an error today in SQL Server 2005. The row value(s) updated or deleted either do not make the row unique or they alter multiple rows. The reason I got this error was because I created a table for a data mapping application and in my haste I forgot to include a primary key. I checked my table today and found records that were duplicated and whenever I tried to delete or edit a row in SQL Management Studio this error showed up. So I knew I had to put a primary key in the database and ...
as in, “I just got... “ I'm doing an Access to SQL Server migration. We've hit a few snags along the way, but I thought the “business owner” and I were basically on the same page. I told her from the beginning that she could change the data all she wants and that was no big deal... I'm working with a copy of the Access db and the freshness of the data is irrelevant at the moment since i'm focusing on the 800+ queries and tables and DTS packages. so the B.O. goes and changes ...
SQL Server 2005 Books Online and Samples have been updated. Quotes from SQL Server 2005 Books Online page: The July 2006 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes. Starting with the ...
AppDev Training is offering a free CD Training Class! They have many great courses to pick from including a new Microsoft BizTalk Server 2006 course called “Exploring BizTalk Server 2006”. If you are new to BizTalk 2006, this looks like it would be an excellent opportunity to get 3 hours worth of free training. This CD covers the new features and functionally in BizTalk 2006. Some other titles available are: Exploring ASP.NET "Atlas" and Web 2.0 Exploring SQL Server 2005 It looks like ...
Things have been a bit crazy the last couple of days (my wife is pregnant and there have been a few complications), but I wanted to share some links I've come across the last couple of days: Video - Visual Studio 2005 for Database Professionals (MS Channel 9) Implementing Role Based Security with ASP.NET using Windows Authentication and SQL Server (From ScottGu's Blog) Free web site templates - Open Source Web Designs Chris Technorati : .NET, ASP.NET, Database Professionals, Microsoft, Open Source, ...
Today I started messing with the Mobile Client Software Factory. It has a lot of potential and is backed by the right people so I thought it could come in very handy. I'm new to PPC development and recently got handed an app to build upon and improve, the initial developer being an offshore developer. Being a web developer used to such luxuries as an ORM, full API access on things such as UI controls and ADO when needed, it came as a bit of a shocker to discover the compact framework really is compact! ...