I wanted to make a few more points about using SSDT in addition to previous posts. As I was working on my project, I wanted to drop a procedure that was no longer used, but there is nothing on re-factor menu to support that. Come to find out, you have to follow a different pattern …
In my previous post I gave an overview of SSDT, SQL Server Data Tools.In this post I will give some hints on refactoring of the data structures. One of the common refactoring actions is a column rename. Let’s take a look at that. Open a table in design view by double-clicking on it solution explorer. …
As you know, I have been working for Magenic for over 5 years now. One of the initiatives that we have at our company is to have company blog in addition to many consultants having their own blogs. You can check out Magenic company blog here. I recently wrote a post on SQL Server Data …
Continue reading ‘Getting Started with SQL Server Data Tools (SSDT)’ »
In this post I want to summarize the tools and technologies that will be coming up in 2012 from Microsoft. All of these is public knowledge, but I wanted to outline the technologies that excite me the most. There are some conjectures and opinions of course, and some educated guesses. I am going to include …
In this post I will describe how to get started with running SQL Server Reporting Services on Azure. SSRS on Azure is now in beta stage, but anyone can give it a whirl. First of all, activate the service and create new report server. When you are on management portal, click on Reporting link (see …
In this blog I will describe my ideas on how to integrate SQL Server reports in ASP.NET MVC applications. I would like to have as seamless of an integration as possible given the constraints in place. For example, the only web based report viewer for SSRS is the one that has been shipping with Web …
I have been thinking for a little while about the future of Entity Framework, feature set on the horizon, and trying to ascertain where I would like to concentrate my next “free time” project. If you have not been keeping up with Entity Framework, please read the last few posts on the Entity Framework design …
I was working on a particular production problem yesterday. Sometimes when a user clicked on print button in SSRS Web Report Viewer control, and error was shown, and report is only partially printed, maybe 2 pages out of 4 are printed. Specific error that is shown to the user stated “An error occurred during printing …
Today I had to accomplish the following task. I had to create a report that selects data from primary table and also selects data from a related table , comma delimited into a column on a report. I keep bumping into this problem periodically, but always have to research the solution. Today I am documenting …
Continue reading ‘Selecting Comma Delimited Data From SQL Server’ »
Last week I took a stab at creating my first PowerPivot spreadsheet, and I wanted to document the steps. Maybe this post will help someone, but it will help me remember, that is for sure! Before you get started, you will need to download all the software required. Here is my list: Office 2010 Beta …