Community Blogs

Microsoft to Acquire DATAllegro Leaders in Data Warehousing Team to Provide Large Scale Business Intelligence Solutions. More here... Read More...

We decided to use FilteredViews instead of FetchXml for an internal project, but we ran into couple of problems. You can't access data from the FilteredViews using ASP.NET since it runs under NETWORK SERVICE (by default (app pool)), FilteredViews filter the data by Users. If you set the <identity> settings on the WCF service you'll notice it has no effect, you need to tell WCF to run in asp compatibility mode, check this link for more details. Impersonation needed for FilteredViews - EXECUTE AS doesn't work, some forums suggested we enable DB_CHAINING, TRUSTWORTHY & grant NETWORK SERVICE Impersonate for each User, we decided to take a different route since these database changes are unsupported by Microsoft. - Configuring...

Sorry, I did not work with MS OfficeLive documents yet. But, nevertheless, I think the idea could be of some interest. All these billions of ubiquitous sensors around us doing their routine everyday work. Why not let them log their data directly to SQL server database that backs up MS OfficeLive documents? For example if I had a number of temperature and other types of sensors around my home, I’d like to store it somehow and process and represent the result in convenient way. Normally I should buy some hardware to connect the sensors to PC, develop some software to acquire the data and store it into MS Access or Excel, then somehow process it and show the result. Too much hassle. Why not buy some hub that would talk to SQL server database under...

Hi, Many a times in a query we need to limit down the number of records returned in the query. This can be done in two ways using the TOP keyword or the row count keyword. Select top 10 from Table This will return the top 10 records from the query. We can also make this dynamic by making the Value in Top keyword to come from a variable. DECLARE @top INT SET @top = 10 SELECT TOP(@top) * FROM Table If using a stored procedure we can also pass this variable as a parameter in the procedure. This way we can easily control the number of record affected. Another way to do the same stuff is to use the rowcount variable. DECLARE @top INT SET @top = 10 set rowcount = @top SELECT TOP(@top) * FROM Table set rowcount = 0 Remember converting the rowcount...

Well, we've rolled out new versions of several of our products here at Red Gate. In particular, these have been adding SQL Server 2008 support. You can read more about these updates on the website http://www.red-gate.com As well as SS2008 support, the new versions have picked up lots of bug fixes and a few extra features to boot. These are the first wave of the 2008 supporting tools. The remainder are due to be rolled out in the coming weeks. If you want to see some of the forward plan, have a look at http://www.red-gate.com/about/roadmap.htm - there's some exciting stuff in the pipeline! Read More...

Needed some TSQL code again to retrieve descendant and ancestor entries in a self-referencing table. I've done this a couple of times already and although I can write it from the top of my head, sometimes you just want to make life easier and have a script you can just modify a bit to fit the new requirement. So what I usually use for recursions in SQL Server 2005 are Common Table Expressions (the "WITH" keyword). This is only available in SQL 2005 and very easy/efficient for recursive. This is definitely in BOL and articles all over nevertheless here's my basic script to get "Descendants and Self" and "Ancestors and Self" information. In this case I only involved the ID, ParentID, and Sequence but you may...

While working on a project I needed to determine the last modified date for some SQL stored procedures. Read my full post below for a description of how to accomplish this: http://www.schnieds.com/2008/07/sql-stored-procedure-modified-date.html -Aaron http://www.churchofficeonline.com Read More...

All day I was stumped on why there wasn't a simple way to grab the first object in a sequence other than using: .Take(1).Single Then I discovered the keyword First. I'm still a little puzzled as to why .Single would throw an exception if more than a single element would be returned. I can't really see a practical use for it unless you wanted to force only 1 object being returned. Read More...

The July July and August 2008 meetings of Southeast Valley .Net Users Group ( SEVDNUG ) will host a comparison of different Object Relational Mapper / Data Access Layer technologies. Requirements have been to established so that there is a common database and user interface to compare these technologies against.  Each presenter will be given 15 minutes to demonstrate there technology and/or framework followed by a 5 minute Q&A session.  At the end of all of the presentations there will be a Q&A session for all of the presenters and attendees. Since we have so many technologies represented, 9 at last count, the event will span two meetings. In addition, if you can not attend but are interested in the event, it will be broadcasted...

Hi all. I just got a link to this nice article about inner joins on SQLServerCentral.com by Susantha Bathige . The objective of this article is dig into detail of how INNER join produce the result set. The INNER join is the common join type used by many cases. Even though it uses very often I have seen most of them are not certain how it produces the result set when change the joining condition. To get acces to SQLServerCentral you need to register, but it only takes 20 seconds and you'll get access to really cool stuff. Hope you like it just as much as I did. Read More...