Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2010

Pesky Protected Mode

How many of you keep falling for this one…You open up Report Manager for a user that you know you have given access to view reports. Only to see this annoying error! It is basically stating that the user BIGMAC has not been given the appropriate permissions to browse to… Read more

0 comments, 615 reads

Posted in BrianKMcDonald on 29 July 2010

Commenting TSQL Scripts

If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even thousands of blogs or articles written about them. This blog won’t be much different from others out there and it is a very, very, very basic concept. However, time and… Read more

1 comments, 628 reads

Posted in BrianKMcDonald on 29 July 2010

What Indexes are on My Table!

In this quick blog, I want to show you one way of how to find out what indexes you have on a table using SQL Server Management Studio (SSMS). When you have SSMS running and are connected to the database engine, navigate down the database hierarchy to the Tables folder.… Read more

0 comments, 178 reads

Posted in BrianKMcDonald on 29 July 2010

Indexes and their Effect on Query Performance

Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the last 100 records from a table could take forever to return. Well, maybe not forever, but you get the point. For example, I have a query and its results of… Read more

0 comments, 398 reads

Posted in BrianKMcDonald on 29 July 2010

Checking Users AD Groups Using Windows CMD

Blog Title: Checking Users AD Groups Using Windows CMD

 

Depending on your role in the organization, there may be a time when you have to try and determine active directory information for a given user on the network. As a DBA or a consultant, I have found that I’ve had… Read more

0 comments, 262 reads

Posted in BrianKMcDonald on 29 July 2010

Limiting Table Access for Reporting Part 2

Blog Title: Limiting Table Access for Reporting Part 2

 

In the first blog post of this series, I showed you how to create a database schema and how to create a view. In this post, I will wrap it all up and show you how to create a SQL Server… Read more

0 comments, 161 reads

Posted in BrianKMcDonald on 29 July 2010

Limiting Table Access for Reporting Part 1

End users may have a need to do some form of reporting of data from source systems. Opening up the database tables to end users normally isn’t the best practice, but different situations often require different implementations right? In this blog series, I am going to show you one method… Read more

0 comments, 161 reads

Posted in BrianKMcDonald on 29 July 2010

Jacksonville Code Camp – Introduction to Reporting Services 8.28.2010

The 6th Annual Jacksonville Code Camp is coming up fast. There are tons of great presenters slated to be here giving free training and demonstrations on the latest and greatest products out there. Below are some of the details about the event, what my presentation will be on and… Read more

0 comments, 138 reads

Posted in BrianKMcDonald on 26 July 2010

JULY 31: SQL Saturday 40

SQL Saturday #40 is quickly approaching and many are gearing up for the trip down there to hear some awesome speakers on various subjects. Many are Business Intelligence related, but there are others available to for all of you true developers out there. At any rate, I am going to… Read more

0 comments, 182 reads

Posted in BrianKMcDonald on 20 July 2010

Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer

Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more than willing to put in the time to achieve this monumental task. J At any rate, as a network bandwidth conscientious guy that I am, I wanted to decrease the… Read more

0 comments, 213 reads

Posted in BrianKMcDonald on 19 July 2010

Updating Email Addresses in SSRS Subscriptions

Creating subscriptions in SQL Server Reporting Services is a great way to distribute files to end users. If it has been a while since you have begun using subscriptions and you have a bunch of them out there, there will more than likely come a time when at least one… Read more

1 comments, 1,417 reads

Posted in BrianKMcDonald on 19 July 2010

Strange But True: Report Builder 2.0 Crashing

Recently, I have been given the opportunity to work with a company who wanted to explore the capabilities of Report Builder 2.0. After installing the stand alone client (if you want more details on this or the link to download the file read one of my earlier blogs),… Read more

0 comments, 128 reads

Posted in BrianKMcDonald on 18 July 2010

Report Builder Stand Alone Installation

If you’re planning on rolling out Report Builder to end users, you may want to download the stand alone installation from Microsoft. Then you could store it on a file server and send links to anyone that you want to install the Report Builder thick client. Although the links on… Read more

0 comments, 283 reads

Posted in BrianKMcDonald on 18 July 2010

Retrieve Space Used Details for Table

Every once in a while, you may have a need to determine how much space is being used by a table in your database. In this quick blog, I am going to show you how to get the some details on a particular table using the system stored procedure sp_spaceused.… Read more

0 comments, 163 reads

Posted in BrianKMcDonald on 7 July 2010