The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS demonstration and I stumbled upon an additional feature that makes the indicator even more visually appealing. Using a not so obvious property of the indicator you can set its size.…
Archives: May 2011
Restoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There is no direct way to do this like Backup/Restore. You can use an alternative ways.
The alternative ways are,
1. Generate Script
Have you made the mistake of dropping your distribution database like this?
If so, remember not to do this ever again. Disabling publishing and distribution involves more than just dropping the distribution database. The distribution database in SQL Server requires special attention and dropping it in this fashion can wreak… Read more
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at the Boston Public Schools. Generally each request is different but similar to ones previously made. To the degree that such requests are unique, there’ll always be work involved in… Read more
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals may encounter in the course of our day. We will start off by looking at why we need to have a plan for every situation, and then we will dig… Read more
Ever see a Windows group and want to know all the users in that group without having to ask your system admin? There is an easy way to do this. Just create this shortcut on your desktop:
Call it something like “Search AD”. Then when you run it… Read more
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are:
- Connect Item on Import/Export Wizard (5/20/2010) – Connect item that would be great to have up voted.
- Doing Something…
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning at a “private” test center. The registration was easy enough. The process is a bit different since this test center… Read more
I saw 500 faces an rocked them all!
To those who attended my webinar today THANK YOU! If you didn’t…. There is a third one coming on solid state! As always the slide deck is posted here. I’ll be adding this information and some additional details to my ongoing… Read more
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem rather than being seen as a part of it. We may have the best intentions and know our systems inside and out but if we refuse to look into something… Read more
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our esteemed panel was made up of
- Karen Lopez (Twitter) of InfoAdvisors ,
- Adam Jorgensen (Twitter, blog) of PragmaticWorks, and
- Melinda White (email
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment.
Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my… Read more
One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience to avoid the problem altogether! That’s been the case for me over the past 6 months or so. I elected to make some changes in my work life at the… Read more
I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues.
I’ve never thought about it before, but someone… Read more
One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect to remote server error”
I checked the report services & sql server (to which SSRS is mapped) services and both of them were running. I tried to connect to… Read more
A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I hadn’t encountered until recently is as follows: How does one get a certain number of randomly selected records from a table? Nope, I didn’t need to do this for… Read more
One thing that is enjoyable about my position is working with people who have no idea what SQL is besides “a difficult version of excel”. This gives me the chance to use what I have learned over the last couple of years and explain it the people who are using… Read more
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011. This three day event includes over 120 sessions, costs only $100, the least expensive full conference you can attend anywhere. While the conference is developer-oriented, it still offers plenty of… Read more