Last night I attended the monthly MADPASS SQL Server user group meeting, along with about 20 other people. I go every month, but this month was special – it was our first birthday! It’s hard to believe that the group we worked so hard to get started and draw people to has been meeting for a year already. The meeting was sponsored by Confio – I want to thank their rep, John, for coming, and for the Mastercard and Amazon gift cards and other swag.

This is part two of a series about Report Builder 3.0. Report Builder 3.0 – The Introduction Report Builder 3.0 – Chart Wizard Report Builder 3.0 – Chart Types, Visualizations, and Properties Report Builder 3.0 – Map Wizard Report Builder 3.0 – Report Parts In this post, I’m going to introduce you to one the Table or Matrix Wizard. SQL Server Report Builder 3.0 has a built-in Table or Matrix Wizard.

I’ve created SQL Server Reporting Services reports with Multi-Select parameters before. In fact it’s pretty par for the course for me now. I recently ran into an issue with one of my reports that I had never seen before. Every so often I’d get an error stating “operation cannot run due to current state of the object.” Perplexed, I did some searching. At first I came across this thread on msdn.

Adding load testing to my continuous build process provides several benefits for a fairly cheap entry fee. As the development process progresses, I’ll have a baseline and know if I add something to the application that impacts the performance. I’ll also be able to accurately discuss it’s performance when asked, instead of guessing. And if I want to increase the performance, that same baseline will serve as a guide on my progress.

Adding a Load Testing stage to my Continuous Delivery project has been on the todo list since I started the project. The addition will allow me to baseline the applications performance while adding some experience with load testing, a topic I haven’t been able to spend as much time on as I would like. Given I am doing this on my own systems and time, minimizing cost and complexity are also a priority.

I was installing an instance of SQL Server on a VM this afternoon and ran into the following error Rule “Consistency validation for SQL Server registry keys” failed. The error isn’t very common, that I knew of. Before we go about why this error did actually happen and how to fix it in the case of this installation, let’s go through troubleshooting an error that occurs in the setups rules validation steps.

After upgrading my SQL Toolbelt installation recently, I came across a new entry in the SQL Prompt menu that is integrated into SQL Server Management Studio. So I have decided to put out a quick post on one of the features which I find is handy. With the new SQL Toolbelt, I’ve also installed the Redgate integration which integrates all the tools for you into Management Studio. On my way to make some changes to my configuration for SQL Prompt, I noticed the Experimental Features… portion which altered my curiosity setting to a full 100%.

Nice long title says it all. So you know I use posh-git and I use it in the nuget package manager console or the studioshell plugin. ANd now I want to join what I had in those previous post and throw in some tabexpansion to make my checkout script better. I want it to show my branches when I type checkout <tab> in the console. So in my $profile I have this script.

I was looking at the posh-git code and I found the author doing this. function script:gitCmdOperations($command, $filter) Needless to say I didn’t find anything on google about this, because google ignored the : and looking for script in a scripting language gives you lots of hits. I then asked the question on twitter and after that I posted the question Stackoverflow. And got this reply from user Rynant. It defines the function’s scope to be the script scope.

This is part one of a series about Report Builder 3.0. Report Builder 3.0 – Table or Matrix Wizard Report Builder 3.0 – Chart Wizard Report Builder 3.0 – Chart Types, Visualizations, and Properties Report Builder 3.0 – Map Wizard Report Builder 3.0 – Report Parts I’ve been building reports with SQL Server Reporting Services for a few years. Until recently, I exclusively used Report Designer, which let me build reports in Business Intelligence Development Studio, a Visual Studio environment.