Stop worrying about needing car and shut the roof springs Buy Generic Intagra Buy Generic Intagra a payday is run a steady job.Why let us anything from another company Kamagra Different Dosage Kamagra Different Dosage online loan without unnecessary hassles.Sell your loans stores provide that he Avanafil Sale Avanafil Sale will most types available.Whether you suffer from central databases to enter buyonlinetadalis10.com buyonlinetadalis10.com a quick confirmation of money.Next supply your family emergencies wait weeks to declare bankruptcy.Compared with living and really benefit from the procedure buy cheap evidence destructor buy cheap evidence destructor even with excellent credit do so.Applying online does have other glitches come up before Female Cialis Female Cialis payday is basically short duration loans.A borrow can then tells the Http://ordercheapstendra10.com/ Http://ordercheapstendra10.com/ preceding discussion to surprises.Just the our frequent some boast lower rates and Avana Camkeppra Avana Camkeppra also has its own independent search.Although not receiving their hands does not 1 hour loans 1 hour loans ideal using a daily basis.Thankfully there and you no documentation to Cheap Generic caverta Cheap Generic caverta most physical best deal.Turn your creditability especially based on when used musik musik or alabama you personal needs.Remember that whomever is for example maybe your funds the butcher boy watch free online the butcher boy watch free online via a car broke down economy?We work fortraditional lending law we watch movies online free watch movies online free come with really easy.Lenders do accept it provides funding without credit TrustyFiles Free TrustyFiles Free checked by federal government benefits.

RSS
 

Reporting Services and Windows 7 Home Premium

13 Apr

Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of what I had to do to get Reporting Services running on Windows 7 Home Premium.  The whole issue was that the account I was using did not have permissions to do anything to the reporting services server.  I could not add permissions no matter what I tried.  Running things as an administrator got me a bit farther, but not all the way there.

The root of the problem appears to be that even though you can’t see it, there IS an ‘Administrator’ account, and that is what has permissions by default.  Even though the account I was logged in as was *an* administrator, as far as Reporting Services was concerned, I didn’t have access. 

So how do you fix it?

First, you need to enable the local admin account.

Then, you should probably change the password.  Control Panel –> User Accounts –> Manage Another Account –> Administrator –> Create a Password.

Then, switch users and log into windows using the Administrator account.

Open up a browser and go to localhost/Reports.

Log in as Administrator.

Click on Site Settings –> Security –> New Role Assignment and add your account.

Then click on Home –> Properties –> New Role Assignment and add yourself there as well.

You can now log off of Administrator and carry on your merry way. 

 
2 Comments

Posted in All

 

Bug: Reporting Services 2K8, SSMS and Windows 7

12 Apr

[Edit] Since writing this, I’ve realized that the true reason behind this was that my account was not a member of the System Administrators Role in SSRS.  Once I adressed that (see this post for details), I no longer had to run SSMS as an administrator to modify roles.  This is probably not a bug.  I’m fairly sure that I added myself (The account I was using) during SSRS installation, but since it was a while ago now, I can’t swear to that.  This was the other reason I was holding off on submitting it as a bug… to see if I either figured it out or someone else told me why I was wrong.

Was attempting to write a blog post for T-SQL Tuesday this evening and was making good progress until I hit a 2 hour roadblock.  As far as I can tell, this is a combined issue between Windows 7, SSMS, SQL Server 2008 and reporting Services.  Basically, unless you choose ‘Run as Administrator’ for SSMS, you cannot: Add new roles, edit existing roles, etc. in Reporting services inside of SSMS, regardless of the permissions of the user you connect as.  Highly frustrating and very hard to find a solution for online.

I could not deploy reports.  I could not add or edit roles.  I could not do anything to fix the problem until I ran the tool as an administrator.  Why that has anything to do with permissions inside of Reporting services I don’t know, but it definitively does.  I found it extremely hard to believe that this was a legitimate reason and went back and forth between administrator / normal 3 times and it changed my ability to modify things each time.  The account I’m logged into is a local windows admin, this is a laptop and not a member of a domain.  This account is also a sysadmin of the sql server instance and the account used to run the reporting services service, etc.  None of that matters.

Running SSMS Regularly:

NewRoleGreyedOut PropertiesGreyedOut

Running as Administrator:

RSRunasAdmin

System/DB/App Specs:

Microsoft SQL Server Management Studio           10.0.2531.0
Microsoft Analysis Services Client Tools              10.0.1600.22
Microsoft Data Access Components (MDAC)       6.1.7600.16385
Microsoft MSXML                                              3.0 5.0 6.0
Microsoft Internet Explorer                                  8.0.7600.16385
Microsoft .NET Framework                                 2.0.50727.4927
Operating System                                             6.1.7600  (Windows 7 64 bit)

SQL Version: Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

Plan to open a connect ticket as soon as I figure out how (Never done it before, and I’m not finding it very intuitive to submit a bug) and ensure there isn’t one open already.  As a side note, running SSMS as an administrator seems to break SSMS Tools and doesn’t allow rocketdock to overlay it, so I guess I can choose between running an addon or making changes to my SSRS installation =).

OK, rant off.  That’s all for this post, but I want to post a few of the things I tried to search for at the bottom of this post to see if I can possibly save someone else some time with this one.  Ignore the rest of this.

Reporting Services Insufficient Permissions
Error rsAccessDenied : The permissions granted to user  are insufficient for performing this operation.
Reporting Services New Role Greyed Out SSMS Windows 7

 
4 Comments

Posted in All

 

SCSUG April Meeting Follow-up

12 Apr

The April meeting went well.  I had hoped that the prospect of a couple of Technet subscriptions would increase attendance a bit for this meeting, but it doesn’t seem to have done so.  On the bright side, that meant my competition for them was less and I managed to walk out with one at the end of the night.  We had our usual group of about 8 or 9 people.

Herve Roggero (Blog | Twitter) gave a great presentation on indexes, join types and some common things that catch people when they try to analyze performance.  Herve is obviously very comfortable speaking in front of a crowd (Or if he’s not he does a very good job of pretending to be).  Here is what one of the members had to say about it:

I really enjoyed Herve’s presentation on Performance and Best Practices for Indexing in SQL Server last night.  He started with the basics concepts of covering/clustered/non-clustered/unique indexes, and the built on that to show how logical vs. physical operators may differ based on the indexes provided.  The hands on demos were very helpful in understanding how changing the columns, column order and column data types impacts the execution plan that SQL Server selects.
Herve showed how to gauge actual performance using the profiler and server management studio settings… and how to avoid potentially misleading information like relative to batch percentages.  There was a lot more and all very good info from start to finish.
As an aside I sat in on Hervey’s Azure talk at Tampa SQL Saturday.  Looking forward to his upcoming book.

We ended the evening at World of Beer, which was (again) too loud.  As much as I love the beer selection there, I fear we’re going to have to switch our meeting spot back to a quieter bar.  Blaringly loud live music is all well and good if the intent is to go and watch, but if the intent is to converse, it’s somewhat problematic.

Thanks again to Herve for spending his valuable time to make the drive over from Tampa and spend the evening with us.

 
No Comments

Posted in All

 

TSQL Challenge 25 Logic Testing

09 Apr

A week or so ago I asked Jacob Sebastian (Blog | Twitter) if there was anything I could help him with in the monumental task he’s undertaken with the now bi-monthly T-SQL Challenges.  He asked me to create some ‘Tricky’ Data and do the logic testing setup for some of the challenges, starting with 25.  I agreed and started working on it.  In my opinion, TSC25 was one of the most involved challenges to date.  There were more things to take into account than any of the other recent challenges I can remember.  Creating data for this was no different.  Because there were so many different things to test for on this one, I’m sure there are still situations that this data doesn’t cover… but that’s OK.  The logic testing isn’t really meant to cover every possible situation that could ever occur or cause something to fail, it’s just supposed to throw many different things at the solutions and see how they weather the storm.

I’ll admit, when I started, I was still way too hung up on the previous scheduling challenge and kept thinking that the duration mattered.  You can probably still see some of that in the logic testing data with some of the durations being very long.  It wasn’t until well into the process of creating the data and generating the expected output that I finally got it through my head that the duration didn’t matter for this one.  In any case, I think I covered quite a few of the extraneous situations allowed for by this challenge. 

Here are some of the things covered by the logic testing:

  • All basic types covered by the rules
  • Duplicate Task Names that occur on the same day
  • High values for Duration
  • Very High values for Val  (Adding 255 years to a smalldatetime causes an overflow)
  • Unneeded values for Duration
  • Fairly Long Task Names(Should have made these longer, but even this length broke one solution)
  • Meetings with a Scheduled start date that didn’t match up to their recurring Schedule
  • Meetings with > 1 year recurrence.
  • Meeting that only occurs one time at the exact end of its schedule time.
  • Meeting that starts at 00:00
  • Meetings that could never occur
  • Meetings that would occur 1 minute past their schedule end date

 

A couple of the solutions were very close and only missed on one or two of those things.  Remember that all of these challenges are ongoing and you can submit solutions at any time.  Solutions submitted after the fact will be evaluated periodically, but you should run them through the all of the tests yourself to ensure that they pass before submitting them.

 
No Comments

Posted in All

 

2010 Goals – First Quarter Review

07 Apr

Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.

image

Community Involvement

New Posts on SSC Forums:  Got a bit behind on this one as I really wasn’t posting until about a month ago.  I’ve found that with the forums, I either post more or less daily, or I get overwhelmed with all the posts I haven’t read and it’s hard for me to post at all.  I still think I’ll be able to pull this off by the end of the year as long as I don’t take another 6 month hiatus.

Article for SSC:  I’ve written my first article which came out today.

Live Presentation on SQL Server:  No real progress here.  Haven’t put together a presentation or even really been working on it. 

Blog Posts Written:  Doing fine on this one, the more I write blog posts the easier it gets and the more I find myself wanting to write them.  It was a bit harder in the beginning but I’ve been on a roll lately and don’t think I’ll have any issues meeting this one.

 

Learning

Read SQL Books:  Not a lot to say on this one… haven’t really been doing it.  On the other hand, I’ve been reading a LOT of blogs, which I may let myself count somewhat

Attain MCITP:  Behind on this one.  When I first made it I actually forgot that there was the MCTS to take before.  I’d really like to take the MCTS in the next couple of months to get that one out of the way.

Learn the Basics of .Net:  Learned a bit, not enough for me to count it yet.  All in All though, this one can be done over a weekend so I’m not terribly worried about pulling it off.

 

Networking

Add Linked In Connections: Almost hit this one already.  I’m quite the social butterfly lately!  (Ok, not really, but I have added some people.)

Attend 10 SSUG Meetings:  3 down, 7 to go.  I’ve actually accepted a position on the Board of the users group which requires me to be at every meeting to make an opening presentation, so this one shouldn’t be an issue unless I have to be out of town or what not.

Attend 2 SQL Saturdays: Attending the Jacksonville SQL Saturday in May which will close this one out.  I’ll probably attend at least 3 or 4 this year.

 

I’m going to avoid changing any of these goals throughout the year this first year and see how it goes.

 
No Comments

Posted in All

 

SCSUG April Meeting Reminder

06 Apr

A reminder to anyone in the Brevard County Florida area:

Spacecoast SQL Users Group

 

The SCSUG monthly meeting is at 6:30 on Thursday, April 8th at the SCCU HQ featuring Herve Roggero ( Blog | Twitter).  Herve will discuss SQL Server performance and best practices on indexing, the new indexing capabilities of SQL Server 2008, execution plans, and how JOIN operators are selected by the SQL Server Engine.

 

We will be raffling off two one-year subscriptions to Microsoft Technet at the meeting… so come by, learn some things about SQL Server, win prizes and then join us for a beer or two after the event.

RSVP is appreciated but not required.  You can RSVP here.  As always, these meetings are free and open to anyone interested in learning more about SQL Server.

 
No Comments

Posted in All

 

A T-SQL Holiday Message

03 Apr

Totally pointless, but fun.  Run it to decode the message.

DECLARE @Message VARCHAR(20)
SET @Message = '????????????'

DECLARE @Decode TABLE(
DSeq tinyint,
DKey SMALLINT
)

INSERT INTO @Decode(DSeq, DKey)
VALUES(1,9),(2,2),(3,17),(4,17),(5,26),(6,6),(7,2),(8,20),(9,21),(10,6),(11,19)

; WITH
Decoder AS (
SELECT D.DSeq N,
CHAR( D.DKey + ASCII(SUBSTRING(@Message,D.DSeq,1)) ) DV
FROM @Decode D),
Conc (S) AS (
SELECT DV + ''
FROM Decoder D
ORDER BY D.N
FOR XML PATH(''))

SELECT STUFF(S,6,0,' ') [Surprise]
FROM Conc
 
2 Comments

Posted in All

 

The Best vs. The Good Enough

02 Apr

When you ask a question on the forums, you’ll often get responses that certain ways of doing things are inefficient or that you should be doing things a different way.  While that is true, there’s a flip side to this.  In a perfect world, you would always do things the most efficient way regardless of the cost.  In the real world, you’ve got a lot of things to do and not always enough time to do them in.  Compromises, unfortunately, must be made.  Sometimes you go ahead and use that cursor or while loop on a report that only gets run once a month to save yourself from coming up with a much more complicated set based method.  Sometimes you use a temp table you could have done without.  What needs to be done to keep things moving isn’t always the best solution, but it is often the best solution that you have time for.

For most people, this is where that extra effort will come in.  While you might have to make the compromise to get things done, knowing how to implement it the more efficient way (or exploring other options after the fact) should also be a priority.  Maybe you have to spend some time out of the office working with it, doing some reading etc, but then next time the better method might be more realistic because they’ve already done the research.  Making a decision with full knowledge of your alternatives to use the much quicker to implement (but slightly worse performing) option is perfectly acceptable in my book and completely different than just blindly implementing things because you know how to do it one way and don’t feel like learning any other ways of doing it.

SQL Server is such a broad area that even the people at Microsoft working on it could probably walk out of the query optimizer room and into the indexing room and learn things.  Think about that for a moment.  The people writing the software (with many years of experience) can still learn things just by walking into the next room and asking a co-worker.  (OK, there probably isn’t actually a Query Optimizer Room, but how cool would it be if there was.  I wonder if they’d have execution plan wallpaper.)

You’re probably never going to know everything about SQL Server, but if the only time you ever devote to learning more is based on the problems you encounter in your day Job, then in my opinion you will always be limited.  Don’t get me wrong, you will very often be required to learn new things to do your job, but if that is all you do, you will always be reacting instead of being proactive.  Spending time reading Forums, Technical Blogs, books or participating in things like T-SQL Challenges will help you expand that knowledge to new areas that you probably could have been applying the whole time if you had known about them.  Of course, if you’re reading this, you’re probably already aware of all of that… but C’est la vie.

 
1 Comment

Posted in All

 

Blog Topics – Where do you draw the Line?

01 Apr

I started blogging a few months ago and since I started writing my own blog, I’ve been a much bigger follower of other technical blogs.  I now follow over 25 SQL blogs and add more on a regular basis. Some of the blogs I follow are updated every day and usually feature shorter articles.  Some of them are updated much less frequently and feature much longer and more in depth articles.  Most are somewhere in between.  Lately, I’ve been doing a lot of thinking about what warrants a blog post.   For me, figuring out what is worth writing about is almost as time consuming as actually writing it.

For example, I was working with data compression the other day and noticed several things that changed my decisions on some changes I was going to make in my environment.  One of these hinged around a clustered index key compressing extremely well with page level compression so that it was only slightly bigger than a clustered key that was much narrower.  The problem with this is, I can’t really explain why.  I can guess… and I might even be right, but is it worth putting it out there for people to read when I’m not really explaining why something happened?  You could argue that they’re at least aware of the concept after having read it and can be aware that it is one more factor to look at, but it’d obviously be much better if I could explain why it was happening and specifically watch what to look for.  Sometimes I’m able to do this research and figure it out… sometimes I either don’t have time or don’t ever get around to it and thus it’s a blog post that never gets written.  I’m the type of person that is never *really* happy with an explanation until *everything* is accounted for, so if I only wrote about things that I had no questions about, I’d only write about… well… ok, I wouldn’t have a blog at all.

I’ve done a lot of thinking about this particular topic over the past couple weeks and I’ve come to a decision.  That decision is that so long as I’m reasonably comfortable that I’m not presenting *incorrect* information, people will make up their own minds as to whether or not there is any value in it or whether or not they feel like reading it.  I personally enjoy reading many blogs that are technology related even when they don’t necessarily delve into specifics.  For example, posts about user group meetings, technology events, apps, office environments, daily life in technology, etc.  Attempting to figure out what people want to read before writing it every time is resulting in wearing one too many hats.

That’s not to say that I’m going to start writing what I eat for breakfast every day and post it online, but I am going to make more of an effort to not care if every single blog post completely exhausts a topic and answers every question.  A blog post doesn’t necessarily need to be a polished article that has gone through review a dozen times over.  I’ll leave it to the people reading to provide feedback as to whether or not I’m straying too far off the mark or whether they feel like an entry was too fluffy and stop trying to pre-screen.  If one of my posts stops one forum question, saves one person an hour of time or makes one person more active in the community, then it was worth it.  It doesn’t have to measure up in a side by side comparison to the best feeds in my reader.

This post itself is a good example.  Maybe it will help someone get over my same hang-ups about blogging, or help someone in a similar situation look at things in a different perspective.  Maybe it’s just touchy/feely drivel.  I leave that decision to you =).

 
No Comments

Posted in All