Tag | Database Posts

Back in 2009 I was tasked with automating database dictionaries and schemas outputs for the CI (Continuous Integration) Server called Hudson ( which is probably now owned by Oracle and will become a name like Jenkins, but I digress. CruiseControl and CruiseControl.NET for Windows is another popular free CI, both of which are superior to the lightweight CI of TFS ).I setup ANT scripts with regular expressions that would get called nightly to rebuild the creation of html and image files with the schemaspy ...
As you might, or not, be aware off there is no item level based recovery in Exchange that is natively supported by Microsoft. So to perform recoveries we need the recovery storage group (captain obvious). The purpose of this is to mount the database you want to recover from on the Exchange server and use exmerge to merge the data you are recovering into the active database. An RSG will not be accessible to users and you can only create one at a time. Exchange 2003: 1. Open Exchange system manager ...
This blog has moved to https://hornedowl.netTroubl... the information store service can be straightforward yet immensely complicated if you don’t know what is going on. For this reason I think it is important to know that there are 3 likely culprits that will cause your information store service to go down and refuse to come up: · Database problems · Active directory problems · Antivirus software Trying to work out which is the culprit can be hard, elimination is probably the easiest way to ...
Usually you’ll get alerted to this issue with a call saying that users have not gotten any new email for a while. They will still be connected to Exchange in outlook, you can still log on to the OWA and, when looking at your hub servers, you can see that the all services are up and running (Note that it is possible the transport service could be stopped…). A number of reasons can exist as to why you are not getting any mail flow: · Your recipient polies are not configured correctly · The receive ...
A fairly common (and annoying) problem which seems to like to popup after migrations, yet not unsolvable. The key issue here is that there are new users added to the directory but they are not showing up in outlook. Now, if you are like most organisations then outlook will be operating in cached mode. So log in to OWA and test if you can see the new users there. I’m giving it a 99% chance that you will (and if you don’t you have a serious problem at hand!) The reason you are not seeing these new ...
Running a CCR or DAG is a great way to have a server resilient database. Relying on an asynchronous copy of the log files (Each log file gets copied over only when the store has released it) it copies over the log files from the active node to the passive node so it can be played in to the passive nodes database. But whilst being a great failover solution both solution are also quite high-maintenance, CCR more so than a DAG. Running in to a situation where the CCR or DAG is down because of to many ...
ASP.NET MVC 3 Walkthroughs & Books 1. Intro to ASP.NET MVC 3 - Rick Anderson http://www.asp.net/mvc/tuto... 2. Building an MVC 3 App with Database First – Julie Lerman a. http://msdn.microsoft.com/e... 3. Walkthrough: Retrieving Entity Types with a Stored Procedure (Entity Data Model Tools a. http://msdn.microsoft.com/e... 4. Book – Wrox - Professional ASP.NET MVC 3 http://www.wrox.com/WileyCD... ...
If your connection hangs while attempting to start sql server broker service, its likely caused by the system trying to gain exclusive access to your database. Some people recommend stopping and restarting the sql server instance. I find that a little heavy-handed, like swatting a fly with a sledge hammer. Instead switch the database into single user mode, enable the broker service, and restore the database to multi-user mode. 1) Set the database to single user mode: ALTER DATABASE [DBNAME] SET SINGLE_USER ...
This discussion on the printing of Database diagrams is an on-going one. If affects several versions of SQL Server yet microsoft has failed to reproduce it.Please go to the the discussion at http://social.msdn.microsof... There is now an example of this problem posted ...
I have seen a number of questions lately regarding how SQL Azure handles throttling and how to determine why the throttling occurred. Sometimes those questions are followed by another question asking how to handle throttling conditions in their applications. Troubleshooting SQL Azure Throttling GREAT NEWS! There actually is a way to find out if you are throttled and why, and the results of the throttling. The key is to look at the error message coming back to you. You’ll typically see an error message ...
Step 9: Completing the Database Setup: This step is a very critical step and should performed with very much attention. Below mentioned steps are the ones which I thought were required for the environment I was building but I very highly recommend that you perform this step from the Oracle Installation document which can be found here. Look at Chapter 7 in this document. Updating PeopleTools System Tables: Here PS_HOME is the directory where you have installed your PeopleTools. In our case its C:\PT852 ...
The Objective Three of the 6 development teams using TFS are moving to a different network and domain. There is no on-line connection between the old (source) and new (target) networks. The objective was for the teams to come in Monday morning, bring up their development machine on the new network and have everything as it had been on the old network. Failed Approaches Clone the data tier and move the data tier to the new network. This failed because the procedures for moving the hardware to a new ...
After reading this chapter you should be able to Identify and explain the functions of the core TCP/IP protocols Explain how the TCP/IP protocols correlate to layers of the OSI model Discuss addressing schemes for TCP/IP in IPv4 and IPv6 Describe the purpose and implementation of DNS and DHCP Identify the well-known ports for key TCP/IP services Describe common Application layer TCP/IP protocols Characteristics of TCP/IP (Transmission Control Protocol / Internet Protocol) TCP/IP is a suite of specialized ...
In the project I'm involved with, we've been saving column arrangement and column width data for quite a while. I had a request to give the users a way to select which columns to display and it just seemed natural to include the display order with that data. Recently I've been tasked with saving the filtering and sorting information as well. We're using the Telerik RadGrid, so I went to their site to find out how to do that. Saving all sorts of Grid-related data to Isolated Storage was really easy ...
This post is an example of how to write a WCF Service using a class. The example uses Visual Studio 2010, written in C#, SQL Server 2008 and hosted in IIS. So lets have at it. The table is pretty simple just three columns, an TestID (int), Value1 (varchar(50)) and Value2 (varchar(50)). The stored procedure used will return one record from the table using the TestID as a parameter. Table SQL: CREATE TABLE [dbo].[Table_1]( [TestID] [int] IDENTITY(1,1) NOT NULL, [Value1] [varchar](50) NOT NULL, [Value2] ...
Intro The purpose of this post, is to speak of a small project that I have just published: ORAPOCO. You can find it both in GITHUB or Nuget. What is ORAPOCO? It is a small project that will allow to work with objects little and against our Oracle database. The project consists of the following files: - OracleDB.cs: This class will be in charge of carrying out all actions against the database. The available methods are: Method Desc QueryAll<T> Given a type T(poco object) will execute a query ...
This is the second post about SQL Azure Federation. In my first post I described a little bit about the theory of data partitioning, included the different between the horizontal partitioning and the vertical partitioning. I also talked about the features need to be done when we implemented the horizontal partitioning. And finally, I described some basic concept about SQL Azure Federation. In this post, I will demonstrate how to use SQL Azure Federation in the SQL Server Management Studio (SSMS). ...
The following procedures describe my approach toward a minimal error prone migration of Microsoft Dynamics CRM 4.0 to MS CRM 2011. 1. I start by installing CRM 2011 with a dummy organisation, yes, I don't import the CRM 4.0 organisation, because I want to make sure CRM 2011 is installed and deployed with out any problems. More over it gives the flexibility to map user, if it is from a different domain. (1,5 Hour) 2. I install all the latest updates and roll-up for the CRM 2011, verify if everything ...
If you work with any kind of healthcare data, then odds are you’ll deal with NPI (National Provider Identifier) numbers. The NPI is a 10-digit number consisting of 9 digits (with the first digit being a 1 or a 2) followed by a check digit. The check digit uses the Luhn algorithm, which is calculated like this: Double the value of alternate digits beginning with the rightmost digit. Add the individual digits of the products resulting from step 1 to the unaffected digits from the original number. Subtract ...
After reading this you should be able to Identify the functions of LAN connectivity hardware Install, configure, and differentiate between network devices such as NAIC’s, hubs, bridges, switches, routers, and gateways Explain the advanced features of a switch and understand popular switching techniques, including VLAN management Explain the purposes and properties of routing Describe common IPv4 and IPv6 routing protocols NICs (Network Interface Cards) Are connectivity devices that enable a workstation, ...
We’ve used dbdeploy.net on a number of projects and have found it to be a useful tool, especially around CI environments. We recently started a Windows Azure project that uses SQL Server and discovered that DbDeploy.Net didn’t work. There have been a few nagging issues with DbDeploy.Net as well, like the lack of support for recursive script directories, and when we looked into the code base, we discovered that it’s not really written to modern software development standards, and that getting it there ...
ASP.NET Enterpise Manager is a web based database management system designed specifically for the management of Microsoft SQL databases through a web browser, without the need for any desktop database management systems such as Microsoft’s SQL Server Management Studio. ASP.NET Enterprise Manager is included as default with an installation of Plesk for Windows, meaning that if you are a customer who uses Plesk based Windows hosting, you will most likely have used ASP.NET Enterprise Manager at least ...
This article is a Part 6 of the Interview Questions series. Part 1: BizTalk: Questions for interview without answers Part 2: BizTalk: Interview questions and principles Part 3: WCF: Questions for studying and interviewPart 4: WCF: Questions for studying and interview: DiscoveryPart 5: WCF: Questions for studying and interview: Routing Service Part 6: BizTalk: Advanced Questions Note: There is BizTalk Administrator interview questions by Tord Glad Nordahl. It is time for fun! These questions are for ...
This demo is a continuation of my previous article about "Creating a Simple Log-in Form". Basically in this post I'm going to demonstrate the basic on how to edit and update the form with ASP.NET MVC 3. Before you go any further, I'd suggest you to check out my previous article first about "ASP.NET MVC 3: Creating a Simple Sign-Up Form" and "Creating a Simple Log-in Form". STEP 1: Creating the Model class Just for the simplicity of this demo, I'm just going to display the FirstName, LastName and ...
At http://twimgs.com/darkreading/databasesecurity/S3100711_SQL.pdf there is a free report on SQL Injection Attack. It is always important to remember that SQL Injection attacks can occur with any back-end database server if the input is not properly validated and processed.
The SQL Azure Federation had been publically launched several weeks ago and this is one of the most existing features I’m looking forward. This might be the first post of SQL Azure Federation, and hopefully not the last one. Some Backgrounds SQL Azure Federation was mentioned in about 2009. The Microsoft told that there will be a feature in SQL Azure allow users to split one database into many based on some sort of rules But from the client side perspective, user can interact their data as if in ...
At several client sites, I have had a problem printing Database diagrams directly from Sql Server Management Studio. The workaround is to right click, copy the diagram and paste into word to print it.If you encounter this, please report the problem at:http://social.msdn.micro... ...
Luego de varios días sin hacer post, hoy nuevamente retomo para mostrar un pequeño ejemplo de un tema que últimamente ha sido muy tocado en los foros de asp.net de MSDN. Cómo hacer un menú dinámico con MySql? Antes de empezar a mostrar como crear el menú voy a explicar algunos problemas que encontré durante el desarrollo del ejemplo: 1. Para el ejemplo, utilizaremos la versión beta 6.5 del conector de .net para mysql, sin embargo, deben tomar en cuenta que este conector esta en desarrollo y aún carece ...
[Source: http://geekswithblogs.net/E... This is one in a series of posts covering my generic mapping library on github: Sixeyed.Mapping. 1. Mapping and Auto-Mapping Objects 2. Mapping and Auto-Mapping Objects from IDataReader 3. Mapping and Auto-Mapping Objects from XML 4. Mapping and Auto-Mapping Objects from CSV 5. Comparing Sixeyed.Mapping to AutoMapper The mapping library has support for IDataReader objects used as the source. Using data readers, AutoMap will try to populate the target ...
I have a real-time reporting server with a database which is basically a copy of my production database, but it's populated using transactional replication and replication only copies the primary keys over, i.e. none of the secondary indexes are included. So what I do is every time I need to recreate replication--which is every deployment with schema changes--I script out DROPs and CREATEs for all the reporting indexes I've created and then run the script after replication has been recreated. The ...
[Source: http://geekswithblogs.net/E... This is the first of a series of posts covering my generic anything-to-object mapping library on github: Sixeyed.Mapping. 1. Mapping and Auto-Mapping Objects 2. Mapping and Auto-Mapping Objects from IDataReader 3. Mapping and Auto-Mapping Objects from XML 4. Mapping and Auto-Mapping Objects from CSV 5. Comparing Sixeyed.Mapping to AutoMapper Enterprise projects typically have entities of the same kind defined multiple times to encapsulate different ...
What a better way to start of the year, but with a product that I recommend. I reviewed this product last year on my personal site and now almost a full year later, I still recommend this product. I develop for different platforms and different languages so it is important for me to keep my snippets organized. Visual Studio and Eclipse both have a way to store snippets, but what if your put into a situation where you may need one and find that its in the other IDE that you are working with. That’s ...
What is the Streetlight Store?The Streetlight Store is a .Net library which uses the Entity Framework and a Microsoft SQL Server database to perform the "back-end" operations required for a typical e-commerce application. While the Streetlight Store is intended to be used for e-commerce, it is "front-end agnostic" meaning that you could just as easily create a point-of-sale user interface.Why is there a Streetlight Store?Why develop another e-commerce solution when there are so many already available? ...
This demo is a continuation of my previous article about "ASP.NET MVC 3: Creating a Simple Sign-Up Form" which I wrote few months ago. Basically in this post I'm going to demonstrate how to create a simple LogOn form in which users can supply their username and password. And how to authenticate and validate users in ASP.NET MVC 3. I will not elaborate more in details about the model, view and controllers function so before you go any further, I'd suggest you to check my previous article first about ...
In the team that I have been working with lately they use NDBUnit to control the test database state for Integration Tests. Today I thought I would blog briefly on one of the issues we had and how we are going to go forward in the future in structuring our solution and working with NDBUnit. Let me say upfront that I am no expert with NDBUnit, so if you are an expert with this tool, and you can see glaring mistakes in this post, add a comment (I would appreciate that). That said, let me highlight ...
I'm a big believer in the benefits of having automated tests live with your code. I'm not an aspirant to Red-Green-Refactor Nirvana, but I believe there is a huge value to be gained by taking the code from Button1_Click in the only Windows Form application you've ever written and placing it instead into a method that can be used by a unit test framework. Some of the benefits that I glean from this include my test being preserved past the initial implementation (when you write the next feature of ...
Greetings, this is my first geeks with blogs posting. so forgive me if it looks so sloppy. Purpose: To calculate additional shipping fees for a shopping cart full of items based on product name in Magento 1.4. We will assume the same shipping rate for all services here. Most items in our store are the same size and weight, except for a few items that are a little larger. We will identify those large items by name and add some amount onto them. First we shall start off with a free open source Magento ...
We needed to swap out the DB box. Our DB box runs SQL Server, SSRS and SSAS. The AT is on its own box and SharePoint is on its own box.NOTE: I will update the blog post per resolution of the issue :) The Microsoft procedure I used was: Restore Data to a Different Server or Instance Setup new DB box with WS08 R2 with all updates applied. Installed SQL SQL 2008 R2 on new DB box (same version as on the old DB box). Took TFS offline. Disabled the transaction backup job from existing backup plan (runs ...
A friend of mine works for a large bank… about a year and a half ago they needed a new system developed for their division. They went through the normal process of using one of the recommended service providers to develop the system and this was their experience, which is still typical with most institutions I know… For the first few months development of the system seemed to be progressing along fine. They had meetings, business analysts put things on paper and the developers nodded their heads ...
This is a strangest error I have come across whilst working with SharePoint 2010, the full error is this. [12/20/2011 5:29:10 PM] Warning: [WSS_Content] The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier. RESTORE DATABASE is terminating abnormally. The error message was written to the file restore.log found in the SharePoint backup folder, it seems that the following keyword in TSQL caused the error. IF EXISTS ( SELECT * FROM master..sysdatabases ...
First off in order to get your asp.net site up and running (without membership) all you have to do is copy your aspx files to the root of the htdocs folder that they supply for you. This in itself is an application directory and because of this you can run ASP.NET pages. For your information, I host my site with HostForLife.euSecond, you can use membership by going to their admin pages, creating a database, exporting your data and schema from your current membership database, and then running a script ...
I’ve heard people mention, a few times, how they would like for Microsoft to provide a blank template for ASP.NET MVC. The request seems strange because this is something that anyone can do themselves. This isn’t just creating an MVC project and deleting all the items, which I would agree is tedious. Rather, you can create a custom template of any type for reuse and sharing. This blog post shows how to create a custom project template, using the need for a blank MVC template as the use case. Creating ...
Today's $10 Deal of the Day from APress at http://www.apress.com/97815... is Pro Entity Framework 4.0"Pro Entity Framework 4.0 is a professional-level guide to Microsoft's Entity Framework, the future of data access in .NET programming. Readers learn to implement easy-to-program and highly-performing database access solutions." ...
I was playing with the new Membership API (System.Web.Providers) for the upcoming Virtual TechDays While I was trying out a lot of options for using as DB store, one of the obvious choices was SQL Azure. With SQL Azure, I could offload the Database hosting capabilities to Azure and just focus on my application code. Of course, it comes at a cost and SQL Azure is a subscription based database available in different sizes and rates there of. One of the challenges I faced was, working with the Membership ...
Sitecore has a powerful event pipeline infrastructure that you can leverage to plugin commands into various item creation, change, move, publish etc events. Recently I had to add functionality to Sitecore so that when an items version is created all fields from a target language are copied into the newly created version to ease editing. To do this first we add an event handler in the Web.Config file for the versionAdded event. <event name="item:versionAdded"> <handler type="MyNamespace.MyClass, ...
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; ...
I have recently been using NDbUnit for integration tests exercising the database. I am new to the tool, so the following exception caused a few hours of scratching my head before I figured out the obvious. Assume you are going through the quick start guide from the website, everything works perfectly. Then I changed to my production database and did the same thing and I get the following error…] DbCommandBuilder.CreateSele... string) failed for tableName = '…. Turns out the name of ...
If you haven't already checked out WebMatrix , go check it out now. It's awesome for a variety of reasons. It’s very cool feature.Anyway, one of the cool features of WebMatrix (and Visual Studio 2010) is the ability to publish straight from the IDE to a compatible web host. Not all web hosts support Web Deploy but I know HostForLife.eu support this technology.Here is a quick walk-through with screenshots showing the publishing process from WebMatrix. I try to publish Orchard CMS here. J OK, let’s ...
Renaming SharePoint service app databases When you install SharePoint 2010 and use the wizards, you will be asked which services you’d like to install. By default all but Lotus-Notes-Connector are preselected. SharePoint will install the services and assign a plethora of databases to serve these services. Alas, horror of horror, all these databases are named by Microsoft and all end with GUIDs. DBAs and other keepers of standards abhor it. Sometimes they even go a step further and want the DB names ...
Consider this article on DNS a prequel to the upcoming ADDS series. After all, any active directory implementation requires DNS integration. So what is DNS? DNS is a highly reliable, hierarchal, distributed and scalable database used for name resolution and service location. So basically it translates friendly names (www.contoso.com) in to IP addresses (11.12.13.14) allowing clients to connect to resources in the infrastructure without memorising pesky IP numbers. History of DNS When the DoD initially ...