Tag | SQL Server Posts

El día de ayer estaba intentando restaurar una base de datos, en un servidor diferente al que se creó y en el que la gente que lo administraba se había puesto a jugar con las configuraciones, permisos y logins como no tienen idea. El caso es que una restauración que puede llevar unos 3 ó 5 minutos, nos llevó poco más de 2 horas. El error: System.Data.SqlClient.SqlEr... The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::Validate... * ...
This series of posts is about overcoming a restriction, that O/R mappers like NHibernate have with respect to lazy loading and polymorphic type information. (Please refer to the problem description and example in part 1 and 1.5.) The previous part of this series demonstrated how we can fetch type-discriminating data from the db during the regular insert/update/retrieve lifecycle of an instance, along with its 'normal' data, and totally transparent from the domain perspective. This part now will show ...
October Meeting - 8 October 2009 6PM Our next meeting on October 8th, 2009 at Blackbaud on Daniel Island will feature the Greater Charleston .NET User Group meeting in one room with the brand new SQL Server User Group meeting in another room. Both groups will meet at the same location on the same night so you have a choice of which session you’d like to attend. This month the Greater Charleston .NET User Group is pleased to host Microsoft Developer Evangelist Glen Gordon who will give a presentation ...
Three’s a Charm It looks like the third iteration of Team Foundation Server might be a good one. I just finished reading Brian Harry’s post on TFS 2010 and it contains some interesting references. SourceSafe Replacement? I never could understand why TFS was often compared to SourceSafe. All the sessions on migrating from VSS to TFS, TFS for VSS users, etc. Is a team really going to migrate from VSS to TFS? Really? You have got to be kidding me! TFS is change management (to borrow a phrase from Rational), ...
Here’s a great list of new Azure and cloud related projects on CodePlex. All of these are very helpful tools. Client Cloud Services, Client Cloud Services (CCS) is a set of Windows Azure-based services which help application developers integrate licensing, trial management, feedback, error reporting and product usage into their applications Azure Storage Manager, Azure Storage Manager helps you organize your Azure Storage Accounts and to modify data on them. It is written in C# 3.5 and has no other ...
Sure many sharepoint Admin/ Developers/Architects must have come across this issue when trying to uninstall and re- install Sharepoint 2007. I have uninstalled sharepoint instance before just by going to the Add Remove programs and it was a breeze. But on my Dev server when i tried the same but nothing basically happened. The status bar did show as if it was uninstalled but when i go back and check nothing was removed :( I later found this which did help :www.howtonetworking.com/ms... ...
I created a brand spanking new environment, Server 2008 x64, SQL Server 2008, WSPBuilder, and Visual Studio 2008 Team Systems…All the awesome that you would expect out of a base development environment for SharePoint. I get to the Shared Service Provider and it keeps prompting me to authenticate repeatedly. I checked the logs and it looked like it wasn’t even passing credentials in the Event Viewer. I got that generic can’t pass the token or whatever error. So I thought maybe it’s related to a trusted ...
If you like to migrate your Web tier or the ASP.NET Application to Windows Azure, check my new posts Part I and Part II In the previous post we had examined on getting access to SQL Azure, creating your first database, accessing it with SQL Server Management Studio and then migrating the Northwind database schema to SQL Azure using the SQL Azure Migration Wizard Beta. UPDATE: The latest version of SQL Azure Migration Wizard migrates both Data and Schema. You can download the same from http://sqlazuremw.codeplex.... ...
If you like to migrate your Web tier or the ASP.NET Application to Windows Azure, check my new posts Part I and Part II SQL Azure is the latest buzz around Cloud Computing and the ability to take relational database to the cloud as is, is something most would welcome compared to the earlier model of ACE (Authority, Container, Entity) that was there when SQL Azure was SSDS. Well, like others, I also got interested and wanted to explore the SQL Azure. SQL Azure is currently in CTP and offers token ...
I was having in interesting discussion with Yossi Dahan following a recent SBUG meeting, as most user group sessions go the meeting was good but there was also some good discussion in the pub afterwards. Anyway we got onto the subject of caching and BizTalk and we discussed a few things I wrote ages ago about using NCache with BizTalk. As a follow up to this discussion I ran a few tests to get some rough figures to show some of the benefits of caching of data in this context. The previous article ...
Recently I upgraded to Windows 7 RTM and started setting up my machine. The usual set of tools I install are Visual Studio 2008, SQL Server 2008, Expression etc., Also, for .NET 3.5 and Visual Studio 2008 I would require to install the respective SP1 releases as well since they are mandatory and contain tons of new features as well. I had done this in the past in Windows Vista, Windows 7 RC etc., and while I was trying to install .NET 3.5 SP1 on the new Windows 7 RTM, it surprisingly, popped up a ...
What a pity. I’ve spent some time recently evaluating SQL Server 2008 Reporting Services with respect to its proposed use on a UK public sector project that will implement a part of the 'national infrastructure'. In every respect but one, Reporting Services provides an excellent fit for the stated requirements. There is already a commitment to using SQL Server, and SharePoint, within the project, so Reporting Services appears the way to go. What is the exception? Well, Reporting Services provides ...
This is one of a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. [Initual release 22nd Sept 2009] [Updated 23rd Sept, with links from Julie Lerman] [Updated 2nd Oct, with slidedeck section] [Large Update 15th Dec – including PDC09 content, my new posts and plenty of stuff from Julie L, Tony and others] This is my attempt to pull together all (ok – most) of the improvements in Entity Framework 4.0 and aggregate useful resources against each. It is very ...
This is the second in a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. In case you don’t want to skim through the whole post, the main things I learnt in day one are: 1. Never forget that install errors can be caused by something as simple as a corrupt file! (My “battle” outlined below) 2. Virtual PC RC for Windows 7 isn’t perfect. It doesn’t like working with a VM created on an older version. (Details below) 3. There are some nice storage explorer tools ...
Next week I am presenting two sessions at Software Architect 2009. Both sessions are new, new in the sense that I am creating them this week and new in the sense that whilst they are on topics I have experience with, in each case there is a significant new element for me to learn. I thought it would be fun and interesting (to me anyway!) to keep a diary of my preparations to get these sessions in good shape. The two 90minute sessions are: Design considerations for storing data in the cloud with Windows ...
I’m working on a presentation for the Baton Rouge .Net User Group in October on DI so I thought I’d go over some of the reasons to move to DI. Here’s my short list: Better design through loose coupling That’s about it. There are other reasons that I consider side effects of good design: Testability – easier to test components in isolation since their dependencies can be mocked Flexibility – easier to use alternative implementations since you only need to change the registered components Those are ...
While SQL Server security features continue to improve, hashing in SQL Server using native functions is simple, but not necessarily up to speed on the latest security specifications. The good news however, is that using extended stored procedures allows database developers to take advantage of the strength of .NET using the System.Security.Cryptography namespace. I started to evaluate Hashing capabilities within SQL 2005 and 2008 and as it turns out, hashing is extremely simple using the HASHBYTES ...
I am visiting beautiful city of Nashvillie, TN, US and involoved in rather interesting project involving WCF, silverlight and SQL server 2008. Also being used are Search server (FAST) / Lucene .Net Omniture (for Web analytics) Integration with Community server, Twitter, Facebook Velocity – Distributed caching. MemCache – Web server Cache I am also planning to use Nikhil’s MVVM Silverlight Fx at silverlight end or MEF LINQ / Enity framework - for ORM. That remind me of scenario where i had to register ...
I got this error on production for a report which was working fine in Dev and it took me a while to figure out the cause. Report's Data Source was pointing to a SQL Server View, when I looked at the SQL Query ( Database - > Show SQL Query ), I noticed that Database name was there with view name: "DbName.dbo.ViewName" I did a lot of googling, trying to figure out a way to change this behaviour and have just "dbo.ViewName" in SQL, but in vain. For now, I have fixed it by putting the SQL in the view ...
In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF, with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you want to fix it, but do not know how. Then one day you or someone at your firm has decided to do your SQL Server a favor and separate out SSRS from the ...
[Source: http://geekswithblogs.net/E... The ASP.NET Web Part framework uses a plug-in framework for loading and saving personalization data to a persistent source. Out of the box, a SQL Server data source is provided (via the aspnet_regsql tool), along with a SQL personalization provider – specified in the system.web configuration section: <webParts enableExport="true"> <personalization defaultProvider="SqlPersona... "> <providers> <add name="SqlPersonalizationPro... ...
September Meeting - 17 September 2009 6PM Two meetings for the price of one! This month we start up again after our summer break with a new twist to the user group experience here in Charleston…now you get 2 user groups for the price of 1! :) Our next meeting on September 17th, 2009 at Blackbaud on Daniel Island will feature the Greater Charleston .NET User Group meeting in one room with the brand new SQL Server User Group meeting in another room. Both groups will meet at the same location on the ...
I was asked to present on RIA Services with Silverlight for the FUNdamentals session of the East Bay .NET User Group last week. Even though I only had 30 minutes to present on the topic, I decided to show the full development of a CRUD application. With RIA Services this is a straight forward thing to do and still allowed time to explain the concepts in use. The solution found here is the code that was built during the demonstration at the user group. It shows the use of Entity Framework to connect ...
Let's face it: Setting up NHibernate is not one of the easiest tasks. You need a good knowledge of the system, and you need to write some configuration xml to your config files (well, normally). This is not such a big deal for the main project, since you only have to do it once in a project's lifetime. But you also have to care about setting it up for each and every test project that uses NHibernate, and there might be a lot of them if you're consequently unit testing just about everything. So, wouldn't ...
Turing Project Page: [Novice: 9 | Advanced: 6 ] FAQ | Table of Contents | Definitions What is this and where do I start? [Reposted here while my primary blog is sorted out ] From Database to DataGrid The next step in Project Turing is to create a first iteration of the Silverlight application that will retrieve data from our database. Using our technology of choice: the Data Entity Framework coupled with .Net RIA Services. .Net RIA Services will allow us to create business logic on the server and ...
Well, hey there you poor unsuspecting folks out there?! That's right. I made a blog ( I know what your thinking.. and yes they do let just anybody get one now adays...). I'm now a completely one of a .. million developers out there who have blogs! Yay Me! On a more serious note, I'm going to answer a few questions: Why Did I Create a Blog? Why not? And also, cause I figured it's a good way to force people to hear my opinions on stuff <insert evil laugh here>. I think it's also a good way to ...
Today I ran into this problem when setting up the SQL Server Management Tools for SQL Server 2005. Like any good little code slinger, I googled (if you are particular to Microsoft, you can read that as “binged”) to see who’s had the problem, because it’s no news that when you aren’t on the crest of the tech wave that someone else has had the same issue. In particular, MSXML 6 would fail and the log would have a message similar to: MSI (s) (40:58) [22:16:00:859]: MainEngineThread is returning 1605 ...
Almost every software project comes with a database. Sometimes it will be developed from scratch and in parallel with the actual domain model for a new (aka. 'greenfield') project, sometimes it will be a pre-existent datastore provided by the customer or coming from an already running software that has to be extended (then we can call it a 'brownfield' project). In either case, you will likely end up with a bunch of database scripts that need to be executed as part of your installation process. I ...
I’m participating in the Microsoft Gemini CTP (Gemini is the self-service BI component cooperatively provided by the forthcoming SQL Server 2008 R2, Excel 2010 and SharePoint 2010) and the SQL Azure CTP. I found intriguing the question of whether these two CTP technologies could be used together. Turns out they can! I successfully got Gemini to import data from a SQL Azure Database (after migrating the AdventureWorksDW2008 dimCurrency table into an Azure database called AWCloud)! I set up the connection ...
A little while back I posted a question on Channel 9 wanting to know more about SQL Server ‘Madison’ project. Well Charles Torre being the extremely nice bloke that he is (Thanks Charles I owe you another beer, perhaps not London Pride next time!) got on a plane from Redmond down to Orange County and went to pay the Madison development team and in particular Christian Kleinerman for is the Product Unit Manager for the Madison development, a visit The video is a good introduction into Madison, it ...
The Regina Technology Community welcomes Nick Nastic! Topic: SQL Server 2008 R2 and project codename "Madison" SQL Server 2008 R2 is the next generation of the Microsoft SQL Server database platform, planned for release in the first half of 2010. SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help organizations improve IT and developer efficiency with: new and enhanced tools for the management of applications and multiple servers master data services complex event processing ...
I am happy to announce the launch of the Regina Technology Community. The Regina Technology Community has formed from a consortium of local special interest groups: • .NET User Group • IT Pro User Group • SQL Server User Group • SharePoint User Group We recognize that no technology is an island. We work in technological ecosystems that requires an understanding of many disciplines. Having one community allows us to deliver a wide spectrum of content to our members. It also provides the forum for ...
What is Sharepoint? SharePoint is Microsoft's product in the Enterprise Portal, Content Management and Colloboration space. SharePoint is actually 2 products. Windows SharePoint Services (WSS) - This is what is bundled into Windows Server 2003 and later versions and includes the set of standard site templates for building web sites in SharePoint. In addition WSS includes version control, alerts, RSS feeds ans task notifications. WSS is bundled into Windows Server 2003 and greater and I believe that ...
Steps to make a disaster back up: Record which Web applications are associated with the SSPs · Perform a full back up of the SSPs. · Completely stop the farm by stopping the services associated with Office SharePoint Server 2007 and by stopping Internet Information Services (IIS). · Back up the following databases by using SQL Server 2005 tools: o Content databases o Central Administration content database o Configuration database o Windows SharePoint Services Help Search database o Back Up the SQL ...
The Baton Rouge Area SQL Server User Group has started up a technology live meeting during lunch time. Please see Patrick Leblanc’s blog for more details in participating both as a presenter and as a participate. This is available from anywhere and is not restricted to Louisiana. Also, even though it has “SQL” in the name the topics can veer off of SQL Server topics such as a topic on .NET development. This is a great avenue to test out your presentation skills since it is a short live meeting event. ...
This past week I was reminded of the “fun” in which hosting an application within SharePoint can present. We are developing a custom application for our client in which some areas must reside within a SharePoint environment. We did quite a bit of our development in this first iteration within a web application in order to pull things together and present the client with a working end-to-end “prototype.” The architecture is composed of several layers all of which will be “in process” communications ...
I’m very pleased to announce the newest technical community to Manitoba: the Winnipeg SQL Server User Group, a PASS Associated Organization! Myself and Michael DeFehr are running this group and are excited to provide a forum for database professionals working in the Microsoft space. Here are the details for our first event: T-SQL Development: Bullet-Dodging and Spoon-Bending Michael DeFehr, Protegra Did you think you could dodge bullets with SQL server? Well if you learn some of these techniques, ...
On October 14th, 2009, Winnipeg will be the site of the first annual SDEC09 – Software Development and Evolution Conference, hosted by Protegra! We’re really excited to put this on and think its going to be an awesome event! The cost of the conference is $100 until September 18th and $150 after that. What do you get for that low admission fee? Three Tracks of Sessions: Development Foundation Skills Learn best practices on how to use developmental skills such as test driven development, SOLID principles, ...
In some scenarios, you may have a database that contains text data in a column which is restricted to a certain set of discrete values. In such a case it is a good idea to use an enumeration for representing these data in your domain. - I occasionally came across this situation when I had to deal with legacy databases with large amounts of pre-existing data. - This post demonstrates an easy and effective way to put this "enum value vs. database string" mapping under test, using the xUnit.net unit ...
In large projects you may have have a big number of enumerations in your domain code that have all to be kept in sync with some corresponding database stuff. Ensuring this correspondence is boring, repetitive and error-prone. Because it is such a tedious task, chances are that you don't check this at all, opening the door for serious runtime failures - especially when the project is nearing the deadline and things generally tend to become a bit more chaotic. I love enums. I use them wherever possible. ...
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... ...