home  »  blogs  »  sqlscottgleason  »  What three events brought you here?

To rate this blog entry please  register or login

Author

sqlscottgleason sqlscottgleason (Member since: 11/13/2009 1:41:48 PM)

View sqlscottgleason 's profile

Comments (1)

  • PatrickLeBlanc 1/18/2010 7:48:22 AM by:  PatrickLeBlanc
    So I am up next. Coming soon!!!

Post a comment

Comment (No HTML)  

Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

Blogs RSS Feed

sqlscottgleason's latest blog posts

  • How to Transfer SQL Logins Between SQL Servers
    1/26/2010 7:59:29 AM
    If your building a new sql server, you'll need to move the SQL user accounts and their passwords to the new server.  This works for sql 2005 and sql 2008 servers. Here is the link to the orginal article http://support.microsoft.com/kb/918992     This article describes how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers.For more information about how to transfer the logins and the passwords between instan...
  • What three events brought you here?
    1/17/2010 2:39:35 PM
    Recently Paul Randal posted What three events brought you here ?  He bascially ask "what three life-direction-changing-events" have brought you to where you are today? Which is a very interesting question that comes up from time to time at the 'After Event' for the Jacksonville SQL Server Users Group.  I'm always interested in people's stories of how they became DBAs.  While most of the stories I hear are of Accidental DBAism, the details of the story are never the same and are very intresting. ...
  • Configure Group Policy to keep RDP session to a minimum on your SSIS boxes.
    1/4/2010 5:57:49 PM
    Configure Group Policy to keep RDP session to a minimum on your SSIS boxes Active Directory Group Polices overwrite local policies on a windows server.  With that fact in mind, if you know that here are no AD policies for RDP Session time limits, and you have admin privileges to the local box, and you need to introduce some type of time restrictions on the RDP session; this might be exactly what you are looking for. Before we begin, I do need to bring up the old warning:  Don’t implement this in...
  • Where are my “Indent” and “Un Indent” icons within Bids “Script Task Editor”?
    12/15/2009 3:18:10 PM
    Where are my “Indent” and “Un Indent” icons within Bids “Script Task Editor”? On the default toolbar, you have comment and uncomment code, but Indent and Un Indent are missing. You'll have to customize your tool bar and add them. From the Menu click thru View -> Toolbars -> Customize… Within your Customize Window, select “Edit” from the Categories: window and then scroll in the Commands window until you see “Line Indent”   Now click and Drag the “Line Indent” icon up to your Standard tool ...
Blogs RSS Feed

Latest community blog posts

  • Minimizing Fragmentation when Moving data using a Switch
    3/17/2010 11:53:13 PM
    Yesterday was the first day of the SQL Server 2008 R2 airlift.  I attended a great session on Implementing a Fast Track Data Warehouse.    Lots of really interesting information was discussed during the meeting. However, an offline discussion about switching partitioned data in from a stage table provided a good tip that could help reduce fragmentation. If you are constantly switching data into your partition table you could potentially introduce some unwanted fragmentation in your database.  Th...
  • Using SSAS MDX Calculation Color Expressions
    3/17/2010 12:10:25 AM
    Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that adds just a little more wow when your end users browse the cube.  By building a color expression on a calculation you can change either the fore color or background color of a measure value.  Here you can write an MDX expression that will change the font or background color of a cell when a user selects the calculation.  A very basic example is...
  • Free and Discounted Microsoft Learning Resources
    3/15/2010 11:06:43 AM
    I was browsing the Microsoft Learning portal over the weekend and came across the following free or dicounted learning resources for SQL Server. Free Resources: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform (1 hour)   Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence (1 hour) Clinic 6190: What's New in Microsoft SQL Server 2008 for Database Development (1 hour) Clinic 6258: New Features Of Microsoft SQL ...
  • SQL Agent jobs
    3/14/2010 2:46:26 PM
    Recently I was asked to provide a list of all sql jobs on a certain server running between 2 and 3 in the morning.  We have quite a few jobs and it would be time consuming to look through each to determine the time of day each runs.  So I used the sysjobs, sysjobsschedules tables to return the job name and times the jobs run. There are several jobs related tables in the msdb database: sysjobs sysschedules sysjobhistory sysjobsteps syscategories   The table names are pretty self explanatory.  The...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown.   If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...