Tag | SQL Server Posts

Hello Folks, Today I'll will mention the Microsoft SQL Server 2008 Fileds data types, you need to choose the right data type for the database fileds for more speed efficency, and i think the most important thing the fundamental of the database itself. Let's begin: char: the char datatype is ifxed in length, if you enter fewer that than the number of character defined the remaining length will be space filled to the right; use this data type when the column dat is to be of fixed length, which tends ...
Here I am after a week of putting Windows 7 to the test while working frantically on a tight timeline project and am happy to say that all is well. It has crashed a time or two and I still cannot install Visio 2007 or SQL Server 2008 Developer Edition, but I am still pleased. It seems to be faster than XP and I quickly got the hang of using the UI and the search feature. There are quite a few handy conveniences that will make life easier such as the RDP client has a recently used list. I went ahead ...
This week I had a need for NUnit based unit testing against a class that depended on a provided SqlConnection. Up to this point I had been able to mock external objects and their behavior based on interfaces, but with a SqlConnection I could not mock. There are some options for mocking the SqlConnection such as TypeMock, but I needed a realistic connection to test against. This also proved as a good method for building the expected DB interface. The solution that worked best for my environment (only ...
Historically I have always viewed ASP.NET session state as “pure evil.” In-proc session state is about as unreliable as you can get given that you can have timeouts, ASP.NET might recycle itself, IIS might get bounced, no scalability, and cannot work in a web farm. SQL Session state is very resilient and works in web farm scenarios but the performance is not good and at that point you might as well be better off writing your own strongly-typed data access layer rather than blobbing everything in ...

Again a nice arctile by Don Jones, where he talks about different SQL Server backup options and disaster recovery plans...a good read.

SQL Server Disaster Recovery by Don Jones

A good article about types of SQL Server Indexes and how to optimize them when they go bad...

Optimizing SQL Server Indexes by Don Jones

Just some code to get the time part only from a DateTime field (is SQL Server 2000 or 2005), with the date set to a reference date declare @timetest datetime declare @refdate datetime set @timetest = getdate() set @refdate = '30 Dec 1899 00:00:00' select @timetest , @refdate , dateadd(day, datediff(day, @refdate , @timetest), @refdate ) -- date part only , dateadd(day, datediff(day, @refdate , @timetest) * -1, @timetest) -- time part only, with reference date Instead of @refdate, you could use 0 ...
I decided to join in on the fad and perform a dual boot installation of Windows 7 RTM on my laptop with Windows XP. I am working on a project with a pretty tight timeline so installing from scratch was way too risky. I took the advice from some of my co-workers and went for the dual boot option by creating a partition using Acronis Disk Director in which to install the new OS. I created a 30 GB partition and started installing with the DVD that was created from the ISO. The installation was super ...
SQL Server 2008 R2 August CTP has just been released on MSDN and will be publically available on Wednesday. One little point grabbed my attention. The forthcoming CEP engine, formally known as 'Orinoco' (this codename was never meant to be used outside the company, but nevertheless made its way into the public domain) now has a proper name – ‘StreamInsight’ to be precise. Microsoft SteamInsight isn’t included in the SQL Server CTP. However, a separate CTP is due to be released in the next few weeks ...
A few years back I was the technical owner for SQL Server 2005 readiness in the UK with Independent Software Vendors. One of the things we did at the time was put together a detailed catalogue of UK developed applications that worked great with SQL Server 2005. My marketing buddy at the time was Ian Moulster and I just spotted he is doing something similar for Windows 7. Check out Ians explanation or.. 1: if (YourCompany.Country == UK && YourApplication.SupportedOS == OS.Win7) 2: { 3: Email.SendEmail("Win7Direct... ...
For one of our new requirement , We have got into a situation in which we need to fire a SMS whenever an insert or update is happened in a database table. I gone through some articles and found out some methodologies to achieve this, 1. Query Notification (have more dependencies and complicated) 2. SQL CLR Triggers (Less dependencies , easy to understand and implement) I decided to implement SQL CLR triggers and got success also in that. Now let me share the things what I have done for implementing ...
Jeremy Wiebe here at Imaginet created a handy tool for managing SQL aliases: The SQL Aliaser tool aims to solve one small problem: managing an alias for a SQL Server. This tool allows you to alias a remote SQL Server to your local SQL Server. Currently it is very limited in functionality, but it makes the process of flipping between the remote SQL Server and your local instance as easy as clicking a single button. This release supports 64-bit platforms. Future releases may add support for multiple ...
In my previous article, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes. Now, seems that most of the developers are asking if how to save all the data that was entered from the dynamic textbox in the GridView to the database. So in this example, I’m going to show on how to save them all in the database. To get started then lets create a sample Table in SQL Server. In this example, I named the table as “SampleTable” with the following fields below: Note: I set the ...
Book “SOA Patterns with BizTalk Server 2009” by Richard Seroter, review Here is a page from publisher ([PACKT] Publishing) http://www.packtpub.com/soa... Questions: Who is the reader of this book? What is the knowledge and experience level of the reader? How good is the book structure? I think the reader should be a seasoned BizTalk developer. It is not for an entry level developer. This book is for architects, but for architects with wealthy knowledge of the BizTalk. ...

Here is a good document describing how to configure and maintain a BizTalk 2009 installation. Everything from configuring Windows Server and SQL Server to performing load and throughput testing is described.

Much as people love hearing on the new features of ASP.NET, one of the frequent requests that I receive is around performance counters, high transactional sites using ASP.NET and real world applications that do very well on ASP.NET. While there are thousands of sites out there running on ASP.NET, many of them being mission critical, our own Windows Update is a great example of high performance. Windows Update is something all of us use, whether we like it or not. It helps maintain your system up ...
So when I first started working with SQL Server 2008 and LINQ, I would pretty much just use the LinqDataSource because it was definitely the easiest to use. It’s pretty good for testing purposes, or really small projects, but if you’re doing anything that is going to grow / is large already, then you’ll probably not want all that logic embedded in your pages. As I became more comfortable with LINQ, I decided to take on the task of switching over to the ObjectDataSource to bind to my ListViews. Here’s ...
The project I am currently on encompasses a large push to clean-up and standardize the client's Reporting library. Currently, there are around 70 odd reports that were created and/or worked-on by an assortment of consultants and employees over the span of several years. This process was very organic, responding to the needs of the moment without any over-arcing design philosophy or guidance. As a result, there is very little consistency in how these reports are structured, or how the settings are ...
Ran into a slightly problematic issue today: I was working on an SSRS report project which had been pulled down from source control. The project contains several reports, each of which contains a number of embedded images. I was tasked with developing a number of new reports, each of which had to follow the same styling. All well and good so far, but I quickly realised that the source image files had not also been committed to version control; the images existed only within the XML of the report ...
I was trying to export data from a txt/csv file to sql server table. After setting up the package and executed it .It worked if the sql server destination is on the same server were i ran the package from. But when i tried to export the data to a different server i get the error:- [SQL Server Destination [2625]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: ...
When you try to verify the installation of the Analysis Extensions in AX, you should be able to see the Analysis Database in the Administration->Setup-&g... Administration –> OLAP Administration Form. In case, you don’t see it then there is some problem with the Analysis Server Validation done by AX. This case arises when you are working on Windows Server 2008 with SQL Server 2008. There is a patch available on Microsoft Microsoft SQL Server 2005 Management Objects Collection, just download ...
What is Kerberos Authentication? Kerberos (or Cerberus) was a three-headed dog in Greek Mythology which guarded the gates of Haides (King of underworld God of Death). Kerberos was responsible to prevent ghosts of the dead from leaving the underworld. The Kerberos Protocol was created by MIT as a solution to network security problems like: 1) Insecure unencrypted password over the internet 2) Firewalls, which assumes that the bad guys are outside the network, what about the Bad Guys within the network. ...
I’ve started a thread on Channel 9 to ask my questions about Madison, Gemini and Kilimanjaro which is now 2008 R2. If you’ve got any burning questions why don’t you put them there as well. The Channel 9 team are planning to do a series of video’s with the SQL Server Dev Group so they will put our questions to them. The Channel 9 thread can be found here : http://channel9.msdn.com/fo... Technorati Tags: SQL Server,SQL Server Madison,SQL ...
I wasn’t 100% sure myself so I clarified with MS that the restricted license of SQL Server standard that comes with Team Foundation Server 2008 is limited to SQL Server 2005 standard. In short, even though SQL 2008 Standard or Enterprise is supported with TFS 2008, you MUST LICENSE IT SEPERATELY from your TFS license. This is consistent with what you read in the VSTS 2008 Licensing Whitepaper. Technorati Tags: TFS,Install,SQL Server ...
Arnon Rotem-Gal-Oz wrote an article for Architect Zone where he makes the claim that CRUD is bad for REST. I couldn’t disagree more, so I felt it important to respond to his criticism. CRUD which stands for Create, Read, Update and Delete, are the four basic database operations. Some of the HTTP verbs, namely POST, GET, PUT and DELETE (there are others like OPTIONS or HEAD) seem to have a 1-1 mapping to CRUD. As I said earlier they don’t. The table below briefly contrast HTTP verbs and CRUD Actually, ...
Normal 0 false false false 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-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"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} ...
I don’t approve of calling a WCF server from SQL Server, but there was a business requirement that had to be met. It concerned regulations regarding the safeguarding of certain data elements. Due to performance issues and the application’s infrastructure, calling the service from the application itself wasn’t an option. Coding the CLR functions were the easy part. To do this, reference the Microsoft.SqlServer.Server and System.Data.SqlTypes namespaces (contained in System.Data.dll) and set the appropriate ...
In March 2008 we announced SQL Server Data Services. In October 2008 we renamed it to SQL Data Services, part of SQL Services. In July 2009 we renamed it to SQL Azure Database, part of SQL Azure. Same technology, same team – smarter naming :-) Smarter because people were getting confused between SQL Data Services and ADO.NET Data Services (totally different “things”) and the OS you will use in front of SQL Azure is Windows Azure. I wonder what will happen to .NET Services ...
I am a keen believer when building applications in having a clean logical architecture with separation of concerns as much as possible – taking into account the goals of the project and the environment in which the application will be maintained. As such, when it makes sense I believe in use of MVC, MVP, MVVM etc type patterns to enable efficient development and maintenance of applications. I can testify to the worth of adopting these styles to improve the quality of products developed from my experience ...

When setting up Reporting Services for SQL Server 2005 I ran into this error.  The resolution was ultimately found in the thread described below - HTH.

http://www.developmentnow.com/g/115_2006_4_0_0_732993/Database-versipn-C-0-8-40-does-not-match.htm

When building applications we usually want to adopt the write once user everywhere or DRY (Don’t Repeat Yourself) goals for simpler maintenance, validation, configuration,etc etc. So for business applications the situation is usually develop a control, that can be re-used and that can have different data bound to it for the situation in which it is used. Silverlight has a fantastic mechanism – the Silverlight Property System - that manages data binding among other things. This means that the late ...
I wanted to create a custom alert on the SQL Database when number of records with some values(considered as invalid) exceeds the expected limit. First of all you need to Set up Database Mail for SQL 2005 and follow procedure How to setup SQL Server alerts and email operator notifications IMPORTANT: don't forget to Restart SQL Agent to activate settings. Similar to the article Define custom error messages in SQL Server 2005 I've defined the error EXEC sp_addmessage 60001, 1, N'Number of not-processed ...
This is the final post in a four part series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 3. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight ...
This is the second post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 1. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight Toolkit ...
I’ve had this tendency to deploy CLR Functions manually by providing the dll and scripts to the data management team. This has generally worked out great, and I’ve always thought I’d have a dba available to perform the database duties. Imagine my surprise when I could not contact anyone today. Apparently database administrators take their holidays and vacations seriously (it’s Independence Day weekend for my non-American readers). Another developer asked me why I couldn’t deploy my clr functions ...
This is the first post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. This post is beginners stuff - there’s nothing advanced here. Most readers with some experience of Silverlight will learn nothing from this post, but I want to start at the beginning so those of you who are relatively new to Silverlight can see how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app ...
In January and March 2009 I presented to the East Bay .NET and San Francisco Bay .NET user groups respectively on how to build business applications in Silverlight. The theme of the presentations was to show how developing line of business applications in Silverlight is extremely similar to other technologies like Win Forms, WPF or ASP.NET. I demoed how to build a simple CRUD application in Silverlight hitting a SQL Server database over WCF. The building of the application during the presentation ...
How is it that you still can't save workspaces in SQL Server Management Studio as of version 2008?  It seems like such a simple thing to implement.  Quite often I create a bunch of different queries during a short period that are specific to a task I'm working on and that won't be needed once the task is completed, and rather than having to save each one it would be nice if I could just save a workspace file that knows which queries were open.
After some time working on another SQL CLR I am getting an error Request for the permission of type 'System.Data.SqlClient.SqlC... System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=' failed. This procedure needed to access a stored procedure on a remote server. Running that stored procedure within SQL Server Management Studio completed successfully. It just would not execute from my SQL CLR ! Doing online research did not lead to a solution. Nearly completely tired I dropped ...
I was doing some new CLR Stored Procedures in SQL Server 2005 and at a certain point received error: CREATE ASSEMBLY failed because method 'MyMethod' on type 'StoredProcedures' in safe assembly 'MyAssembly' is storing to a static field. Storing to a static field is not allowed in safe assemblies. Interestingly, despite all the procedures inside SQL CLR stored procedures have to be declared as static, no static fields are allowed outside them. So in my case declaring a static variable outside SqlProcedure. ...
Many organizations are faced with the threat of data theft, from which legal battles, hefty fines and negative publicity can arise. Interestingly enough stealing data is not always that difficult. In this post we will review certain aspects of data masking, a technique used to disguise personable and sensitive information. Data masking encompasses two key areas: in-flight and at-rest. In-flight data masking is different than encryption; the goal of this technique is to temporarily transform data ...
I pre-ordered this book by Richard Seroter and eagerly awaited its delivery, but due to work commitments I have not really been able to give it the time it needed. Things are a bit quieter now so I thought I’d bite the bullet and work my way through it. I have to say I rather like the book; it is a good mixture of BizTalk Server 101 and BizTalk Server arcana. For me the book is split in to 3 distinct parts, with Part 1 covering Chapters 1 – 4 and what I would call “Introduction and Background”, Part ...
If you are the minority who have been following my blog from the beginning you would know I am an avid practitioner and developer that centre on Microsoft SharePoint, and associated technologies. So some people may be thinking why write about Commerce Server? Is there any association between this and Microsoft Office SharePoint server (MOSS)? Well the answer is yes and no. In my earlier blog I briefly introduced Commerce Server, and this is hopefully the start of my series of articles introducing ...
I was setting up a SQL Server instance on my co-located server, but a series of events led me to uninstall it and reinstall it a few times. The final time through, it detected the original reporting services database, so I cancelled the installation and deleted the SQL Server folders. At that point I spent the next hour or so trying to make SQL Server get past the setup bootstrap installation. The setup program told me everything was okay before it began the installation. The problem was, the installer ...
Microsoft Online Services – Online is not always Online As a software engineer for a small Microsoft Partner – I have had a blast working with the enterprise technologies – especially since the release of the beta bits of MOSS 2007. The firm I work for is also a Microsoft Hosted Services Partner, and we host key technologies like Exchange, MOSS, Dynamics CRM, SQL Server and the latest craze – the Business Productivity Suite. The following is a blurb from the MSFT Help About BPS Online: The Business ...
The last 2 months have been a whirl. The company I'm with is busy building out our business intelligence team and I'm catching up on SQL Server 2008 internals. We've got ETL packages in SSIS grabbing data from service providers in Excel and have been dealing with Jet / unicode issues. Gotta love "IMEX=1" in your connection string.... So this is my first blog entry, ever. About me: I'm a SQL database project manager in the Asset Management business. The company purchases or manages pools of sub/non-performing ...
So, somehow within the past five years I’ve mapped out my life to lead to a point where I’m sitting here blogging on GeeksWithBlogs.net. I never would have guessed it…lol There’s no need for me to sweat it though. I’m a 23 year old IT college graduate that has a full time software development job, an amazing family, a loving girlfriend, and incredible friends. As one of my co-workers recently put it: “I’m livin’ the dream” :) I'm a former employee of iPay Technologies and currently work for Republic ...
Many times, I installed SQL Server 2008 and failed with just the error message “Access Denied”. One of the cases I found is that my Administrator account doesn’t have SeDebugPrivilege especially when GPO policy is in effect. I still don’t understand why anyone should be admin but cannot debug things :( Check out the following links for more information: http://blogs.msdn.com/joaol... http://social.msdn.microsof... ...
I have just encounted an unusual database problem. My dev BizTalk server suddenly ran out of space. Initially I thought it was the transaction logs. No luck there they were well within normal limits. I did check the size ot the 'Microsoft SQL Server' directory. It was over 8GB. The volume was traced to the LOG directory. SQL was pumping out 4 MB of error log every 10 seconds. After fighting with the server to free up some disk space, I checked out the error files. The parts appear to be: ***Stack ...
Microsoft Community in Bangladesh proudly presents Microsoft Day @ Dhaka. This is a special day dedicated to all Microsoft technology professionals and students in Bangladesh. We will be having the best Microsoft community technologists from Bangladesh - Microsoft Most Valuable Professionals (MVPs) delivering sessions at the event. This technology marathon is a great opportunity to learn from the best and network with each other. Both Microsoft developers and networking professionals would find the ...