Tag | SQL Posts

Readers of my blog and/or column know that I am a big fan of PowerPivot. And because of that, I was excited to see, both at June’s Microsoft BI Conference (part of Tech Ed) and this week’s PASS Summit, that the PowerPivot technology will become more entrenched. What Microsoft showed in June was that the full-fledged SQL Server Analysis Services (SSAS) product would support the in-memory BI (IMBI) engine, known within Microsoft as VertiPaq. This cool columnar, in-memory technology will not be limited ...
I needed to downgrade SQL Server 2008 from Enterprise to Standard on a Server 2008 machine, and and kept getting this error when trying to uninstall: SQL Server Setup has encountered the following error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created It turns out the setup utility really doesn't like having ANY other windows open - I closed the Server Manager window and it worked ...
As you know I’m working in Ethos as an architecture and azure expert. Our company will arrange an azure training plus hands-on labs in December in Beijing office. And I will be one of the trainer which would be very existing. If you are in Beijing and can undersand Chinese (we will use Chinese in the training) and more important, if you are intrested in Azure just like me, please find the training details as follows. The training fee is 300RMB with the seats, computers and dinner. In order ensure ...
Wow. There were a stack of announcements made at the key note. So I thought I would try to jot then down while I'm just waiting for my first technical session a Deep Dive on PowerPivot to start. The Parallel Data Warehouse Edition of SQL Server 2008 R2 has been released to manufacturing, there was a demo with a query over an 800 Billion record table that was returning in 19 seconds on a 40 node parallel cluster. Yahoo came up and talked about an SSAS cube of theirs, it's 12TB in size and they load ...
In this Issue: Ryan Alford(-2-), Joe McBride, Rob Tiffany, Pete Brown, Charles Petzold(-2-), Alfred Astort, Mark Hopkins, Nokola, Chris Klug, Gergely Orosz, and Adam Barney. Above the Fold: Silverlight: "Creating a Metro UI Style Control" Joe McBride WP7: "Ready for take-off? Top 10 things to check when you think you are done with your application" Alfred Astort Shoutouts: Adam Barney posted his "Introduction to the MVVM UI Pattern": Slides and Demo from Iowa Code Camp Damon Payne gave a WP7 presentation ...
Recently I have been given a short term assignment to develop a number of reports in Crystal Reports. Upon arriving to the client location I quickly found out that the only tool I will be using to create the reports is basically the Crystal Reports itself. My initial look at the database quickly revealed that the database structure is far from perfect and that it has some confusing table relationships, another hurdle was in the fact that several columns in various tables were user customizable for ...
I recently migrated my dev environment to a new pc. I moved over all the databases and reattached them. Unfortunately, I soon discovered my SSBS services weren’t working. I was sending messages to my service, but nothing was showing up in the queue. I added logging and monitoring to the stored procs that act as an entry point to the services, and the stored procs I use for activation. Still, nothing. When I ran the Broker Server Diagnostic tool (ssbdiagnose) (available in {Program files}\Microsoft ...
Turns out you can't just move a TFS warehouse/cube from SQL Server 2005 to 2008... Once performed we got the following error on the TFS app server tier - when we tried to update/process the cube (both manually and via the TFS scheduler service): Detailed Message: Failed to load adapter Microsoft.TeamFoundation.Wa... Exception Info: \n Microsoft.TeamFoundation.Se... Error encountered when creating connection to Analysis Services. Contact ...
Brent Ozar and Tim Ford announced today they have two SQL Cruises planned for 2011. If you don't know what a SQL Cruise is, you are missing out. Hop on over to their SQL Cruise site for information, but I'll briefly tell you that Brent and Tim have found themselves a niche. Brent and Tim simply reserved some space on a cruise ship, and for a low price for the cruise and a VERY low price for quality training, you are enjoying quality time with fellow SQL folks as well as relaxing as you travel to ...
Our SQL Azure book is finally done! After months of work, research (and waiting for Service Updates ) the book is finally finished. We spent a lot of time on this book, and we wanted to let you know it is out and ready for reading. It should be available on Amazon and other sites know. For topics, we cover the following: Getting Started with SQL Azure SQL Azure Design Considerations Setting up and Configuring your SQL Azure Environment Security Data Migration and Backup Strategy Programming SQL Azure ...
Next week is the 2010 PASS conference. This will be my second PASS conference and I'm really looking forward to it. The content is great and I love the chance to meet up in person with all the really great people in the SQL community that come from all different parts of the world just to talk about SQL Server. On Tuesday 9th for Lunch I am hosting a "Birds of a Feather" table on "SSAS Triple A – Administration, Automation and APIs". Between PowerSSAS, BIDSHelper and the ASSP projects on codeplex ...
One of the key performance concepts in Analysis Services is the design and use of good Aggregations to support user queries. However, Analysis Services (Both 2005 and 2008) by default is not configured very well to take advantage of multi-processor environments for parallel processing of these indexes, particularly for large MOLAP partitions. Keep in mind, using a large portion of available processors for aggregation building is only desirable in environments where a processing window is allocated ...
The async one was very easy to do. However, in the process automation task I was given, there was a need to execute SQL Job and waiting for the execution result. I couldn't find anything on the web to do what I wanted, so I make the following stored procedure. In addition, this stored procedure is quasi-synchronous. I start the job and then check the status. You can change the timing of the status check, but for the example below, it is "synchronous within 30 seconds." I wish there is a better way ...
My team is pulling together a great afternoon on the 25th of this month to help UK ISVs get up to speed on the latest technologies from Microsoft and explore their impact on product roadmaps. The session is intended for technical decision makers including senior developers and architects. Technologies such as the Windows Azure Platform, SQL Server 2008, Windows Phone 7, SharePoint 2010 and Internet Explorer 9.0 will be represented. Check out the agenda and register before all the seats vanish ...
I didn’t go to the Microsoft’s PDC Professional Developer’s Conference (PDC) this year because it was, as far as I could tell, a made-for-streaming video event. As such, I watched the keynote about 24 hours after it took place and used my Media Center PC to watch it on my plasma television. And I have to say, the keynote was worthy of the medium. Not only did the Silverlight Smooth Streaming technology deliver a fine HD image, but the content of the keynote itself, merited a big screen, and necessitated ...
In this Issue: Michael Washington, Dennis Doomen, Mark Monster, Brian Genisio, Jeff Blankenburg, and Colin Melia. Above the Fold: Silverlight: "My Silverlight 4 Reference Architecture: ViewModels, Coroutines and Binding Conventions" Dennis Doomen WP7: "A Step-by-Step Guide to Building and Deploying your Windows Phone 7 Applications" Colin Melia Lightswitch: "Printing Sql Server Reports (.rdlc) With LightSwitch" Michael Washington Short list tonight after a long day... From SilverlightCream.com: Printing ...
Form Based Authentication (FBA) is great when exposing SharePoint on the internet or extranet, users don’t have to know the domain they are authenticating to, you can manage the authentication using LDAP or SQL database amongst other cool stuff. But during the configuration process you end-up disabling the Integrated Windows Authentication (IWA) because you want your users to be provided with an FBA page. Once you disable the IWA you get the following notification If Windows authentication is not ...
Let’s say you added a table to the database created in the previous post, with a foreign key relationship to the original table, like this: The idea here is that you can have multiple rows in NestedData for each single row in TestData. If you create a stored procedure (call it Get_NestedData) with the following select statement: select TestData.TestDataId, StringColumn, IntColumn, Notes from TestData left outer join NestedData on TestData.TestDataId = NestedData.TestDataId where TestDataId = @TestDataId ...
Normal 0 false false false EN-US X-NONE HI MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} Attended the windows phone jump start ...
Today (20th Oct 2010) I delivered a 90min session to architect on the Windows Azure Platform. Are you an ISV? ISV = Independent Software Vendors - that is you write some kind of product that you sell to more than one customer. My new team is all about helping ISVs and we have a team blog and brand new twitter account which I will increasingly be found on. If you are an ISV, please fave the blog and follow the twitter account. And if you are an ISV please keep an eye on (and sign up to) http://bit.ly/ukmprhome, ...
This is the second part. Part 1: BizTalk: Timeline: Development Tools. As you can see, the last version of the BizTalk 2010 shifts the platform support to new versions of the .NET, SQL Server, and Visual Studio, and finish support for the previous platform versions. High-quality picture in PDF format ...
The first-ever meeting of the St. Louis ALT.NET group will be held Wednesday night at 7PM at the offices of Professional Employment Group at 999 Executive Parkway (Suite 100) in Creve Coeur (South of Olive off of Mason Road - Here's a map). The topic will be "Introduction to NHibernate", presented by Nicholas Cloud: setting up NHibernate for data access configuring NHibernate building and mapping domain objects to a SQL Server datastore querying the domain model for data The ALT.NET community is ...
I've spent time the last few month checking out much of the latest in code generation tools. Again one of the most complete and comprehensive is Iron Speed Designer - now in version 7.1. I had the good fortune to talk for about a half hour with Alan Fisher of Iron Speed and I will be adding content here in the next weeks. Hopefully I can also present some examples. Here's the lastest from their press release. For Immediate Release Iron Speed,Inc. Sephorah Green 408.228.3429 sgreen@ironspeed.com http://www.ironspeed.com ...
This is a basic tutorial for using a stored procedure via a WCF-SQL adapter in BizTalk. It's similar to the examples given in the SDK, but eliminates all the extra garbage of creating custom C# assemblies, enabling the SQL FILESTREAM, etc. You'll need to make sure both the LOB SDK and the Adapter Pack are installed before beginning. First, create a test database call WCFSQLTest, then create a table and a stored proc, using the following scripts: CREATE TABLE [dbo].[TestData]( [TestDataId] [int] IDENTITY(1,1) ...
WebMatrix is a free “one stop shop” supporting all developers’ needs when creating web sites based on standard markup technologies (HTML, CSS, Javascript and jQuery). WebMatrix features an intuitive user interface to help minimize the learning curve and ease navigation and access to all application features. For instance, on startup WebMatrix enables the user to select of the following: 1-Existing sites created in WebMatrix 2-Obtain a site from one of the open source packages through Web Platform ...
At a high level, this is how I understand the different MVC tiers: Model: Data libraries such as entities, Linq to SQL classes, or any other data library. View: The .aspx/.ascx pages. The classic ASP style code goes here. I have heard this layer referred to as a ‘report’ where you have as little logic as possible, and only that related to the display of the page. Controller: If you are coming from ‘standard’ ASP.Net and are new to MVC, You could say the controller is what replaces the code behind. ...
TinySQL is small and handy SQL script which can quickly generate consistent code snippet that you can paste in your project. It basically operates by reading schema of provided table and applying template to each column of table in order to generate code snippet. With TinySQL, you can create complete or specific portion of business class, business service, or data access layer. You can also generate repetitive code snippet like storing all DataReader columns into respective property of business object, ...
Entity Framework 4 Code First CTP4 was released in July and the API for developing without any edmx continues to mature and get better. Code First allows you to define your entity framework configuration with a Fluent API similar to Fluent NHibernate. Although the API for EF Code First is very user friendly, you should still have integration tests to verify that you’ve configured your entities correctly. This post will walk through configuring EF4 Code First optimistic concurrency. Suppose I have ...
The sys.tables and sys.columns objects will return this information for you. The following SQL statement will bring bring back all the colunns in all the tables ordered by the table name then the column name. SELECT tbl.name AS table_name, SCHEMA_NAME (schema_id) AS schema_name, col .name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID ORDER BY schema_name, table_name; ...
The objects that help you find this info in SQL Server are in sys.tables and sys.columns SELECT tbl.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, col.name AS column_name FROM sys.tables AS tbl INNER JOIN sys.columns col ON tbl.OBJECT_ID = col.OBJECT_ID WHERE col.name LIKE '%YourColumnNameHere%' ORDER BY schema_name, table_name; This will bring back every table that has a reference to '%YourColumnNameHere%' ...
Our West Palm Beach .Net User Group will be honored to have Scott Klein, Microsoft MVP and Author of Pro. SQL Azure (APRESS) as our October speaker. Scott will be talking and answering all our questions about Azure. Time has never been better for our Fladotnet West Palm Beach .Net User Group. We are fortunate to have a free meeting location offered to us by CompTec and to enjoy the backing and sponsorship of many top notch companies. This support is enabling us to uphold our founders’ vision: Create ...
It has been over a year since the last time I updated my list of Florida technical communities and a lot has changed since then. Joe Healy, our Florida Microsoft Developer Evangelist, maintains a list for each of the main areas in Florida, but this only covers the .NET-focused groups. Taking what he has started, I have put together a similar list (based on the information Joe maintains) that covers the other technical communities that I know of. If you are part of a technical user group community ...
I was looking for a simple way to schedule a job to perform a nightly backup of the production system and restore it to a dev system. I know there are many ways of achieving my goal and I am sure my solution will be frowned upon by some (if not all J) but it works for me so I thought I would share my experience with others. For my scenario the requirement was quite straightforward. Backup a single 5GB database then restore to an existing dev system (over writing the existing dev system). This article ...
With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2. I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error: Figure 1 - Unable to save table schema changes error With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would ...
Yesterday (5th Oct 2010) I delivered a short (45mins) session on the Windows Azure Platform. Big thanks to all who made it to the far side of beyond in London to attend the afternoon session. I think the event turned out rather well with my old team doing a top job as always – ably supported by our CEO Steve Ballmer doing the keynote :-). For folks wondering, Martin Beeby (IE9) is one of the two chaps that took my old role when I moved to the ISV team in August. Are you an ISV? Speaking of ISVs (Independent ...
One of the most intriguing topics in computer security is defense in depth. This basically means having many layers to security. Think about the walls and defenses in a medieval castle. An intruder has to storm each of the outer walls before they could get access to the castle. This is the same logic that leads to system designs with firewalls, intrusion detection systems, demilitarized zones, etc. The idea is that if one layer is breached then other layer may catch and stop the intrusion. More likely, ...
Back in April I began to work with Oracle again after a multiple year absence from doing so. So naturally I decided I would install Oracle on my home system so I could reacquaint myself with it. That proved to be more difficult than I expected. I was able to get Oracle 10g Express downloaded and installed but could not connect to it. So, to save someone else some of the grief I went through let me go through the final sequence of steps that resulted in a solid working Oracle development environment. ...
[Source: http://geekswithblogs.net/E... * This post is pure speculation, not based on any special insider knowledge, so don't get too excited * BizTalk 2010 has RTM'd, and the Developer Edition is now free. It seems an unusual move to give it away, with the price point of other BizTalk licences. Enterprises who actively use BizTalk will have an IT budget that will probably stretch to MSDN subscriptions for their dev team; conversely, SMBs who aren't prepared to spend £500-odd on a Developer ...
On Sept 29th, Microsoft made SQL Server 2008 SP2 available for download. Here are the KB article with a description of the fixes and the links to download SP2. KB 2285068 : List of the bugs that are fixed in SQL Server 2008 Service Pack 2. SQL Server 2008 SP2 SQL Server 2008 SP2 Express SQL Server 2008 SP2 Feature Packs SQL Server 2008 SP2 SSRS Add-in for Microsoft SharePoint Technologies SQL Server 2008 SP2 Upgrade Advisor ...
Here’s how we migrated our TFS 2008 to TFS 2010. This is not an in-place migration. What is generally recommended as upgrade path is to backup the TFS 2008 DBs, restore them in the new TFS data tier and then install TFS 2010. This will migrate all the projects at once. However, we wanted to keep the TFS 2008 environment running for a while, so this path did not do. We first set up a new machine (and a new domain, but that is a whole other story) with TFS 2010 and WSS 3.0. The database tier was on ...
[Source: http://geekswithblogs.net/E... I've had a need on a couple of projects for a monitoring system to record progress of a long-running transaction. Enter Heartbeat - a library which does just that. It's a project of mine on github: Heartbeat progress monitor. The typical use-case is for monitoring a lengthy batch load, where Heartbeat will record progress at set intervals. The intervals can be time-based, or progress-based or both - so you can have an overnight process which writes ...
One of the things I really wanted to do lately was to get SQL Azure, OData, and Windows Phone 7 working together; in essence, expose SQL Azure data using the OData protocol and consume that data on a Windows Mobile Phone 7 device. This blog will explain how to do just that. This example is also in our SQL Azure book in a bit more detail, but with the push for WP7 I thought I'd give a sneak-peak here. You will first need to download and install a couple of things, the first of which is the OData client ...
I've never seen this before, a BT update on Windows Update: Update for BizTalk Server 2009 (KB2252691) This update fixes an issue that prevents the ENTSSO service from starting, after installing .NET Framework 4. The registration of an assembly used by the Enterprise Single Sign-On Service to access SQL Server does not specify the correct version of the .NET Framework. When .NET Framework 4 is installed, the assembly will try to use the newer framework and then fail to load ...
Yesterday (28th Sep 2010) I delivered a short (50mins) new session on best practices for the Windows Azure Platform. Big thanks to all who attended – I think we had fun I will expand this post with some additional links when I have a little more time but I wanted to get the main bits in place – oh, and download the free ebook. Slides Windows Azure Platform best practices by ericnel View more presentations from Eric Nelson. Links For more resources and information http://bit.ly/startazure If you are ...
Implementing a Fire Hose for SQL Azure While I was looking around in various blogs, someone was looking for a way to insert records in SQL Azure as fast as possible. Performance was so important that transactional consistency was not important. So after thinking about that for a few minutes I designed small class that provides extremely fast queuing of SQL Commands, and a background task that performs the actual work. The class implements a fire hose, fire-and-forget approach to executing statements ...
By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables. When you attempt to do so, it wants you to drop and re-create the table. You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without have to drop the table and re-create it. To enable this feature, you need to select Tools / Options from the Menu. Then, navigate to Designers / Table and Database Designers and uncheck the option ...
I am hanging recently around a lot in the MS SQL Server Forums where I have a lot of fun. One of the interesting questions that popped up today was about how to execute several operating system commands that span multiple lines. Besides, even though the job step editor presents you with a text box, this is not the same as writing a batch file. All the editor does it sees the first command statement. What to do? Some people resorted to writing subsequent commands in the next job step, but this sounded ...
I returned just last night from a short trip to Redmond. While I was there, I learned some news that I wanted to share, but I wasn’t permitted to. But today the news was made public: Oslo, once destined to be a full fledged-wave of Microsoft technologies that would facilitate and promote model driven-development, is dead. The Oslo name summons Shakespearean images of King Hamlet slaying his Norwegian foe. But even without such literary context, the fall of Oslo is quite dramatic And it’s important ...
The BizTalk Server team announced today that BizTalk Server 2010 has RTMd. That's a relief, as my reputation was on the line regarding RTM before the end of the month. Just this Tuesday I confidently told a prospective customer to expect an imminent announcement. I've been playing with BTS 2010 for a little while now. It has been my constant companion while writing several chapters for the forthcoming BizTalk Server 2010 Unleashed. It looks great. As well as bringing BTS up to date with Visual Studio ...
So it's official. Don Box has blogged an update on SQL Server Modelling. As widely rumoured, he has confirmed that Quadrant is dead. The shock is that the model repository has expired as well. M is still hanging on in there, but we don't know anything more about what the future holds. For some time, the official word has been that it would arrive in conjunction with a future SQL Server release. I detect a possible change here, in that Don simply says 'We are continuing our investment in this technology ...