Tag | SQL Server Posts

The new site for the Belgian Community Day 09 is open. “Eleven Microsoft User Groups combine their efforts to organize this unique networking and knowledge sharing event. A unique opportunity to learn about Microsoft’s latest developments and technologies like Exchange 2010, Silverlight 3, Visual Studio 2010, SQL Server 2008, Windows 2008R2, Powershell V2, Forefront Identity Manager 2010, XNA 3.1. and OCS R2. Microsoft Community Day will take place on Thursday 25th June 2009 in Utopolis, Mechelen, ...
Intro For the blog engine I’m writing for the WinPHP contest I needed a place to store data. Because windows specific features need to be used, Microsoft SQL Server is the logic choice. Getting data from the database isn’t as easy as making that choice. The extension that comes with PHP worked well with SQL Server 2005, but failed when running on a Windows Server 2008 machine with SQL Server 2008. Here’s a step-by-step tutorial on how to get it to work on SQL Server 2008. Installation First, download ...
It’s always nice to learn something new… Today I learned that variables in SQL Server stored procedures have no scope rules. Take this example: -- Declare @Outer int Set @Outer = 1 While 1 = 1 begin Declare @Inner int Set @Inner = 2 break end Select @Outer, @Inner As a developer I expected that a new “instance” of @Inner would be created on each iteration of the loop and that the ending select would actually get an error saying that there was no variable @Inner. But this is not true, all variables ...
When we use LINQ To SQL in C#, the compiler doesn't generate IL to implement our query - we want Sql Server to execute the query, and so IL would not be much good. Instead the compiler creates data that describes our query, in the form of a System.Linq.Expressions.Exp... When the query needs to be executed, LINQ To SQL examines the expression and converts it to the equivalent T-SQL, and sends that to the database for execution. It follows, then, that if we want to use LINQ To SQL in F#, we'd ...
I decided to write this example because I always encounter this kind of issues at http://forums.asp.net . This demo basically shows how to save the CheckBoxList selected items in the database and retain its selected items on postbacks or when the page is loaded again. To get started then lets start by creating the database for storing the data. STEP 1: Creating the database. Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer ...
I just found a great post at SQL Tips by Namwar Rizvi - TSQL Function to convert decimal to Hex, Octal or any other base (http://sqltips.wordpress.c... with a great, simple function to convert any integer into a string of characters in any base from 2 through 36. Here it is, the comments include his post text, giving original credit for this algorithm to Itzik Ben-Gan in his book Inside Microsoft SQL Server 2005:TSQL Querying: IF EXISTS ( SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[dbo].[fn_decTo... ...
I ran into an issue with bm.exe this morning. Here’s the error I saw when running the bm.exe depoy-all command on a spreadsheet. Deploying View... ERROR: The BAM deployment failed. Encountered error while executing command on SQL Server "MyMachineName". String or binary data would be truncated. The statement has been terminated. I ran SQL Profiler the next time I executed this (as well as adding the –Trace:On parameter to the deploy-all command which _never_ seems to add any additional information. ...
ClickOnce is a useful deployment system, which consist of many interesting features, such as easy deployment and updating. This technology is introduced long ago, and it's good-described. I want to stop on some tips, which can help you. 1. Making offline-installer ClickOnce offer some mechanism for installing prerequisite software, before installing our application. It may be MS .NET Framework of necessary version, SQL Server Compact Edition, etc. For example, we have WPF application, which use SQL ...
SPECIAL ANNOUNCEMENT From your friends at the Gold Coast SQL Server Users Group The Gold Coast SQL Server Users Group is proud to host the first South Florida SQLSaturday, on August 8, 2009 at Devry University in Miramar, FL. This is a FREE event, and will include a full day of training, including presentations by many of the area SQL Server MVP's as well as other SQL experts. Seating is limited, so reserve your spot today at http://www.sqlsaturday.com/... We are signing up ...
Velocity - Installation Phase Today I have proceeded with the installation of the MS Velocity CTP3. I would like to mention that first one needs to verify one's system for prerequisites. Basically the most up to date components as a Service Pack of the Windows OS and the latest .Net Framework are needed, also PowerShell 1.0 is a required component because the administration can be later done using PowerShell applets. I also recommend reading the velocity_help.chm file that can be downloaded separately. ...
Before we can start this journey together, I should take a moment to declare the foundation upon which everything will be built upon going forward. In other words, I need to tell you which languages and frameworks I currently make my living off of and will be blogging about. And I would like to do so without trying to intentionally fan the flames of the already overblown Microsoft vs. [fill-in-the-blank] wars. While I was in college, I thought I could do it all and be an expert in everything. After ...
In a word – wonderful. I’m doing some work on a project where somebody had a bit of a fetish for nested views. I’m not talking about one view inside another. I’m talking about one view that joins a couple of other views that each join to other views as well. I needed to add a value to the output of the outer-most view and before I added ~another~ join I wanted to know if the table in question was already joined in one of the nested views. Drilling down into them would have taken time. I remembered ...
This example shows how to create a very simple registration form in ASP.NET WebForms. STEP1: Creating the Database. The following are the basic steps on how to create a simple database in the Sql Server: Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer Right click on the Databases folder and select “New Database” From the pop up window, input the database name you like and click add Expand the Database folder that you have ...
Over the next month we will be migrating the Geekswithblogs system over to new hardware with a platform upgrade to Windows Server 2008 and SQL Server 2008. This upgrade will force us to make some changes that are needed to the database and others that are just because (like ASP.NET 2.0 to ASP.NET 3.5). What does this mean if you are a blogger? Hopefully nothing. The idea is to migrate the data/code to the new servers with dummy IPs and then when we are ready, swap the IPs with the new boxes and BAM, ...
Earlier this week I attended the RFID workshop held at Microsoft's Reading Offices. I thought Id write up some notes and thoughts I'd made about the event. Content/Trainer The course was based on the course developed by the guys at Breeze (http://breeze.net/default.... The material itself is excellently written and is easy to follow. It also has some nice little bits of humour which mean it is not the common/boring material you get on some courses. The material itself lets you build and enhance ...
The next Frederick .NET User Group (FredNUG) meeting will be Wednesday, May 27th at the Urbana Regional Library. We’re pleased to have Jeremy Kadlec returning to FredNUG as well as Steve Andrews who is coming to FredNUG as part of his goal of 52 (yes 52!) talks to the Developer Community this year. It will be an excellent meeting filled with valuable content! The scheduled agenda is: 6:30 PM - 7:00 PM - Intro Topic: SQL Server Dynamic Management Views with Jeremy Kadlec Speaker Bio: Jeremy Kadlec ...
That’s a mouthful. Back in November of 2008 Microsoft shipped the GDR (General Distribution Release) for the Database Edition of VSTS. This update changed the way the database is modelled internally and removed the need to have SQL Server installed locally. You can check out a review of my experience with this release here. The scope of the changes required at that time was such that we decided against updating. I had estimated approximately one full day to implement the changes to our stored procedures ...
Steps for installation of DPM to protect MOSS environment. 1- Install the MOSS then WSS sp1 then MOSS sp1 2- Install Knowledge Base article 941422, "Update for Windows SharePoint Services 3.0" (http://go.microsoft.com/fw... 3- Install Knowledge Base article 941422 on all protected servers on which Windows SharePoint SharePoint Services 3.0, Microsoft Office SharePoint Server 2007, and Microsoft Office SharePoint Server 2007 SP1 are installed. 4- Prepare the DPM Box: (Install DPM ...
Then I have a great offer for you. It includes: Two Microsoft UK geeks. Well used, odd scratch but still in good working order. Choice of two 10am to 4pm technical days in London in May and June presented by the above geeks Information on the day about the fabulous Bizspark offer for startups from Microsoft. :-) Let me explain. I bumped into my old buddies Keith Burns and David Gristwood yesterday. We got talking about the work they are doing around Bizspark in the UK. Turns out they have slots free ...
Normal 0 false false false EN-US X-NONE X-NONE 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-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; ...
For those living in the area, the next SQL Server User Group event is in West Palm Beach on Wesnesday (April 29 2009) and will host Andy Warren. If you are in the area, please make sure to come!!! For more information about time and location, please visit http://www.gcsqlgroup.com/. NOTE: The meeting will be held on April 29, not May 7. The new location in WPB is: CompTec 1750 North Florida Mango Suites 302 & 303 West Palm Beach See you there ...
Password Change Procedure for MOSS 2007 Change the server farm account password: Change the server farm account password in Active Directory. Log on to the server that hosts Central Administration. At the DOS command prompt, navigate to the following directory: c:\Program Files\Common Files\Microsoft Shared\Web Server Extentions\12\bin Execute the following command: Stsadm.exe -o updatefarmcredentials -userlogin <DOMAIN\UserID> -password <newpassword> On each server in the farm, navigate ...
Normal 0 false false false EN-US JA X-NONE MicrosoftInternetExplorer4 st1\:*{behavior:url(#ieooui) } /* 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:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} Robert ...
This example demonstrates how to upload image using the FileUpload control and store the uploaded file in the database in binary format. STEP 1: Creating the Database. The following are the basic steps on how to create a simple database in the Sql Server: Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer Right click on the Databases folder and select “New Database” From the pop up window, input the database name you like ...
The dictionary defines an oracle as a prophet, or someone who can divine the future. Is that an apt description of the Redwood City, California company we know so well? If Oracle can predict the future, does its $7.5 billion deal to acquire Sun Microsystems relegate Microsoft industry dominance to the past? Or is it just about a winning move in a game of one-upmanship with IBM? Emerging common wisdom (and Oracle’s own press release) says this deal enables Oracle to provide the first real competition ...
Looks like I'll get a new version to play with soon. According to this article, SQL 2010 is coming out with a preview release (IE extreme beta I would guess) the first part of 2009. 2008 just came out and I am working on my 2005 certs. It's nice that we are getting a new release so regularly now (or apparantly so regularly) but those who have 2008, there will need to be some real strong reasons to upgrade I would imagine. We'll see how it looks when it comes out. I have to admit, I am looking forward ...
Update: I updated the installation instructions to make it clearer that you need the WPF toolkit and SQL Server express before you can run the application. TechDays Switzerland is always a very nice venue, and this year in Geneva and in Bern were no exceptions. For me it was a special occasion, because I gave the same talk in French in Geneva, and in German in Bern, and I had never done this before. I think it went well. Altogether approximately 450 people saw this talk. I think I will possibly reuse ...
This is another installment of how to use the ASP.NET ListView and Repeater to generate repeating groups of controls in ASP.NET pages in scenarios which often lead developers to add unnecessary complexity to their pages by resorting to dynamically generated controls. Part 2 demonstrated using the ListView control to maintain the values in a repeating group of textboxes, using a collection of strings as a data source,and allowing the user to add rows as required. This works well for simple scenarios, ...
Problem: Recently, when I was trying to run an InfoPath form (.xsn file) as different user from a client vista machine, which doesn't have the SQL server database access which the InfoPath form needs. The problem is more specific to InfoPath (as it allows only two types of authentication to SQL Server through InfoPath (NT and SQL User).So when you design InfoPath form to use NT access which is not a SQL User, it must run InfoPath natively as the NT user who have access rights on SQL User. But if ...

Here is a good link that has some good info about exporting SharePoint List to SQL Server using SSIS.

http://blogs.officezealot.com/mtblog/archive/2008/06/03/importing-list-data-into-sql.aspx

 

Consider you have a SQL Server Table with some multiline text data. And that data contains carriage return in it. Now, if you want to display that data with carriage return in SSRS 2005 textbox, there is no direct way to display it. Because SSRS 2005 uses VB engine to render the data, where it doesn’t understand line feed-->CHR(10) or Carriage Return -->CHR(13) characters. So, what is the alternative? Well, simple we need to use the Replace() function available and replace the specific characters ...
. BizTalk 2009: notorious Microsoft ADO MD.NET 9.0 and 10.0 When I was installing the BizTalk 2009 the Setup asked these prerequisite components: Microsoft ADO MD.NET 9.0 and Microsoft ADO MD.NET 10.0 I did not have Internet access and I had to manually search for these components. Seems it is not a simple googling. :) After painful search I've found them here: 1) ADO MD.NET 9.0: Page "Feature Pack for Microsoft SQL Server 2005 - November 2005" - http://www.microsoft.com/do... ...
There are many cases in BizTalk environments when one want to re-inject a message into their system. I’m mainly referring to testing environments where it doesn’t really matter if a message is repeated. However, it can also be preferred to copy the context of the message into the newly injected message, because your system might want to do some processing of that context while re-injecting. When you do this from code, it’s a snap! First of all, we need to load up our message body and context: Note ...
Major Highlights Add Office 2007 File Extensions to default allowable file extensions in Host Settings Add reference to SQL Server 2008 to Install Wizard to make it clear that SQL Server 2008 is supported Moved Whats New Module/Page to Host menu as it contains content which is not applicable to the Administrator Corrected a problem with "Auto" installation option which would occur when using a non-dbo database user Inline updates to Text/HTML were not HTML encoded when stored in the database App_Browser ...
There is no better time that today to invest in yourself! Check out our upcoming class list, and email me to play "let's make a deal!" Access Level 1 April 9 - April 10 VMware ESX Server 3.5 and VirtualCenter 2.5 - Advanced Course April 13 - 16 Word 2007 Level 1 April 14 Implementing Cisco Data Center Network Infrastructure 2 April 14 - 17 Mastering the Art of Thinking on Your Feet April 15 Office 2003 Workshops April 15 Word 2007 Level 2 April 16 Captivate April 16 - April 17 SQL: Fundamentals of ...
I was doing a data conversion that involved importing data from a flat-file source into SQL Server. I fired up SSIS and created the Data Flow tasks that would move the data into the SQL Server tables. The problem was, the longer fields (i.e. a “Notes” column) were all being truncated no matter what data type I made the destination field. So I created a Data Conversion task to sit between the Flat-File data source and the SQL Server Destination. After I had tried every conceivable destination data ...
Florida has a very active developer community. The biggest problem we seem to have is that all of these different groups usually don't know about each and there hasn't been a "centralized clearinghouse" listing all of the technical communities. Joe Healy, one of our Florida Microsoft Developer Evangelists, maintains a list and one-page flyers for each of the main areas in Florida. I think the eventual plan is that Joe will be updating his site to take advantage of the newer version of Live Maps and ...
As you can guess from the title I have written this post completely on my iPhone.A part from the obvious restrictions, such as the small keyboard, it wasn't a wholly unpleasant experience making the whole notion of using a device like this to construct posts a viable option.What put me off attempting to do this before was indeed screen-size but the iPhone does just about cross the boundary in a useable experience.So I'm a little late to the iPhone party with all the fuss happening last year but it ...
My favorite SQL Server command is: STUFF. What an awesome name for a command. During a recent data conversion I had to combine many duplicate part records in the Part table, but retain the values from all of the duplicate part rows. I used STUFF to collapse the rows: Select Distinct [CustomerPartNo] ,[CustomerNo] ,(Stuff((Select ', ' + CustomerDescription From [PARTS] T2 Where T2.[CustomerPartNo] = T1.[CustomerPartNo] and T2.[CustomerNo] = T2.[CustomerNo] FOR XML PATH('')),1,2,'')) From [PARTS] T1 ...
I’ve known Jim Duffy for almost 6 years now, and I can honestly say he thinks he’s one of the funniest people I’ve ever met. When I first asked Jim to do a NINE Questions interview, back in September, he was delighted to have an opportunity to talk about his favorite subject. Fast-forward 7 months and welcome to the longest NINE Questions interview ever. Ladies and Gentleman, I give you Jim Duffy. 1. Where are you from? A long time ago in a galaxy far away... oh wait, that one's already been used. ...
Working on a database project today I got the latest drop from a co-worker to test on our deployment machine. The process had gone on without a hitch for the past few months but today the SQL 2005 database backup file he gave me would not restore on the deployment machine...gave an error during the restore saying it was "INCOMPLETE". A quick check of SQL Server versions using MS KB 321185 showed us that he was on SQL 2005 SP3 and I was on SQL 2005 SP2. Thankfully that 2 minutes worth of checking ...
We have a number of upcoming IT and Business Application courses, and I am willing to make a deal! Email me to get signed up and to start the bargaining! 6215 Implementing and Administering Microsoft Visual Studio 2008 Team Foundation Server Apr 23 - 24 1327AI Citrix Password Manager 4.5: Administration Apr 23 - 24 Mastering SharePoint Server 2007 Administration Apr 20 - 24 6451 Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 Apr 20 - 24 6232 Implementing a Microsoft ...
Here are some notes about my experience when testing an upgrade to the general distribution release of the Database Edition. I installed the latest version of the VSTS Database Edition (GDR) on my laptop and loaded up a copy of the a database project. Everything converts pretty much ok with the only issue being unresolved cross-database references. DBPro is now model-based and as such does not require SQL Server to be installed locally. This also allows them to have project references to other databases ...
Lets see how to export SQL Server data into Excel. First we have to enable the Ad Hoc Distributed Queries option. Enable Ad Hoc Distributed Queries EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO After enabling it, we can proceed further to write the query for exporting the SQL Serer Data. Export into Excel Query: INSERT INTO OPENROWSET('Microsoft.ACE.O... 'Excel 8.0;Database=C:\testing.xls;', 'SELECT Name, ...
April 21, 2009 3:00 PM - 5:15 PM Minnesota SQL Server User Group Drive Your Way to the DMV Speaker: Jason Strate, Digineer Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches a walk through of some of the more useful DMVs and a practical look at what they all really mean. ...
I ran into Jessica at the MVP Summit and again recently at the Roanoke Code Camp, where she gave some BI talks. Jessica is an interesting person who not only codes in VB, but she digs sci-fi as well. Definitely a geek after my own heart. Check out these NINE Questions with Jessica M. Moss: 1. We’ll start off with an easy one… where are you from? I’ve lived most of my life in, and I still consider my home base to be, a little Virginian town called Culpeper. With my current job and an hour long drive ...
Problem: I am using WSS 3.0 with SQL MSDE. I am having an issue on my server. The system disk is becoming full in every week. I noticed that my sql server ldf (log files) is very big specially wss-server-configuration database logfile it is about 5.25 GB and there are other 3 databases, their log file sizes are approx 3 gb. Is this recommended if I should shrink the log file, should I loss any data here? If I shrink the databse, again it is on going process everytimg I need to shrink the databse. ...
Problem: My SQL Server (SQLEXPRESS) service does not start automatic (although it’s been set as automatic). The thing is, if I try to start it manually it throws an error as “Windows could not start the SQ Server (SQLEXPRESS) on local computer. For more information, review the system Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17058.” Solution: I solved it by changing that the service should start by the local system admin from ...
Next week (23rd March 2009) I am speaking at DevWeek 2009. DevWeek is a great conference which attracts top notch speakers (plus me – I feel such a fraud whenever I present there!). It is IMHO the best developer focused conference we have in the UK and I can’t wait to get there and soak in the great sessions + catch up with familiar faces + meet plenty of new ones. Be warned. There is a rumour that we are being given some new toys (Flip video cameras) to play with while we are there. However don’t ...
Recently a few of us were speaking about what would be the future of BizTalk after the 2009 release. I already had a few thoughts on what I think would be great additions to the product and what strategic directions it may move in. I have checked to ensure that none of my thoughts breach the MVP NDA and after getting the thumbs up I've listed my thoughts below so there might be a bit of discussion on these ideas. AreaThoughtNotesImproved or New FeatureConfiguration SubsystemWithin BizTalk solutions ...