Tag | SQL Server Posts

God...It's been one year since I started neglecting this blog. I must post something. Is there any point to wait for making a blog entry until you really invent something new? Then I may not make any post at all . This is a small tip which might be usefull for someone. I haven't tested the originality of this topic but this is the thing on which I wasted some of my time on a precious sunday. I was just trying to load some excel files to their corresponding SQL Server database. Data entry? no way!. ...
Our TechFuse 2008 Conference on February 26, 2008 drew in over 425 people for a one day conference, focusing on Microsoft Technologies. Featured tracks in 2008 included SQL Server 2008, System Center, Visual Studio 2008, SharePoint 2007 and more. TechFuse 2009 Conference is going to be held on March 17, 2009 (you bet, the luck of the Irish!) at the Northland Inn in Brooklyn Center. We have selected our tracks (with feedback from our internal instructors and our students) and they are: Virtualization ...
We are pleased to announce that we will be hosting our Q4 BISIG meeting at Microsoft Corporation, 8300 Norman Center Drive, Suite 950, Bloomington, Minnesota, 55437 from 3:00 p.m to 6:00 p.m. We hope you will plan to attend this meeting where we have lined up two very exciting and informative speakers. Registration URL: www.ncbisig.org Times: 2:30 - 6:00 Agenda: 2:30-3:00 Registration 3:00-3:15 BI SIG Updates & Announcements (Hear about how the organization is growing and changing to better serve ...
I've been struggling through a Team Foundation Server 2008 install with Sql Server 2008 over the weekend. It seems to be having an especially hard time with the SQL Server Reporting Services. After analyzing a few things, I determined that the configuration tool was having an issue due to some prior installations of software. The report urls were pointing to a SQL Express directory. I went about setting up the virtual directories manually. This required setting up an application pool, and I assigned ...
There is plenty of documentation on how to install and configure SharePoint. For the novice SharePoint user there are step-by-step guides, and for the more experienced user there are checklists. During all of these instructions there is very little emphasis on the proper use of Service Accounts used to install and configure SharePoint. It is, by far, one of the ways that you can spend days in SharePoint install and uninstall. In most cases, when I visit a client to help with the installation, they ...
Just installed BizTalk on my Vista notebook. Here are some information that may help: My BizTalk’s edition – BizTalk Server 2006 R2 (Developer edition) Operating System – Windows Vista Ultimate The installation process is as seamless as it was for previous editions of BizTalk Server 2006. Only important point to remember is you download the prerequisite cab file for Vista. You may be in habit of using previously downloaded prerequisite cab file. Setup will automatically download the CAB file (BtsRedistVistaEN32.cab) ...
I was at the SOA/BPM Conference this week at reading and was watching one of the presentations which discussed the differences between BizTalk and Dublin. It occured to my that with BizTalk being pitched as the integration product and dublin being pitched as the application server product this means that BAM is strategically misplaced in terms of being within BizTalk. This is just my opinion but I think that in the future it would make sense to move BAM to be part of the SQL Server BI offering. I ...
I just picked this up on RSS and am psyched! We've been using DataDude since early on in it's initial release. It has become an integral part of our database schema development process. Hats off to Gert and all of the others on the VSTS DbPro team for all of the great new features, extensibility and SQL Server 2008 support in the new edition. You can read more about it in Gert's blog post. SALUTE! Jim ...
So this is one of my “in the trenches” blogs. I’ve been setting up a new server to run WSS 3.0, which I’ve done a dozen times. I have several SharePoint 2007 servers I am currently running, and WSS is a prerequisite, so this shouldn’t have been an all weekend project. But, for some reason, this particular install was not cooperating. I performed the same steps in the same order, except in this case I did not install SQL Server. In most of my installations I installed SQL Server since I would be using ...
I’ve posted a couple of webcasts on Dublin on BloggersGuides.net. They are based on the PDC08-CSD image, so things may well change going forward, but they provide a good intro as to how to get started exploring hosting services in Dublin, and the configuration options. Hosting Workflow Services in Dublin This webcast will look at hosting declarative services in the Dublin application server. The webcast will start with a basic WCF declarative service and demonstrate the procedure to host the service ...
A while ago, Andy Warren of SQL Server Central asked if brown bag lunches/training worked. His answer was: …now to the question - do they work? I've tried it when I was managing, and sadly, it didn't work. I disagree with Andy on this one, but to be fair I understand his points and they are all valid. To make sure everyone has the same understanding of what we’re talking about, here is Andy’s definition of a brown bag lunch: I'll define a brown bag lunch as a training event held at lunch time where ...
Introduction | Why? | What? | How? | Part 2 Introduction This post was brought about when I moved a development system onto the hardware it will run on in production. The processor is a quad core but even when I had a query with a duration of 30s only one core was running hot, the others were standing on the side line laughing at me. It turns out that to use all your cores you need to be a bit careful about how you write your query. This post and the others in the series are about the discoveries ...
I'm frustrated...No matter which jobs I take I seem to end up working on UI with ASP.Net Webforms. I don't like UI and I really don't like webforms. The model feels broken to me. I don't know whether I'm missing something fundamental in my understanding of the webforms paradigm or it really is broken. I seem to spend a lot of time fighting with the framework. You know when you design something really well and it's just 'nice' to use and then you design something badly and its hard to use? You end ...
Well after agreeing to take over managing my local user group I've managed to have 2 meetings in the past couple of months and interest seems to be building back up. On Wednesday it was my turn to present on some of the new T-SQL features found in SQL Server 2008. It felt good to be up front and presenting again as it has been a while for me. I was a bit rushed for time since I was the second of two presenters but that was fine with me. I simply cut out some demos. I know I made some mental notes ...
This script generates the “CREATE INDEX” scripts for a SQL Server database: set nocount on declare @index table ( object_id int, objectName sysname, index_id int, indexName sysname, fill_factor tinyint, allow_row_locks bit, allow_page_locks bit, is_padded bit, indexText varchar(max), indexTextEnd varchar(max) ) declare @indexColumn table ( object_id int, index_id int, column_id int, index_column_id int, max_index_column_id int, is_descending_key bit, is_included_column bit, columnName varchar(255), ...
I started testing a BizTalk application today which calls a 3rd party service, passing a couple of datetime parameters, to retrieve a dataset which is then persisted to a SQL Server database. This application had been running well in production for a while but enhancements were required to make use of web methods recently made available by the 3rd party. After making the changes I tested the BTS application on my dev box, calling a stubbed web service installed locally. I then deployed the BizTalk ...
We have a table with ntext type of field in sql server database, that actually contains text data. ntext is used to store the unicode type of data that that takes 2 times storage size in bytes, is two times the number of characters entered. Now the scenario is we would like to replace all occurances of a paricular string from the data with another string. It is very simple to do with Replace command in Sql Server, but the constraint is it only takes varchar/nvarchar type of parameter i.e. we can ...
Here's the complete list of sessions from PDC and my personal favorites. You can find all the recordings of these sessions at www.microsoftpdc.com. Here's my personal favorites: Windows Azure (Hosted ASP, Workflow, Silverlight, RAW / Azure Storage) A Lap Around Windows Azure (ES16) - 0:46 Slides | WMV-HQ | WMV | Zune A Lap Around the Azure Services Platform (BB01) - 1:12 Slides | WMV-HQ | WMV | Zune Live and Mesh (Sync, Feeds, Resources, Contacts, etc.) A Lap around the Live Framework and Mesh Services ...
I am always forgetting the format for using DATEADD and DATEPART functions to get just part of a SQL Server datetime (e.g. just the date), so I am posting it here so I’ll always know where to find it. declare @date datetime set @date = getdate() select @date, dateadd(day, datediff(day, 0, @date), 0) ...
This entry is in the hope that I don't fall over this problem again. It's really very straight-forward but has cost me half an hour more than once. I need to create a new SQL receive port today, to receive from a new database and run under a new BizTalk host instance. Step I took: 1. I created a new SQL Server account and granted permissions required to execute the stored procedure that the BizTalk receive location would execute 2. I created a new windows account for the new BizTalk host instance ...
Updated the code Snippet with the Method and Event Handler parameters for the ScriptManager's Navigate Event. One of the common navigation tools in a website is the back button of the browser. People use the back button quite frequently to go back to the page already visited. When there is a postback, the browser is updated with the information of the page visited and hence the back button gets enabled automatically. Assuming there is a GridView control that we are using in a page which fetches a ...
Topic: Migrating a Data Aware WPF Application to Silverlight 2.0 Presenter: Mike Benkovich, Microsoft Date: 11/18/2008 Time: 12pm - 2 pm Website: http://www.ilmservice.com/s... Abstract: One of the great things about WPF and Silverlight is that they’re both built on top of XAML and with Silverlight 2.0 you can leverage the latest data manipulation capabilities of LINQ. In this session we’ll take a look at a basic WPF application that pulls data from a web service. We will explore VB.NET’s ...
We are storing in the database plain text messages formatted with new lines. When it was required to update the message, my colleague used SQL Server Management Studio to retrieve text in Grid View. The text was shown as one long string without any newline separators. She copied the text to editor, updated it and use SQL Update statement to save the text back to the database row. The problem was that all new line formatting was lost. SQL Server Management Studio didn't indicate new lines and causes ...
Spending the day at the Emerging Business Showcase in Deerfield Beach, FL just north of Ft Lauderdale. It is put on each year by the Enterprise Development Corp. of South Florida (EDC) (http://www.edc-tech.org/) and strategically held just a few miles from my house and a block from my office, what planning! The purpose is really just to get a bunch of venture capital, angel investors, lawyers and bankers together and the highlight is 14 startups giving short (3 min) presentations / demos of their ...
I am installing SQL Server 2005 Enterprise Edition on VISTA Ultimate and noticed that only client components are being installed. Setup shows an option to install “Server components” but never installs! However, the setup does give a warning for “SQL Server Edition Operating System Compatibility”. Solution: install SQL Server 2005 Developer Edition. Developer edition do not give operating system compatibility warning ...
I’ve become interested in a few aspects of SQL Server 2008. One is the new FILESTREAM datatype. The basic idea is to have a SQL datatype you can use in queries and searches and is managed by SQL but which does not have any particular size limitation. There are a number of articles on the multiple steps it takes to setup a database to utilize the new FILESTREAM features. I’m not going to cover that in this article. I highly recommend reading Paul Randal’s white paper on the subject, now published ...
The Network admin guys did some windows patch update on the WSS v3 - OS - Windows 2003 server Until after logging on to the site tried doing some searching and Oops no search results returned So i taught sure the services has stopped or i have to restart the service but after checking the services on the OS and the Sharepoint Central Admin everything thing looks ok. Well its time to look for a fix So what next and where to start . First was this Microsoft Support site: but didn't solve the problem. ...
“M” is a great language for modelling data. In many of the presentations and articles about “M” it has been mentioned that “M” is used for creating models that will be stored in the repository database. But it can also be used for modelling regular databases. This webcast will show how “M” can be used to create tables in a standard relational database. Some of the basic language features will be used to create types and extents. The model will then be enhanced to add constraints and relationships. ...
Here is a frustrating little error. The problem occurs when trying to print reports from a report server that is not properly updated on a client machine which has been. Updating the SQL Server installation using Microsoft Update (Not just Windows update) fixed this on my local development box, however I had to dig a little deeper to get it to work on our production box which is 64 bit. The root of the problem is this: If you are using SSRS to print the reports, the way it works is that an Active ...
PDC has come to an end and I’m sitting here reflecting on what I've experienced over the last few days. The PDC experience has been quite different than the Tech Ed or Dev Teach events I've attended in the past. There's a different vibe to PDC, and a different message that Microsoft is trying to get across. Where Tech Ed is all about teaching, PDC is all about telling. At PDC, Microsoft is describing the direction they're heading in for the next few years. They're giving us a glimpse into where they're ...
For a few weeks now we have had some problems with BizTalk tracking data not being right in some testing environments on a large project. The link below is to a forum post which discusses our problems (thanks Thiago for your help troubleshooting this): http://forums.microsoft.com... The basic problem was that for some reason tracking data seemed to be backing up in the messagebox and not getting through to the Tracking Database. We went through all ...
Using Reflection and ADO.NET to create a dynamic Data Layer In this article I will discuss using object oriented techniques and built-in ADO.NET functions to create a data layer which will essentially figure out what values to put into stored procedure parameters, dynamically assign types in ADO.NET and c#, get values from a database and assign them to object properties, and write the code in such a way that you won't have to rewrite it anytime soon; even if you add new objects into your solution ...
I spoke at SQL Saturday Orlando #8 on October 25th SQL Compact & Data Sync Intro to SQL Compact and Data Sync services. In this presentation we go over benefits of SQL Compact not only on a mobile device, but as an amazing alternative to locally cached data for occasionally connected devices like laptops. We will also go over Sync Services for SQL Compact. Nikita Polyakov Beginner 09:00 AM Download: SQL Server Compact 3.5 Service Pack 1 http://www.microsoft.com/sq... ...
NOTICE: Due to a scheduling conflicts as Halloween activities the October meeting has been moved 1 week to Wednesday, November 5th. Sorry for any inconvenience. .Net User Group Meeting location: At Lamar Advertising Wednesday, November 5th, 2008 5:45 PM - 8:15 PM Sponsored by: Portico Learning Solutions Presenter Jeremy Beckham BIO: Jeremy is a Senior Developer for High Power Consulting, Inc. and has over 5 years of experience in .Net and SQL Server development. He's worked on projects ranging from ...
They should have called it “Stockholm” instead of “Oslo”; they really should. “08”, pronounced “nollåtta”, or “jävla nollåtta” in the north of Sweden, is the nickname for Stockholmers (08 is the area code for Stockholm), so “PDC 08” would mean “PDC Stockholm” in Swedish. David Chappell Article As always, David Chappell has been following the development of “Oslo” and realted technologies from the early days. He has just had an article published on MSDN “Workflows, Services, and Models – A First Look ...
Creating Test Wildcards with a Common Table Expression in SQL Server 2005 I needed to create a SQL Server table of test wildcard strings ranging from ‘AA%’ through to ‘ZZ%’. This seemed to be a prime candidate for using recursion with a Common Table Expression (CTE). After a little playing around I came up with the following: with wildcards as (select char(65) + char(65) + '%' as wildcard, 65 as num1, 65 as num2 union all select char( case when num2 = 90 then num1 + 1 else num1 end) + char( case ...
Using “Update to a local variable” to calculate running totals in SQL. Recently I was looking at an existing view on a client's SQL server 2005 database. This view calculated the running total for a transaction amount from a table, but was performing very poorly. I had always believed there were three different methods for calculating a running total using TSQL: 1. Use a nested sub-query 2. Use a self join 3. Use Cursors My own personal preference was to use the cursors option. If the cursor guidelines ...
I'm at PDC, and glad I am as well. First, I need to thank the geeks with blogs people for the AWESOME t-shirt. Well done. The site looks great. Second, this whole cloud thing that you're reading about, if you're not here, is pretty cool. I agree with MS, this will be the big thing of the future. I just wish we knew what they were thinking for cost. Microsoft Azure will be a big deal. They've spent over two years of development on it, torn apart SQL server to make it happen, and are running some of ...
The VS 2010 CTP is out!!! It's very timing - the CTP was released for public download just one day before PDC 2008. Visual Studio 2010 and the .NET Framework 4.0 mark the next generation of developer tools. If you want to know the key innovations in this new release, please visit the official overview from Microsoft. This CTP is available only as a Virtual PC image, which can be downloaded here. Please note this VPC image requires Virtual PC 2007 SP1. If you haven't upgraded your VPC to SP1 yet, ...
Another requirement of the day, we need to search text in the sql server procedures. To be more specific I want to find which procedure is using my table named as “table_name”. So here is the quick query for that. select distinct so.name from sys.objects so inner join syscomments sc on so.object_id = sc.id where so.type = 'p' and sc.text like '%table_name%'. This will list all the procedures which are using “table_name”. Note: The query was originally created by Adil Aleem of Ln Technologies ...
[Source: http://geekswithblogs.net/E... At the SBUG meeting last week, my session on "ESB Guidance: A Real-World Implementation" was meant to end with a demonstration, but we ran out of time - and in any case what I'd intended to show was probably a bit ambitious, with plenty of this-is-bound-to-go-wrong points. But I've spent some time making it more solid and the code is available now on MSDN Code Gallery: ESB Guidance 1.0 Demonstration: TriathlonResults, if you want to have a look. You'll ...
After many long hours working on upgrading our clients intranet from SPS 2003 to MOSS, we completed the rollout over a very long weekend. Ed Buhain, the client and I spent a fair bit of time babysitting the process, tackling last minute gotchas as they came up. One of the final issues we had was after all of the time testing, debugging, prepping, etc we had not run through the upgrade process with the infrastructure update applied. I was fully prepared to do my workarounds in order to get all the ...
Please join us for a DBA SIGs Live Meeting on October 22, 2008 at noon EDT titled "Automating Common DBA Tasks". Meeting Abstract Database Administrators often spend hours each day doing the same repetitive tasks; checking Error Logs, Backups, Drive Space, Agent History, Job Logs, and other common "checklist" items. Learn how to easily automate these common tasks in SQL Server 2000, 2005 and 2008 using the tools that are already available in the Operating System and SQL Server. Presenter Bio Jonathan ...
GridViews and SharePoint Programming for SharePoint poses some challenges to the .NET developer. Of course first you should be familiar with .NET, I will be using c# in my examples here. One of the main development paths for SharePoint is to create modular functionality in Web Parts. Web Parts are great little chunks of a web page that you can cram anything you can think of into; however you won’t have the nice visual tools you are used to working with. For a simple “Hello World” type application ...
Last Updated: 10/17/08 I'm working in a test WSS 3.0 environment and I would like to be able to move a subsite with subsites to another environment. There are several ways to move a WSS 3.0 site. The first one I tried almost worked. I will document my attempts (and reason each attempt was or was not successful here. SharePoint Designer The technique: Create a placeholder for the new location of the site Use WSS 3.0 browser Create a site using the Blank Site template. Create a backup of the site to ...
I was in the process of using SqlSiteMapProvider class today by jeff which is a new feature of ASP.NET 2.0 and i have always wanted to try this out My main goal is to have a database driven site navigation interface with a securitytrimming feature which i know is possible But after running the sql script to insert some sample tables to the DB and setting upt the project in VS 2005. Ran F5 to run a sample page and bingo error: The SQL Server Service Broker for the current database is not enabled After ...
After setting up my Dell PowerEdge 2900 with Windows Server 2008 x64 and Hyper-V, I began the steps of creating virtual environments for things I work on. I already had a virtual SQL Server 2005 which was underutilized - 768 MB allocated RAM and one processor for my various development projects. I wanted to set up Microsoft Office SharePoint Server (MOSS) as a "mostly" single server install with the exception that I wanted to use the existing SQL Server 2005 installation instead of the embedded SQL ...
Aspiring Web Application Developer? Ever wonder: -"What would it take to start writing some websites in ASP.NET?" -"How do I setup and configure IIS[the web server] and set up SQL?" Wonder no more! There is a simple tool that will install IIS7, VWD Express 2008, SQL 2008 and proper .NET framework for you. Just load the tool, pick a scenario and you are ready in a few minutes! This would saved me some time getting and setting up all the products and settings myself. Awesome! Check out Microsoft Web ...
In the Baton Rouge Area with as open Tuesday afternoon? Check out the SQL Server Users Group Meeting this week. Location: At Lamar Advertising Thursday, October 23, 2008 5:45 PM - 8:00 PM Sponsored By: FuelTrac Presenter: Mike Huguet BIO Mike is an Enterprise Solutions Architect for Sparkhound, Inc. with over 9 years of experience in developing business solutions for Enterprise, Mid-market, and governmental customers. Five of those years have been as a consultant working with clients such as Jiffy ...
For the next few weeks I'm going to be turning my attentions to Microsoft SQL Server as the new version, 2008 is now with us and even has it's first big patch CU1. I am however not going to focus on coding as plenty of others on GWB have that sufficiently covered. It is fair to say that SQL Server has turned into a monster, it's far more than just a database product these days, it is a complete data management suit of tools. Some of the tools are fully fledged complex products in their own right ...