Browse by Tags
All Tags »
SqlServer (
RSS)
Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' + CategoryName from Categories select 'Results = ' + @CategoryList Option...
T-SQL Israeli CardID Checker / ת.ז. ישראלית Once in a while I come across code that I didn’t fins in the internet … mainly because it’s for local use ;) This is one of these times :) This code is the T-SQL version of the algorithm that checks the given Israeli CardID , and adds a leading Zero , if need one ( like in my personal case ) , and calculates the “Check Number” ( SIFRAT BIKORET ) , if it’s missing. I needed this for an SSIS Package that loaded monthly information needed for my SharePoint...
Express 2010 RTM Download summary Any one who really knows me , knows that my 2nd passion is the Express toolset :) Now, that Visual Studio 2010 has RTM-ed a few days (weeks) a go I have decided to build a small collection of relevant URLs : from http://www.microsoft.com/express/Downloads/ Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express ( Part of the WebPI Toolkit ) All - Offline Install ISO image file And the SqlServer Express 2008 R2 –...
Exporting/Saving RDL files from http://server/reports Here are the steps: 1. Go to Report on Report Manager 2. Click " Show Details " 3. Click " Properties " of the report you need to Export 4. Under " Report Definition ", click on " Edit ". You will be able to either " Open " or " Save " the RDL file. … And in Pictures ;) That simple :)
SqlServer Express 2008 Profiler If you didn't know , the Express Environment is one of my favorites ;) So, when I come across an “AddOn” I run to test it – Well here’s a nice one SqlExpressProfiler - The profiler for Microsoft SQL Server 2005/2008 Express Enjoy
SSIS on Excel 2007 Data Import & Moss2007 One of the crucial stages in moving managers from the “Simple all I want I get from Excel” to a more centralized platform like Sharepoint is moving their data ! Well lately not only have I been a : “HTML” “SharePoint Designer 2007” “Adobe Photoshop CS2” & “Paint.Net” Graphics “General Specific Site Collection Moss2007 Admin” “InfoPath 2007 Browser Compatible Developer” (including InfoPath C# Code) “General Web Service & WCF Programmer” “Camtasia...
Problem: If SqlServer 2005 Setup fails and roll back with the following error message: "An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." Reason: It’s probably due to the fact that you have installed .NET Framework 3.5 BEFORE you have installed SqlServer 2005 ;) Solution: To work around this problem, uninstall SQL Native Client by using Add or Remove Programs...
Report Viewer for Visual Web Developer Express The Visual Web Developer Express is one of my favorites , both the previous 2005 & 2008 versions as well as the new and shining all around fully functional – Visual Web Developer 2008 SP1 Express Edition ( which has support for ClassLibrary & Silverlight 2.0 projects as part of the Solution – Single Environment ! ) It seems that only a few days a go the Microsoft Report Viewer Add-on for Visual Web Developer 2008 Express has been released Microsoft...
I was working on a small webcast on migration from Access to SqlServer Express edition and it seems that from the 2008 version , it’s no longer possible (by default) from the Access ribbon strip (Express & Developer edition were tested ). This option worked on SqlServer 2005 ( All versions , as far as I know ) On the other hand, we know that even the Express edition of SqlServer 2008 contains the Import/Export Wizard ( which in the SqlServer2005 Express was absent )
Azure : Start Cloud Application Development As expected the knowledge about Azure can to me from the Microsoft SharePoint Team Blog - PDC 2008: Announcing Azure Services Platform and Microsoft SharePoint Services Looked at a few videos , and this seems like Microsoft is starting to think like a ISV, but with a twist , which means - you “can” use Live.com services from your cloud Application. Not saying that this is bad, but my feeling is “put your application on our servers, FOR FREE, and we’ll help...
SqlServer 2008 Express/Developer Management Studio Be careful NOT to install the Express Edition BEFORE the Developer / Standard Edition. Why ? this is why ! You can’t add the “Complete” option of the Management Studio – which contains the tools to all other then Database Engine options like SSRS & SSIS :’(
Saving changes is not permitted ... that require the table to be re-created. For some of us who’ve been used to making changes in Tables using the SqlServer2005 Management Studio, the SqlServer2008 Management Studio show the following warning : Saving changes is not permitted ... that require the table to be re-created. Or in pictures And the “short” solution is the following
.NET Framework 4.0 = "BizTalk/SOA Express Framework" ? PART3 Well, what can I say, it all started with a gut feeling, or revelation , which ever you feel more commutable, on an early morning of a Saturday, drinking my usual morning coffee got me thinking , and resulted in this post .NET Framework 4.0 = "BizTalk/SOA Express Framework" ? . After a while, the more I thought about it, the more I felt more confident with the idea so I continued my journey with .NET Framework 4.0 =...
BizTalk Server2009 , " OSLO " and .NET Due to expected “collision”, BizTalk2006 R3 ( BizTalk Server 2006 R3 Announced ) development was integrated into the BizTalk2009 development. Some of us might have suspected that already from the Is there a new logo for the IT Products in Microsoft? post a while ago. As such, we should summarize the current situation: Where We Are Now BizTalk 2006 R2 Service Oriented Architecture and Web Services Enhanced support for messaging based on Web services...
Webcast – Installation of Wss 3.0 SP1 on Win2008 with Sql2008 Express Advanced Services Ok, long title, but it says it all. Windows SharePoint Services 3.0 SP1 Download & Install SqlServer 2008 Express with Advanced Services Download and Install Environment is Windows 2008 + Add Role of Application Server with Web Server (IIS) + Add Feature of PowerShell Initial Startup of the Wss 3.0 WebSite Given this is a FULL install process, the Webcast is a bit “long” ( 33 min aprox. – with lots of cut...
More Posts
Next page »