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

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

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

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

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

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

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

The 6^th 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

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

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

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

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

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

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