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

Archives: November 2009

Stop Splashing with -NoSplash

Many times when I'm teaching a class or working with a group, they express frustration at the load time for SSMS or BIDS.

 This is easily optimized by Using the NoSplash Command.

All you need to do is Right Click on the application for either BIDS or SSMS and select… Read more

0 comments, 100 reads

Posted in Adam Jorgensen on 23 November 2009

Great Post from Jamie Thompson

Hey there Gang !

 Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your… Read more

0 comments, 114 reads

Posted in Adam Jorgensen on 23 November 2009

SQL Saturday Orlando Presentations now online.

My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at SQLSaturday.com. Thank to all who attended and have emailed me questions about tuning your own SSAS environments. Check them out at SQLSAturday.com

  Read more

0 comments, 167 reads

Posted in Adam Jorgensen on 23 November 2009

South Florida Code Camp

I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for Intro to SQL Server Analysis Services and Hopefully it will get put on the schedule. The guys in SF always put on a great event ! See you there ! Read more

0 comments, 101 reads

Posted in Adam Jorgensen on 23 November 2009

New 2008 Microsoft BI Certifications Reviewed

I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I am a firm believer that this follows the rule of “it depends”. However if you’re a professional in a field, whether plumbing or technology, certification is a good way to… Read more

0 comments, 161 reads

Posted in Adam Jorgensen on 23 November 2009

Super Seven Cube Cleanup Steps

Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the things that demonstrate the consistency and usability that give our projects the credibility they need. How many times have you used an application that had weird glitches but the functionality… Read more

0 comments, 102 reads

Posted in Adam Jorgensen on 23 November 2009

MDX and DMX Templates

    One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA. Many of you probably use the T-SQL templates to quickly build common statements, but struggle with the syntx for their counterparts in these variation languages.

    Fear Not !

    If you…

Read more

0 comments, 164 reads

Posted in Adam Jorgensen on 23 November 2009

Check out my new blog location

My new blog has been centralized at http://www.bidevelopernetwork.com/blogs/AdamJorgensen/. Check it out for all my new updated content. Read more

0 comments, 114 reads

Posted in Adam Jorgensen on 23 November 2009

MDX, DMX, and XMLA Templates

    One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA. Many of you probably use the T-SQL templates to quickly build common statements, but struggle with the syntx for their counterparts in these variation languages.

    Fear Not !

    If you…

Read more

5 comments, 892 reads

Posted in Adam Jorgensen on 20 November 2009

Load Windows 7 with a Thumb Drive

 

With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked up a new Netbook and immediately desires to load Windows 7. I LOVE the new OS and am so pleased with it I have been running it since Beta with… Read more

0 comments, 99 reads

Posted in Adam Jorgensen on 19 November 2009

Super Seven Cleanup Steps Before Deploying Your Cube

    Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the things that demonstrate the consistency and usability that give our projects the credibility they need. How many times have you used an application that had weird glitches but the functionality…

Read more

0 comments, 902 reads

Posted in Adam Jorgensen on 13 November 2009

Tampa Code Camp

Looking forward to a great Tamp Code Camp tomorrow. My first code camp. I’ve had some great experiences at the one day conferences, but am really looking forward to my first code camp. The session list looks great! Can’t wait to see everyone there!

Check it out at - www.tampacodecamp.com Read more

0 comments, 98 reads

Posted in Adam Jorgensen on 6 November 2009

Identity Issues

 

    Have you ever received the following Error when developing your ETL or working with data cleanup?

     

    Msg 544, Level 16, State 1, Line 1

    Cannot insert explicit value for identity column in table 'tblDemo' when IDENTITY_INSERT is set to OFF.

     

    This is because the table has a…

Read more

0 comments, 95 reads

Posted in Adam Jorgensen on 6 November 2009

Great Post on Parallel vs.. Series SSIS

Mike Davis, Author and consultant extraordinaire recently posted a great new take on parallel vs. series SSIS packages. Some interesting results and Myths dispelled here :

 

http://blogs.pragmaticworks.com/mike_davis/2009/11/ssis-parallel-vs-series-data-flows.html

 

Check it out ! Read more

0 comments, 203 reads

Posted in Adam Jorgensen on 6 November 2009

Importing a SQL Server 2008 Analysis Services Database

    Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to create a new project from an existing database either in development or production.

    First - Select to Create a New Project in BIDS (Business Intelligence Development Studio) and Choose the…

Read more

0 comments, 429 reads

Posted in Adam Jorgensen on 3 November 2009

Date Expressions in SSIS

There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted across the web and I use many of them on a regular basis in my coding. It can be difficult however to get a single source for many of these…

Read more

0 comments, 212 reads

Posted in Adam Jorgensen on 3 November 2009

Quickly View Session Information with Query Text

One of the most common problems facing a DBA or developer in troubleshooting performance is identifying what processes, and by association, what queries are causing the slowdown or symptoms. The first step used to be run SP_Who or SP_WHO2 and pour through the data. There are also a number of…

Read more

0 comments, 115 reads

Posted in Adam Jorgensen on 3 November 2009

South Florida SQLSaturday

It’s very exciting to be involved with the SQL Saturday here in South Florida. There are already so many great sessions on the schedule, and the tracks will be finalized soon. I have submitted two sessions. MDX Fundamentals and Performance Tuning SSAS.  Brian Knight         and Devin Knight are also slated…

Read more

0 comments, 92 reads

Posted in Adam Jorgensen on 3 November 2009

Ups and Downs of Cases in SSMS 2008

Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features in SSMS. Now, Intellisense is a powerful tool to help developers be more efficient, but for professionals who haven’t had it for the last 15 years, it can take some…

Read more

0 comments, 96 reads

Posted in Adam Jorgensen on 3 November 2009

Tabs Out of Control

I was working with a team of developers this week who were having the hardest time finding the keystroke to close and disconnect a tab in SQL Server Management Studio. It’s very simple so I thought I would post it here. I know many of you use keystrokes when working…

Read more

0 comments, 86 reads

Posted in Adam Jorgensen on 3 November 2009

Older posts