Tag | server Posts

I was recently helping a client do some capacity planning for an upcoming TFS Lab Management deployment. I was being kind of lazy so I just sent them over the Capacity Planning Calculator spreadsheet that the great folks in the ALM Ranger team released with their LM guidance: http://ralabman.codeplex.com/ Less than a day later and they're calling me up telling me the spreadsheet doesn’t make any sense. So I fire it up, punch in some numbers for a fictional team, and sure enough the numbers it’s giving ...
This is an error message that we can find when we connect to SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Hmm… We sometimes spend for hours to fix this issue and In this brief tutorial, I will ...
I cut my DBA teeth on IBM's DB2 UDB EEE (enough acronyms) back in the 90's. I have always appreciated the scalability that is available with a MPP architecture. So a couple of years ago I was excited to hear that SQL Server was going to have a MPP architecture available. Now I am at SQLPass Summit 2011 and seeing the PDW (Parallel Data Warehouse) and the hardware offerings by Dell and HP to scale that up and out. However, I was disappointed to learn that this technology does not extend to Analysis ...
Hello Everyone, I thought I’d take a minute to update everyone on my upcoming talks and events that I will be attending. I have talks ranging from Kinect, Silverlight, HTML5 to OData! Wow, that’s a wide range of technology and I’m very passionate about everyone of them. Let’s get started. DevReach - October 17th through the 18th in Sofia, Bulgaria. I will not be speaking at this event only attending. I am very excited because this will be my first time visiting Bulgaria. I am looking forward to meeting ...
I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL ...
I came across (thanks Paul) a great way to quickly generate test data for SQL Server today. DECLARE @rows INT, @a int SET @rows = 50 SELECT * INTO dbo.RobTest FROM (SELECT TOP (@rows) Rownumber = ROW_NUMBER() OVER (ORDER BY (SELECT 1)), SomeInt = ABS(CHECKSUM(NEWID())) % 50000 + 1 , SomeLetters2 = CHAR(ABS(CHECKSUM(NEWID())) % 26 + 65) + CHAR(ABS(CHECKSUM(NEWID())) % 26 + 65) , SomeMoney = CAST(ABS(CHECKSUM(NEWID())) % 10000 / 100.0 AS MONEY) , SomeDate = CAST(RAND(CHECKSUM(NEWID())) * 3653.0 + 36524.0 ...
The SQL Server team or group of teams responsible for the learning content has done a fantastic job continually of providing great ways to work with their content. This time it is through the Virtual Labs made available to ramp on Denali. How to get it? Go to the Learning Center’s Virtual Lab Link. http://www.microsoft.com/sq... ...
Full Disclosure: I was one of the technical reviewers on this book. I think my friend Tomislav did a great job on this book and it would make a valuable addition to the bookshelf of anyone that is working with MDX. I really enjoyed reading this and there were even a couple of interesting techniques that I have added to my toolkit. As far as I know there are not any other MDX books on the market quite like this one. It's more aimed at the intermediate level of MDX user and assumes that you have some ...
When you are going to join any computer from domain controller the following error will be appeared on your computer screen. Full Error Message 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; ...
Normal 0 false false false EN-GB 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-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ...
In SQL Server we know 3 kinds of temporary tables: Local Temp Tables, Global Temp Tables and Table Variables. In this blog I will try to explain the differences, and tell you how to use it. Local Temp Tables The local temp table is the most commonly used temp table. This temp tables is created with the following statement: CREATE TABLE #TempTable (ID INT IDENTITY(1,1) NOT NULL, Description VARCHAR(10) NULL) The table that the script above created is a temporary table that is stored on disk. To be ...
While the development server in Visual Studio 2010 is great for most work, it does have 1 shortcoming in that if you start adding content types that are not part of the base set of known Mime types built in, you won’t affect the proper header response that is emitted to the client/browser. For example MP4 files, out of the box the development web server emits application/octet-stream or something like that. What we really need is video/mp4. Now, with IIS Express, you can easily switch over to use ...
Introduction To save on hosting costs and simplify maintenance, Software as a Service (SaaS) providers typically rely on schema separation to host multiple customers' records. This implementation relies on a specific SQL Server and SQL Azure feature called a schema object. A schema object behaves like a container, or a namespace in programmatic terms, allowing multiple tables (and other objects) to be stored with the same name in a single database. However schema separation comes with its own set ...
Is your WFC Service hitting the Maximum Limits set on the default service configurations? Open up the artificial constraints of the WCF Service Debugging WCF Services and message sizes. Caveat emptor: If you need to increase the size of the of the contracts, it probably indicates that you should reexamine the design of your data contract. In any case, to “Open Up” the service, you will need to set on both the client and server side configurations: 1. Timeouts 2. Message Sizes 3. Max Objects In Graph ...
Windows Azure AppFabric ofrece servicios en dos areas distintas. La primera la forman servicios de middleware como Service Bus, Access Control, Caching e Integration. La segunda está formada por un servicio para contener aplicaciones AppFabric, un gestor de estas aplicaciones que se ofrece desde el portal de la plataforma y herramientas para el desarrollo de este tipo de aplicaciones. La segunda area, Windows Azure AppFabric Applications, está en CTP desde Junio pasado y es el motivo de este post. ...
Welcome to my new blog on this site. My current blog is still on: http://hassanfad001.blogspo... and will be moved soon to this site. Stay tuned for all information about: - Visual Studio (VS) - Team Foundation Server (TFS) & Team Foundation Service (Hosted TFS) - Visual Studio Application Life Cycle Management (ALM) - Microsoft Test Manager (MTM) - SharePoint (SP) - Community & MVP Program related staff and Microsoft Technologies at all. - ....ect Thanks. Hassan ...
First we would like to thank each and every one of you who have supported Visual WebGui in the nominations for DevProConnections and Windows IT Pro. We appreciate all of our customers and friends of Gizmox for being with us each step of the way in our efforts to bring our unique products to the forefront of code trans-positioning and migration. Without further ado - Congratulations to our 3 big winners! Gevorg Horomyan Marcin Pytel Ugur Yildirim Please contact us at your earliest convenience at marketing@gizmox.com ...
Un servicio de hospedaje en Windows Azure, consiste en una aplicación diseñada para correr en la Nube de Microsoft y unos ficheros XML de configuración que definen cómo debe funcionar.El modelo del servicio es determinado por la configuración almacenada en los ficheros ServiceDefinition.csdef y ServiceConfiguration.csfg y que son utilizados por Windows Azure para saber como la aplicación ha de funcionar. Y los cuales hemos visto en las entradas sobre Gestión de Servicios Azure. ¿Qué es un Rol?Para ...
El NIST define 4 modelos de despliegue dentro del entorno de Cloud ComputingNube Privada Una Nube privada es la implementación de servicios de la nube sobre los recursos que se dedican a su organización, ya sea una implementación dentro de las instalaciones de la organización (on-premises) o fuera de ellas (off-premises) . Con una nube privada, obtendrá muchos de los beneficios de los servicios de una nube publica — incluyendo autoservicio, escalabilidad y elasticidad — con el control adicional y ...

At http://www.sqlsharp.com/features/ there is a series of SQL CLR functions for SQL Server 2005 and later. The basic set can be downloaded for free! For $200, an additional 50+ functions are available.

The benefit of using them is well argued at http://www.simple-talk.com/content/article.aspx?article=1353

Over the past eight years I have been trying to make the switch to Apple from a PC for knowledge and education. I still feel Mac OS X is severely lacking when it comes to actual business or server computing needs, but as a home platform for base operations to the laymen it is a viable option. Recently I upgraded may Apple hardware to a new I 7 Macbook Pro from my Dual Core Mac mini. Boy has this turned out to be a less than just merely frustrating experience. For all the Apple fanatics who claim ...
Here is the interesting problem of the week... finally figured it out! All of a sudden this Monday, our clients started getting "Service Unavailable" errors all of a sudden. I looked deeper in to it, and it turned out the Application Pool on IIS6 for the ASP .Net app had crashed. So I restarted it, and everything started working again. But this started happening intermittently about twice daily. Big problem. The event log on the server showed: Application pool 'XXX' is being automatically disabled ...
This example is not covered in the ESB Toolkit samples and I bumped my forehead a few times while making it work. I thought it’d be helpful to save other fellow BizTalk'ers from headaches by publishing findings. I have been fun of dynamic generic messaging for quite a while and went long ways to avoid working with typed messages and static bindings when it made sense. Nowadays, with the ESB Toolkit one does not have to spend much effort to achieve this goal. But one has to learn intricacies of configuration ...
In order to test Performance in SQL Server, normally you would take a look at how may I/O or how many cycles a statement takes to complete. To make it less complex, you can take a look at how long a statements takes, just by looking at the execution-time. In most cases, network latency, SQL Server hardware and workstation performance are also included in this result (time to create result set, and time needed to send across the internet or internal network). And if a statement takes les then a second ...
In response to a post from an anonymous individual on one of my posts (http://geekswithblogs.net/... regarding free Microsoft tools I thought a follow up post was required! Anonymous, unfortunately you are mistaken; Websitespark is free and is open to individuals it truly provides all the possible tools & software that you could require to get started. If you read the program details on the Microsoft website (http://www.microsoft.com/w... ...
When I try to start the service, it fails and the following appears in the Application log within Event Viewer: Source: MSSQL$SQLEXPRESS Event ID: 17058 Task Category: Server Level: Error Keywords: Classic User: N/A Description: initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.). To fix this I had to change the Log on as property of the service from Local Service to Local System Technorati Tags: sql server 2008,troubleshooting,servic... ...
How fun is it to use new software? As a developer you always want to use the latest software, and in many cases it’s backwards compatible. This (unfortunately) isn’t the case with Report Builder 3.0 and SQL Server 2005 Reporting Services. This is a “by design” issue, but it’s such an annoying “feature”. If you try to deploy a Report built in RB 3.0, you will get the error: "The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.c... ...
Hi Migrate Quality Center to Team Foundation Server 2010 Using Scrat Scrat :Scrat converts and migrates all of your HP Quality Center™ projects and items over to Microsoft Team Foundation Server 2010™. The migration is quick, easy and a safe process that completes in just a few hours Please refer thebelow url : http://www.sela.co.il/alm/p... Test-drive Scrat today: download your free trial version now (which is a fully working version limited to 50 migrated items). Thanks Abhishek ...
Hi Export the test case of QC to Excel and use the tools name :Test Case Migrator Plus" (Excel/MHT) Tool migrate test cases (along with test steps) present in Microsoft Excel to VS2010 TCM server AND migrate VS 2005/2008 test templates present in MHT/doc formats to VS2010 TCM server URL :http://tcmimport.codeplex.... A good Free tool present in codeplex Thanks Abhishek ...

Hi

 

Test Case Migrator Plus" (Excel/MHT) Tool

  • migrate test cases (along with test steps) present in Microsoft Excel to VS2010 TCM server AND
  • migrate VS 2005/2008 test templates present in MHT/doc formats to VS2010 TCM server

URL :http://tcmimport.codeplex.com/

A good  Free tool present in codeplex name !!

Thank

Abhishek Lohani

At last, I can announce that ‘BizTalk Server 2010 Unleashed’ has been published and is available through major booksellers in both printed and electronic form. The book is not a new edition of the old ‘BizTalk Server 2004 Unleashed’ book from several years ago, although Brian Loesgen, our fearless team leader, provided continuity with that title. Instead, this is entirely new content written by a team of six authors, including myself. BizTalk Server is such a huge subject. It proved a challenge to ...
So its been a few weeks since Microsoft’s Build conference, where they unveiled Windows 8 and shared what the developer story will be. I had blogged about Day 1 of the conference here, but I wanted to share some video I took with my colleagues Winson Woo and Jim Russell as my thoughts now that a bit of time has lapsed. So first, a video captured right after we got our hands on the Samsung tablet given to all attendees. Yes the tablet is nice, but this conference is all about the OS. Windows 8 as ...
In this Issue: Michael Washington, Kunal Chowdhury, WindowsPhoneGeek, Xianzhong Zhu, Jeremy Likness, Pete Brown, Jesse Liberty, Derik Whittaker, Morten Nielsen(-2-), Sumit Dutta, Asim Sajjad, and Dhananjay Kumar. Above the Fold: Silverlight: "Enumerating MIDI Interfaces using Silverlight 5 PInvoke" Pete Brown WP7: "Migrating PushBox Game from Android to Windows Phone 7 - Part 5" Xianzhong Zhu Windows8: "Windows 8: What you Need to Know" Jeremy Likness LightSwitch: "How To Create a LightSwitch Command ...
How often does it happen: you write an application that uses a SQL Database as source, and when you want to fetch data you get a time-out. Damn! But when you need to get a time-out (for example, if you want to test an exception), you don’t get one. In SQL Server you can create your own time-outs if you want. One of the simplest ways to generate a time-out, is to lock an object, and running a query against the object in another session. You can lock an object with a simple query: SELECT * FROM Company ...
Normal 0 false false false MicrosoftInternetExplorer4 /* 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-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} To ensure the systems I am ...
Normal 0 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; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... ...
For more formatted view .. Goto http://ankitagrawal57.blogs... any web application, performance is basic necessity. Earlier internet speed used to be limited thus users got inclined to pages which load within 3-4 secs. But now the internet speed is no more a constraint but still time does remain a constraint. Imagine yourself visiting a website which takes a lot of time (30 – 60 secs) just to load the page. You would not like to go to that site again.To mitigate this issue, developers and ...
So someone moved your Silverlight cheese? Go and get some HTML5 cheese! Before WPF/E & Avalon were anything more than vapourware, W3C had the SVG standard(Scallable Vector Graphics) for 2D vector graphics over the web. Using Javascript, you could manipulate 2D animations & tranforms. You can embed SVG in HTML5 today. Yeah, its like going back to Silverlight 1.0, but you just have to deal with it! Embrace change. SVG Features · Designed for 2D graphics - display vector graphics & text ...
Recently I was assigned a task of helping a developer to cope with an unusual input file processing. The file we needed to load into SQL Server had double quotes surrounding those fields that contained comma(s). So a short excerpt from it would resemble something like: 123,ABC 456,"D,E,F" "7,89",GHS Since SSIS’s Flat File Connection does not support alternating text qualifiers, the chief difficulty stems from the fact if we even only remove the quotes, the file structure becomes broken because the ...
One benefit of my recent experience on a BA flight was that I got plenty of time to read through “Microsoft BizTalk 2010 Line of Business Systems Integration”. I’d promised the publisher weeks ago that I would take a look and publish some comments, but August has been such a busy month for me, and they have had to be patient. I should point out that, for the sake of transparency, that with another BizTalk book about to be released (next week) which I helped co-author, I have an urgent and obvious ...
A few weeks ago I ran into an error while setting up our test farm. I was creating the service applications and when I got to PowerPivot, I got the following error: I was able to work around this error by using PowerShell to create the service application. Background First, some details of our installation: two web front ends, two application servers, and one SQL server. All are running Windows Server 2008 R2 x64 with Service Pack1. The SQL Server is 2008 R2 with SP1. The SharePoint servers are SharePoint ...
Today's $10 Deal of the Day from Apress at http://www.apress.com/97814... is Pro Windows Server AppFabric "This book will teach you all about Windows Server AppFabric (code-named "Dublin"), a set of extensions to Windows Server that allow it to function as a lightweight, application server. " ...
Anyone that’s managing an enterprise IT with aging or outdated client/server systems is starting to feel the heat. Soon, their systems and applications will be obsolete and unsupported. At the same time, the industry as whole is seeking the fastest gateway to the latest .NET, HTML5 and mobile deployments including SaaS models. Right about now, there will be a knock on your door with team members offering their advice as to what you should do to ‘keep up’ with the latest trends and supported architectures. ...
The Visual Studio 11 Developer Preview was released to MSDN subscribers yesterday, and will be available in general release tomorrow (9/16). There's way too many new features to list them all here (for all the product highlights go to http://msdn.microsoft.com/e... but here are a few that interest me the most: Enhanced multi-monitor support .NET Framework regular expression syntax in Find and Replace IntelliSense enhancements for JavaScript JavaScript breakpoints ...
This week I’m at the Microsoft Build/Windows conference. Now I’ve been to many conferences throughout the years and this is the first conference where I literally knew nothing about including the agenda. When I signed up for my badge on arrival we got a conference guide with all the hours of the session but no sessions. Very secret, very cloak and dagger. This created a huge buzz but also upped the expectation quite a bit… So with the tabled laid out and the expectation high I sat down and waited ...
For the environment that does not have SCCM to monitor BizTalk server health, the following SQL query can be incorporate into a SQL job and have BizTalk server at least on a "constant" check. Note: be aware that the following was tested only against a single suspended instance with a send port. Since BizTalk SQL server does not allow select against the ServiceClass table, I couldn't use a single table join. With the data I currently have, I am not 100% sure the Receive Port, Pipeline, Orchestration ...
I was working locally and trying to restore a database backup from the server for development purposes. I was receiving this error when I tried to restore and overwrite an existing database: The tail of the log for the database "%ls" has not been backed up. Use BACKUP LOG WITH NORECOVERY to back up the log if it contains work that you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log. An easy fix is to click on the Options ...
So we’re into Day 2 of Build, and the keynote this morning is talking about server and cloud aspects of Windows 8. I’m looking forward to the sessions this afternoon to get some deeper dives. But let’s reflect over yesterday first – Build Day 1. Yes, there was a tablet given away. But those focusing on the “new toy” are missing the bigger message, the larger paradigm shift, the impact on the future of what we’re seeing. I sound melodramatic saying that, but its true – the way development for the ...
Here is a small snippet of BizTalk Server wisdom which I will post for posterity. Say you are creating a custom pipeline component with custom properties. You create private fields and a public properties and write all the code to load and save corresponding property bag values from and too your properties. At some point, when you deploy the BizTalk application and test it, you get an exception from within your pipeline stating, unhelpfully, that "Value does not fall within the expected range." Or ...
As an MCT it is always exciting when I travel to conferences because it becomes a reunion. Well, one more chance this year to make it so, but this time (unlike the last MCT Summit) I am also presenting. Thanks to Chris Harrison (@GeekTrainer) for the gentle nudge! Follow @MCTSummitNA too! The topics I will be presenting are (at least the ones I got confirmation on): Requirements Management: From Vision to Mission to Success Session Level: 300 Team Foundation Server and SharePoint Technologies have ...