Tag | SQL Server Posts

This should work for SQL Server 2005/2008-- ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName example: ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture ...
Two areas I am looking at right now are SQL Azure and Entity Framework 4. PDC had plenty of content on both these areas. Just need to find the time to watch some of it! I have added direct links to the standard definition WMV and the PPTs to download (which is what I am doing right now). SQL Azure SQL Azure Database: Present and Future Windows Media Video PPT Using the Microsoft Sync Framework to Connect Apps to the Cloud Windows Media Video PPT The Future of Database Development with SQL Azure Windows ...
I was asked a little while back to pull together the best training resources for .NET development to feed into a MSDN UK site. I thought it would be useful to share here as well. By no means everything is listed but sometimes less is more :-). Enjoy: Top Tip: Watch out – these are sometimes big downloads. For instance I just downloaded a high def PDC2009 session at 600MB! I recommend you check out Free Download Manager – it is a great open source tool for working with large files. Offline Training ...
I had an issue recently with my SSAS 2008 performance counters - they were all showing up as 0. I could see them listed in Performance Monitor, but none of them worked. The counters for my SSAS 2005 instance worked fine, but the 2008 ones did not. I had observed this behaviour on my old Vista x86 machine and now it was happening on a fresh install of Windows 7 x64. I tried numerous steps to troubleshoot this issue including going through this detailed blog post from the CSS SQL Server Engineers blog, ...
There is a small configuration issue with the Microsoft Business Rules Composer in BizTalk Server 2009. This will only affect you if you deploy the rules engine by itself without the rest of BizTalk Server. In a full installation of BizTalk Server, BTS provides a set of BTS-specific Rule Framework components in as assembly called Microsoft.BizTalk.RuleEngin... This includes a RuleSetDeploymentDriver component that manages deployment of rules via the SQL Server repository. The BTS-specific ...
A big thanks to all those who attended http://edgeug.net/ last night to hear about SQL Azure and SQL Server 2008 R2. I really enjoyed it and once again “Merry Christmas”! Links http://bit.ly/startazure takes you to the getting started page for SQL Azure (and Windows Azure) Download SQL Server Management Studio R2 which works with SQL Azure Brief walkthrough of using SSMS R2 with SQL Azure (nice screenshots similar to what I showed in the first demo) Download the SQL Azure Migration Wizard http://twitter.com/ericnel ...
Last time I was taking a look at SubSonic’s SimpleRepository functionality and wondering about the return value of the ‘Add<T>’ method. More specifically, I was wondering why the ‘object’ instance being returned was typed as a decimal rather than an int when the object I was persisting had a primary key field that is typed as an int. I had discovered that the while Add<T> was returning a decimal, it was also updating the primary key field (PostID on my Post class instance in this case) ...
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; ...
Today was the first day of Microsoft's 2009 Professional Developer Conference, and it kicked off with a 2-hour keynote address led by Ray Ozzie. Ozzie enumerated various new features and launch dates for the Windows Azure Platform, including project "Dallas," a platform for open data feeds based on OData, an opened flavor of ADO.NET Data Services/Astoria. Ozzie also brought on customers and partners, including Automatic/WordPress, Kelley Blue Book, Seesmic and even US Federal CIO Vivek Kundra (via ...
Hot on the heels of one CTP (StreamInsight) and timed to coincide with the opening day of the PDC, Microsoft has just released the latest version of the technology formally known as 'Oslo'. SQL Server Modelling, as we must now learn to call it, has several improvements over the previous CTP release last May. Indeed, the previous CTP was characterised by behind-the-scenes code improvements and rewrites rather than new functionality. It is therefore doubly reassuring to see the slew of new features. ...
[This is the first in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009). ] When adding an Entity Data Model to a project you are given the option to: Generate the Model from an existing database (SQL Server, Oracle etc) or Start with an Empty Model and create your conceptual model (sometimes referred to as Application Model or Domain Model) first – adding new Entities and Associations ...
My thoughts and observations of this year’s Microsoft PDC conference in LA. Day 1: Just registered for the conference. They had many reps available to move attendees through the registration process. We arrived early, and had to stand in line for 15 minutes, while all the reps stared blankly back at us; “We don’t open until 7.” Wow.. Great Customer Service. Let me take this moment to comment on the Conference bag this year. ITS A CHEAP PIECE OF CRAP. Literally, it looks like a “reusable” grocery ...
Until recently, Microsoft’s policy toward Its Professional Developers Conference (PDC), was that it should be held only once every two or three years, and should focus on Redmond’s technology “futures.” This meant that currently- or imminently-shipping products were not to merit much coverage; instead, emerging technologies that were at least 18 months away (or thereabouts) from shipping would get the spotlight. Last year, that was mostly true. We got a pre-beta release of Windows 7, saw glimpses ...
I’ve been spending some time lately digging into SubSonic 3 and have really enjoyed working with it so far. I love the how “low friction” it is to get up and running. I’ve been particularly impressed with the SimpleRepository in this regard. It definitely lives up to it’s name by providing truly simple data access functionality in a pretty sane and straightforward way. That said I don’t think it’s the best choice for every project, but if you don’t have to care much about the implementation details ...
I just started the appetites with my last post on RoundhousE. RoundhousE itself has a migration sample to help you get familiar with how it works. You can get to that by using a subversion client to download the source. When you download the RoundhousE source from SVN and run build.bat, you get a code_drop folder. Go in there and look at the deployment folder for a sample run. Prerequisites: Locally installed (and running) SQL Server 2008 Run That Bad Boy When you get into the code_drop folder, take ...
It is Friday 13th Nov 2009 - which means it is the last day of TechEd Europe in Berlin. Overall I have had a good week – high quality sessions, lots of time with customers and colleagues and a very smooth conference throughout. I spent the week doing a bunch of things. 9am Monday I was presenting on Entity Framework 4 after 4 hours of sleep and using a brand new VPC after my original failed to load following yet another blue screen from the host (the machine will be flattened next week – perhaps ...
I like it when Microsoft bridges its technologies out to other platforms. I like the PHP Driver for SQL Server and the samples in the PHP On Windows Training Kit so much that I did a whole session on them at VSLive! last month. The ADO.NET Data Services (Astoria) bridges for PHP and Java are very exciting to me. The Silverlight plug-in for Eclipse, the Azure SDK for Java, and the Windows 7 support for Eclipse are all good stuff. To add to these recent developments, Microsoft has announced its acquisition ...
I have had a bit of a “SQL Azure” day at TechEd Europe. I sat through David Robinsons excellent intro to SQL Azure development (smooth, on time, great Q&A), caught up with David afterwards to exchange stories on SQL Azure and find out what I will be missing at PDC next week and then grabbed the chance to capture a short 10minute podcast which I will publish up on Channel 9 next week. David did his demos using a new version of SQL Server Management Studio which works with SQL Azure and announced ...
November Event: Highlights from the PASS Summit Michael DeFehr, Protegra The annual summit for the Professional Association for SQL Server was held in Seattle in the first week of November. With over 160 sessions, thousands of attendees and dozens of SQL server MVPs, it was a huge success and the information exchange was high-bandwidth to say the least. Mike DeFehr attended the event and is attempting to recover by attending another conference this week. He will be back in town and mostly recovered ...
When I started using SQLExpress 2005, everything works on my development machine – however when I wanted to access the database from another machine (trying to access the sqlexpress database remotely) I was not successful. I discovered the solution way back then, also through Google searches, which still yield a valid result. However, every now and then my peers would ask me this same question again. Thus I’m creating this blog so I can forward them to this page (instead of talking about it); it’ll ...
I am talking about the sixth item from my earlier post In a nutshell... Oslo initiative (Microsoft Modeling Platform for 10x development productivity) took several directions and finally ended up being just a DSL toolkit for “SQL Server Modeling”. Initially the scope of Oslo was broad in terms of brining both Business and IT closer by modeling all entities (both physical and logical) together in a heterogeneous enterprise environment. But now it seems, Microsoft narrowed down the scope to just a ...
I’ve previously described my reasoning for buying a business laptop like the HP 6910p, http://geekswithblogs.net/t... I’m now feeling even better about that decision after the latest ‘upgrade’ to my main laptop; adding a second internal hard drive to simplify my use of virtual machines. The problem I use virtual machines quite regularly. One major client has a legacy application that requires Visual Studio 2003, which in turn requires Windows XP Professional as ...
Overview There is sometimes an issue on the BizTalk Server, often following an operation such as an operating systems service pack installation, where the MSDTC settings can be reset from those that BizTalk requires to work. MSDTC - Microsoft Distributed Transaction Coordinator - is a transaction manager which permits client applications to include several different sources of data in one transaction and which then coordinates committing the distributed transaction across all the servers that are ...
This text is based on the Chris Pels video and code located here. ASP.NET Membership mechanism allows to use the build-in server tables to store and retrieve user data. By default, this mechanism can only be used with SQL Server database to which Microsoft provides suitable MembershipProvider class. Inheriting from this abstract class, developer can use his own table(-es) from any database and use any database engine other than SQL Server, like Oracle, DB2 etc. In this article I would like to show, ...

Thought this may be of interest to some SBUG Members as they will be discussing SQL Server 2008 R2 and SQL Azure at the Edge UG

 

http://edgeug.net/

 

Today a colleague ask me to help. On his system all ReSharper menus are grayed out. Also the Visual Studio Add-In Manager does not show this add-in. He tried: a new installation: without success, running with administrative privilegeg: without success, looking in event- and application-logs: no entries. After searching a little bit with old buddy google we found this message: Wild World of Visual Studio -- Mysterious Component We downloaded and installed the latest Microsoft Core XML Services (MSXML) ...
As I am digging more into SQL Azure, it seems choices for auditing will become a little bit more restricted. Generally speaking there are four ways to audit SQL Server statements; these mechanisms are used by various software vendors to deliver auditing capabilities for compliance mandates and for security reviews. However as we will see, many of the products will stop from working for SQL Azure due to some limitations imposed by the database. At a high level, the four auditing mechanisms are: Server-side ...
So you have stored procedure and it’s having issues. When you run it, it returns really fast. When .NET runs it, its like a dog. The first thing you learn about SQL Server is that it has something called ARITHABORT and it is turned on in SQL Management Studio and OFF in ADO.NET. Yeah you heard that right. OFF. So when you find this out, your first thought is WTF, mate?! Why do we have to make this hard on ourselves? Reference post: http://sqladvice.com/blogs/... ...
I am currently sitting in a seminar on BI in the Cloud by John Welch at the PASS Summit 2009. SQL Server Azure looks promising for a variety of applications. Currently it only supports SQL Server relational database services but future plans to include the BI stack of SQL Server. I have yet to see how loading of data is handled and security is handled but it seems to have a lot of potential for small data sets (< 10 GB). Couple of points: Apparently data manipulation is slower than normal SQL ...
If you have been using the SQL Azure Portal for creating SQL Databases and connecting to them from your SQL Server Management Studio, you would have realized the ability to query the Azure Cloud Databases from within the management studio. While this provides great opportunities in terms of relation capabilities and accessibility over the Cloud, there has been a recent upgrade to SQL Azure and in that process there has been a Firewall Support added to the SQL Azure Portal access. Specifically when ...
I stumbled across a recently released collection of guidance and best practices for SharePoint DBAs and those who love them. From the download page… “ This book is a guide for database administrators who implement or maintain Microsoft Office SharePoint Server 2007. It provides guidelines for improving the performance of Office SharePoint Server 2007 solutions that run on Microsoft SQL Server 2008…” Get it here in either doc or pdf formats ...
How time flies! Monthly Guild meetings, several code camps, an MVP Summit and oh yeah, that mobility app we did at work. We consumed 2008 and much of 2009 working with Microsoft on a serious development effort using Visual Studio 2008, SQL Server 2008, Sync Framework, SQL Server CE, Windows Mobile 6, Vista, Windows Server 2008, Windows Communication Framework, Windows Workflow, LINQ – have I left anything out? Learning our application requirements put Microsoft and the end of the fire hose for a ...
I will use the AdventureWorks database to demonstrate how to perform CRUD operations using LINQ. You can use LINQPad (a free tool) to execute your C# statements without going through the hassle of writing a program using Visual Studio 2008. Launch LINQPad, add your SQL Server Connection and select AdventureWorks as the Database. Remember to select C# Statement(s) as the Language Type. Create Record 1: Department newDept = new Department()2: {3: Name = "Consulting",4: GroupName = "Consulting",5: ModifiedDate ...
I just went through the process of creating a VHD for use by myself and some other members on my team. I had a pre-built base image with Windows Server 2008 and SQL Server 2008 Enterprise that I used to begin the process (Note: I was hoping to use Windows Server 2008 R2 but it appears it only comes in 64-bit and VirtualPC doesn’t support 64-bit). From there I installed Visual Studio 2010 Ultimate Beta 2 and Team Foundation Server 2010 Beta 2. Everything went extremely smoothly except for one small ...
Day 2 of the SharePoint Conference has just about come and gone, and I’ve shifted my focus from yesterday’s pure developer angle to topics of data and business intelligence. And there has been a lot to see. I’m sitting in the last session of the day, attending the “Business Intelligence Power Hour” and began the day with an in-depth look at SharePoint’s Business Connectivity Services (BCS, formerly known as the Business Data Catalog, or BDC). I work very closely with Microsoft Business Intelligence ...
October Event: Continuing T-SQL Development: Bullet-Dodging and Spoon-Bending Part 2 Michael DeFehr, Protegra Michael DeFehr continues his series on T-SQL development for the second Winnipeg SQL Server UG event, covering topics such as: Row Numbering and the OVER clause Table-valued Parameters Query Optimization and Tuning When: Wednesday, October 28th, 5:30 PM - 8:00 PM (Might be finished earlier, but won't go any later) Where: 17th Floor Conference Room, Richardson Building, One Lombard Place (If ...
Well finally I am dedicating myself (again) to starting up a blog about good practices in Business Intelligence using SQL Server 2005 & 2008. So just to prove to myself that this isn’t a fad I’ve downloaded the Microsoft Live Writer to help me publish this thing. Now all I need is to make things look a bit sexy and we’ll be off! I hope at least some of these articles will appear in your google searches to help you out of some annoying and tricky situations in SSIS, SSAS, SSRS & the SQL Server ...
I spoke last weekend at the Orlando SQL Saturday on the topic of SQL Server and the xml data type. I was somewhat concerned that my session would draw little attendees for several reasons. First, my session was in the last timeslot of the day, from 4:00 PM to 5:00 PM. Second, I was up against some tough competition. The organizers of the event had brought in Joe Celko to speak, and he was speaking at the same time I was. Buck Woody from Microsoft was also speaking, discussing the new Resource Governor ...
I have been working on database synchronization for a couple of weeks, and seems it at the final testing stage, I am using Microsoft Sync Framework 2.0, the DB server is SQL server 2008 Standard, and clients are SQL Server 2008 Express as I use Change Tracking to track DB changes instead of TombStone Tables and Guid tracking columns, I use WCF+IIS+SSL to host server side service, the binding uses Gzip binary encoding. The reason we are not using SQL Server Replication is because our tables need dynamic ...
This is my 100th post to this blog, but it’s also, in a real sense, my first. That’s because, starting now, my blog will be syndicated on RedDevNews.com and VisualStudioMagazine.com, the same sites that carry my monthly column, Redmond Review. For those who haven’t read my posts or columns before, allow me to present a quick intro. (For everyone else, go ahead and skip to the next paragraph.) My name is Andrew Brust, and I’m a Microsoft MVP and Regional Director. I don’t work for Microsoft – they’ve ...
Hello SQL Server Readers, You've probably seen multiple column update examples out there using syntax such as this: set (col1, col2) = (select col1, col2 from ...) You've also probably found that the above syntax is not SQL Server friendly. Apparently this is Oracle syntax and very well may work on other databases too, so long as they support 'row value constructors'. To make this work on SQL Server you'll need to make a few changes. But don't fret, when you see the example below you'll probably ...
Recently I had cause to investigate performance and tuning of BizTalk Server 2004, and found that although there was some useful and interesting information available, there was usually little actual guidance on how to apply even the simplest settings to your specific solution/environment. When you take a look at the guidance available for tuning IIS, there are some reasonably simple steps that you can follow to get you started; for example you can make some simple changes to machine.config based ...
Saber por qué puerto está atendiendo las peticiones tu servidor de bases de datos puede ser relevante, sobre todo si te pones a jugar con las configuraciones y le cambias todos los valores default durante la instalación. Según dicen, el puerto por default es el 1433. Si lo cambiaste sin querer, no te acuerdas o te topas con un papanatas que o lo cambió sin querer o no se acuerda, puedes ejecutar, desde el SQL Sever Management Studio el SP xp_readerrorlog. En el error log puedes ver mucha información ...
I haven't had much to post about for a while, but yesterday I decieded I was going to take Keramic Koala, the next release of Ubuntu Linux for a spin. I have an old machine sitting around, and I wanted to turn it into a subversion server. So I downloaded the CD image, and true to my past experience with Ubuntu, it downloaded blazing fast, being about 700 MB CD image in about 15 minutes. Burnt it, and popped it into my beastly machine. The machine I'm setting it up on, has 500GB Hard drive, Pentium ...
Full Disclosure: I was lucky enough to be sent a free review copy by the publisher But... if I had not been sent a review copy I would have gone out and bought a copy of this book anyway. Why is that? Because I had purchased the previous edition and I knew that it would be the most in depth book on SSAS 2008 available. It has been written by members of the product team and contains a wealth of information that just could not come from any other source. I'm sure most of you have heard that Attribute ...
Over the last couple of weeks I have dedicated quite some time to knowing Team Foundation Server (from here on out referred to as TFS) and the interaction between it and Visual Studio Team System/Team Explorer. The process has not been without pain, but with pain come great lessons. So, over the next days I will be posting here what was the success story of installation in both HTTP and then the process to get HTTPS in place too. But, how about starting to lay down the foundation of what the process ...
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), ...