Tuesday marked the day that I presented on SSIS basics. The night went really good and the group and I had a great time during the discussion. Kim Young (needs to be on twitter) started us off with stored procedures and error handling and moved into Wendy (Blog | Twitter) plugging PASS and the community. The group I presented to was about the best group you could get in front of you.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
I had some reporting weirdness going on today. Mostly because I don’t really know what I’m doing. So, I had this problem. Can you see the gap under FiberColor? Why is that there? As you can see in the above it was not visibly there in the designer. Untill I went into the textbox to edit it. then you see this. The problem is that I had a few to many linebreaks in there.
A goal? The second part to the mirroring series will discuss hardware selection. Hardware can be a single point of high performance and a single point of failure. In a mirroring situation, there is not a listing we can put on paper as to the best hardware and configuration we can make. Each database server is configured as it requires for IO operations, memory usage etc… RAID 1+0 would give you write performance on the mirror but at the cost of what if you database server that is active is on RAID 5?
I ran into this myself a couple of months ago and decided to write a short blog post about it in case you happen to run into this. SQL Server 2008 lets you use Visual Basic or C# as the scripting language in a Script Task. If you decided to translate some of your older packages from VB to C# be aware that there are some subtle differences and things don’t translate one to one.
I will be speaking tomorrow night, May 4th, on SQL Server Integration Services basics for the SQL Connections group in the Chicago suburbs. Yes, the Wisconsin guy is going to go farther than Hwy 60 once again. The session, “SSIS 2008 Basics – Get up to Speed in 90 Minutes”, will be going over the fundamentals of SSIS and getting started with your own installation and development of packages. There is a lot to cover when considering SSIS basics when starting from opening the installation media, to opening BIDS for the first time.
Researching and obtaining the knowledge and test cases for configuring mirroring is a large part in putting SQL Server mirroring to work for your High Availability (HA) solution. Before you start jumping into configuring mirroring, several questions should be researched and answered. This ensures that the HA solution and mirroring will work for your environment and your business. One of the highest achievements in mirroring is to ensure it will always be invisible to your user community.
I upgraded to VS2010 a few weeks ago and everything went pretty OK. Until today. Today I wanted to add another report, which was no big deal. Making the report is the same as in VS2008, no improvements there. And then I tried to run the report. And all was not so well. I got this. With the error message being. An error occurred during local report processing. The definition of the report ‘Main Report’ is invalid.
How to insert values into a table with only an identity column Some databases have something called a sequence, you can use this to generate values like an identity but it can be used accross many tables. In SQL Server you could simulate that by creating a table that has an identity column, inserting into that table and then use the identity generated in your other tables The reason I am writing this is because I saw the following table
In my previous blogpost I showed you how to make an extension for VS2010 which adds a menuitem to the contextmenu of a project in the solution explorer. Now, I want to also add a ContextmenuItem to the ProjectItems. You might think this should be pretty painless. Well, think again. First of all we go back to our vsct file and add a group to our groups node. Because it’s the groupnode that decides where the menuitem will show up.
I felt the need to write a VS2010 Extension. And I decided NArrange needed some love and attention from me. NArrange works great but it needs to be integrated with VS2010 instead of me having to create the context menu items from scratch. So I started by downloading the VS2010 SDK. This adds a category to our new project dialog and it adds several new templates to choose from in that category.