Tag | SQL Posts

When you first create a new table, there is no index created by default. In technical terms, a table without an index is called a “heap”. We can confirm the fact that this new table doesn’t have an index by taking a look at the sysindexes system table, which contains one for this table with an of indid = 0. The sysindexes table, which exists in every database, tracks table and index information. “Indid” refers to Index ID, and is used to identify indexes. An indid of 0 means that a table does not ...
Lambda expressions are a powerful tool to writing quick, concise code. They can be used in numerous situations, most notably in conjuction with LINQ statements.A lambda expression is an anonymous function that can contain expressions and statements, and can be used to create delegates or expression tree types.All lambda expressions use the lambda operator =>, which is read as “goes to”. The left side of the lambda operator specifies the input parameters (if any) and the right side holds the expression ...
Pros and Cons of NOLOCKI have seen some developers use WITH (NOLOCK) when querying in SQL Server and wonder why they use. Now i explored it and found that its useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, you cannot be guaranteed that the data isn’t changing during the time that the query is running.With ...
The landscape of SQL Azure backups is changing rapidly. A few tools are becoming available at no charge and Microsoft is adding capabilities over time. Here a quick update.Microsoft ToolsMicrosoft offers two primary backup mechanisms so far:Export/Import feature available on the Azure Management portalThe COPY operation as part of its T-SQL CREATE DATABASE statementThese mechanisms do not offer a scheduling component and do not work together. To obtain a transactionally consistent backup, you first ...
Inviting all the people who wish to expand their knowledge in the field of Microsoft Technologies. I will be conducting FREE classes on various streams in Microsoft Technologies like: SharePoint - Administration and Development Visual Studio - 2010 C# and .NET 4 LINQ Team Foundation Server 2010 SSIS ASP .NET Programming Office Apps & Open XML Basic SQL Server and Queries Windows Azure One Note All the courses will be taught using Microsoft Official Curriculum. Soft copies of Lab material, Virtual ...
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 ...
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 ...
They’ve arrived! Microsoft is bringing a number of sessions from their popular TechDays events to Prairie Dev Con West in Calgary and they’re now posted on the site! In addition to fantastic SharePoint, SQL Server, mobile, and cloud sessions, there’s more great content for those in the IT Pro world: System Center, VIrtualization, Lync, and more! Check out all the TechDays content by visiting the Sessions page and selecting TechDays from the filter list! http://www.prairiedevcon.co... And a ...
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 ...
Environment what we are building consists of: Operating System: Windows Server 2008 SP2. Database Server: SQL Server 2008 with SP2. PeopleSoft Application: PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 PeopleTools: PeopleSoft PeopleTools 8.52 Web Server: Oracle Web Logic Server 10.3.4 The machine name given for this environment is WIN2K8 and currently only 1 user, the default username is Administrator and it is the local admin. The below steps are performed with ...
In this article, I will show you some tips to improve your ASP.NET performance. 1. Disable the Debug Mode or Set Debug =”false”How it affect performance: By default this attribute is "true" when you create new application and is useful when you are developing the application. Debug = true means that pdb information to be inserted into file and this results a larger file size and it's performance issue. Before deployment you should set the following tag <compilation defaultLanguage="Vb" debug="false"> ...
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 ...
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 ...
It is stupid to compare those two beasts. BizTalk Server is a pricey, huge development and run-time system, it includes tons of the tools, supports tons of protocols and systems. It works for very specialized middle ware integration stack. It integrates big and complex systems as SAP, CRM, Oracle and intermediates many protocols and standards as SOAP, EDI, SWIFT, FTP, tons of them. It is a messaging system. ZeroMQ is a low-level, wire-level protocol, the same level as TCP. It has ultra-simple API. ...
One of the great things about 2012 is that I am not in our office nearly 100% of the time during business hours. This is the first time I have been able to work from our office this much in about 4 years. In fact, we have moved three times during that four years and I have only averaged about 10-25% of my time in the office. This means I can actually setup my desk for development instead of business related tasks only. That means THREE MONITORS! My first reaction after a week with this setup: I never ...
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] ...
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 ...
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 ...
Thanks to AndraaxAged Yak Warrior http://www.sqlteam.com/foru... Generate insert SQL for a table - Insert this stored proc: create proc [dbo].[generate_inserts] @table varchar(50) --Generate inserts for table @table AS declare @cols varchar(1000) declare @col varchar(50) /* generate_inserts 'PlanLevel1ControlResponsib... */ set @cols='' declare colcur cursor for select column_name from information_schema.columns where table_name=@table open colcur fetch next from colcur ...
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 ...
I had originally planned to write this using the live writer, however it isn't wanting to install so I guess it will have to wait until next time.I was working along the other day and one of the users I had added in was displaying as his domain account instead of his first and last name. I was in a semi rushed mode at the time, so I decided to skip the "steps" as I call it to find out all you can about your problem user(s). But I will list out what I would have done had I had more time.Side note: ...
Windows Azure Platform How to Sort Azure Table Store results Chronologically How to upload your Excel and CSV data to the Cloud - Blob Storage SQL Azure Database Notification and Job Scheduling Service for SQL Azure SQL Azure Tutorials – Blog SQL Azure Tutorials - Helping you with Cloud Databases How to build a SQL Server Reporting Services report with SQL Azure? Middleware in the cloud SAP meet Azure Service Bus – EAI/EDI December 2011 CTP Azure Service Bus EAI/EDI December 2011 CTP – New Mapper ...
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.
At http://www.darkreading.com/... there is the report of a massive SQL Injection attack.More information at:http://www.net-security.... ...
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... ...
I received the good news on Jan 1st that, for the 4th year in a row, I was awarded a Microsoft MVP award for ASP.NET/IIS. There’s some movement as there always is – some people not getting renewed their MVP award, new people attaining it. Some people have publically voiced how they turned down the award or just didn’t bother working for it for a variety of reasons that I won’t get into here. There’s also been some passionate Twitter discussions around community and groups and how valid they are, ...
I’ve used the platform for ClearQuest migrations to TFS and Subversion migrations to TFS. The setup for testing the configuration can be tricky to ensure you’re starting again from a blank slate. Problem I was puzzled after running a number of test migrations to find that no source code would be migrated for some team projects, but not others. I was starting with a new migration configuration, new destination team project and even a re-install of the platform and the SQL Server DB for the platform. ...
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? ...
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 ...
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 ...
Have you ever wanted to programmatically insert hundreds or more discount codes into your Magento 1.4 shopping cart and did not want to insert them one by one? I will present the solution to your troubles here: We will be programatically writing out hundreds of records into the salesrule and salesrule_template tables.We will offer 3 different kinds of discount codes, one for 120 off, one for 200 off, and one for 500 off. Each will contains a random suffix. There is one of each, we will give one per ...
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 ...
I just finished reading new book on Microsoft BizTalk 2010 written by BizTalk colleagues Kent Weare, Richard Seroter, Thiago Almeida, Sergei Moukhnitski, and Carl Darski. There are many good books that explore core BizTalk features for beginners, intermediate, and advanced developers. This one stands out by the fact that it covers relatively less documented aspect of BizTalk development – integrating with different line of business applications. The subject is vast and diverse so attempt to fit it ...
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 ...
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; ...
Whenever I do use Visual Studio and try to compile something under 64 bit I run into problems. It seems that most MS Devs for Visual Studio and the relevant tool chain are still mainly writing 32 bit applications. Here are some of the latest issues I did run into. COM applications targeting x64 are still using x32 as target platform for the MIDL compiler by default Resolution: You have to select in the UI MIDL – Target Environment X64 by yourself. Alternatively you can edit the vcxproj file directly ...
Our TFS instance had been humming along for some time when I noticed that the full and incremental cube refresh jobs started failing. Using Grant Holiday’s “Team Foundation Server 2010 Administrative Report Pack” I was able to better visualize and diagnose the problem. The Problem The full error message was - OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found ...
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 ...
Daytona - Iterative MapReduce on Windows Azure Overview MapReduce is a framework for processing highly distributable problems across huge datasets using a large number of compute nodes. It is a generic mechanism that comprises 2 steps: Map step: The master node takes the input, partitions it up into smaller sub-problems, and distributes them to worker nodes. The worker node processes the smaller problem, and passes the answer back to its master node. Reduce step: The master node then collects the ...
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 ...
Overview Windows HPC Server 2008 is infrastructure for high-end applications that require high performance computing clusters – i.e. for scaling out parallelizable across many compute nodes in a grid. These compute nodes can be coordinated by a head node , which in turn can be proxied via a service broker node that exposes a SOA WCF interface for job scheduling. Additional functionality includes the ability to coordinate between job processes running on nodes via MPI (message passing interface). ...
Here is the official documentation on how to publish a LightSwitch application – How to: Deploy a LightSwitch Application. For this example, I’m going to show how to deploy a simple application that does not have any role-based security set up. I’ll show how we can configure that in a later post. So back over on my LightSwitch development machine the first thing we need to do is specify the type of 3-tier deployment we want. In the case of my application, I want it to be a Windows Desktop client ...