SQL Server BI, Life, and Running a BI Firm

Who is online?  0 guests and 0 members
Home  »  Blogs  »  AdamJorgensen: November 2009

Communifire Blogs

Blogs RSS Feed

AdamJorgensen :November 2009 postings

AdamJorgensen

Stop Splashing with -NoSplash

11/23/2009 by AdamJorgensen  -  Comments: 1  -  Views: [2073]

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 PROPERTIES. Then add <-nosplash> to the end of the path as shown below:

Read More

AdamJorgensen

Great Post from Jamie Thompson

11/23/2009 by AdamJorgensen  -  Comments: 1  -  Views: [1973]

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 DW while leaving the foreign keys intact. This is a great option when you need to debug or are working in development mode to test load speeds, etc.. Check it out here - http://sqlblog.com/blogs/jamie_thomson/archive/2009/09/08/deriving-a-list...

Read More

AdamJorgensen

SQL Saturday Orlando Presentations now online.

11/23/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1351]

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

AdamJorgensen

South Florida Code Camp

11/23/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1284]

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 ! http://codecamp09.fladotnet.com/Default.aspx

Read More

AdamJorgensen

New 2008 Microsoft BI Certifications Reviewed

11/23/2009 by AdamJorgensen  -  Comments: 0  -  Views: [3318]

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 ensure a rounding or your skills. You may be a 400 level guru in SSIS, but you’ve never had to monitor a cube for performance issues or deploy Kerberos in SSRS. I tested and received my MCDBA some years ago and I rea...

Read More

AdamJorgensen

Super Seven Cube Cleanup Steps

11/23/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1989]

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 was cool? Most of the time you wound up not using it after a while because the inconsistency was too much. It is the same with a SSAS Cube. When you develop a cube for reporting and analysis, those thousands o...

Read More

AdamJorgensen

MDX and DMX Templates

11/23/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2636]

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 will do this with me: Open SSMS and Go to VIEW > TEMPLATE EXPLORER Select the Analysis Cube Option (This will load the SSAS related Templates) Browse through the query options in this window Now we have ...

Read More

AdamJorgensen

Load Windows 7 with a Thumb Drive

11/19/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1541]

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 minimal issues. The easiest way IMHO, is to load it from a Thumb drive. This is a super easy and fast way to load your new OS and make sure your Netbook runs the way you want it to. Check out this link from MS with a step by step and a vid...

Read More

AdamJorgensen

Books You Should Own

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2560]

Have you ever wondered where to go to get good information that will help you in your day to day SSAS development life? There are many options from community websites like ssas-info.com, sqlservercentral.com, sql-server-performance.com , and of course Microsoft's TechNet and MSDN sites get better with every release. They have become my go to source for many things (which is an improvement over the past for sure). Sometimes though we all need a good book to thumb through, ear mark pages, highligh...

Read More

AdamJorgensen

Importing a SQL Server 2008 Analysis Services Database

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [4274]

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 Import Analysis Services Database option and create the names and location for your projects etc.. At the bottom. Second - Connect to the server desired (you must have permissions to do this), and choos...

Read More

AdamJorgensen

Star Join Optimization in SQL Server 2008

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [7029]

When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow a "star pattern". This pattern consist of Fact data being retrieved along with it's related dimension data from a start schema. What makes the Star Schema look like a star is the dimensions rotating around the Fact Table. See a good example of it here. Star queries also usually have most, if not all, of the following characteristics: They follow a pattern of joining fact tables with...

Read More

AdamJorgensen

Date Expressions in SSIS

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [15233]

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 since many of us use the ones we need and move on. This blog entry (and follow ups) will highlight the most useful date strip/manipulation expressions on the web and link back to their creator/publisher. Let's dive in ! This wiki over at SQL...

Read More

AdamJorgensen

Smarter Intellisense

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1699]

Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I hear from database developers (especially those who have migrated from .NET) is that the intellisense seems to miss some recently created objects. They cry out "My object doesn't appear in the drop down". Well, I am not an Intellisense internals guy, but I will share with you the most common fix for this problem. If you click on CTRL-SHFT-R or Edit > Intellisense > Refresh ...

Read More

AdamJorgensen

Identity Insert Guideline

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2573]

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 column marked for identity. The best way around this is to use a table option called IDENTITY_INSERT. This will allow you to insert a row into a table including an identity value for troubleshooting, issue resolution, or reseeding ...

Read More

AdamJorgensen

Quickly View Session Information with Query Text

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2235]

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 great customizations to this stored procedure available across the internet. This can be time consuming, however, both due to the volume of data, and the potential extra pressure to TEMPDB if run during an a...

Read More

AdamJorgensen

South Florida SQLSaturday

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1224]

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 to do sessions, so the whole gang will be there! Make Sure you register soon ! Check out all the sessions at SQLSaturday.com.

Read More

AdamJorgensen

Ups and Downs of Cases in SSMS 2008

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1555]

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 getting used to. Now – The biggest complaint was that the old keyboard shortcuts for forcing all the highlighted text to UPPER CASE or lower case did not work the same. Specifically that CTRL-SHFT-U worked to force UPPE...

Read More

AdamJorgensen

Tabs Out of Control

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1331]

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 with multiple tabs, so to close and disconnect, use CTRL + F4. Happy Tabbing.

Read More

AdamJorgensen

Table and Index Partitioning Demo

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2055]

I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in SQL Server 2008. So in the spirit of education I have adapted the demo from the new features white paper from Microsoft, added explanations and guidance as to how to use it, and posted it here. I have also modified the example to show additional functionality if you choose (for you perpetual partitioning practitioners). Alliteration aside, this functionality is one of the few that is...

Read More

AdamJorgensen

Smooth Compound Operators

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [3115]

Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be compound operating like a champ. In SQL 2008 there is a new feature called .. you guessed it … Compound Operator. What Microsoft means by this is they have implemented functionality that allows you to perform an arithmetic operation and assign the new value to a variable in the same operation. This is extremely useful and will cut down on your code volume and complexity. I had been reading up on these t...

Read More

AdamJorgensen

Kick xp_sendmail to the curb

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [4521]

With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had several options for working with email in the database. You could use any of the following procedures: XP_SENDMAIL – Click here for details on this procedure XP_READMAIL– Click here for details on this procedure SP_PROCESSMAIL– Click here for details on this procedure All of this functionality except for send was deprecated in the new version of mail for SQL 2005 and 2008 called ...

Read More

AdamJorgensen

Week of Warehousing - Questions Answered

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [2565]

Greg emailed me a great question from my week of warehousing webinar the other day. We were discussing disk performance and kept saying the term “spindles”as in using more of them to increase performance and throughput. The term means an individual hard drive in array. Many large disk systems have trays of disks that are logically allocated to something called a LUN or Logical Unit Number, or in Windows terms, a logical drive that windows can see and SQL Server can write to. There are a few othe...

Read More

AdamJorgensen

Check out Straight to 8 Program

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1515]

We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to you a great series of webinars that is being delivered by Microsoft. They cover all the reasons you should examine SQL Server 2008 as your next generation relational and intelligence platform and, of course, will have lots of great examples of the big improvements Check out all the action here !

Read More

AdamJorgensen

Week of Warehousing Review

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1437]

How exciting was last week! Some of the top experts in the country all gathered together through support from SQLServerCentral.com, Wrox and Wiley Press and of course, us here at Pragmatic Works. The week went well and I want to point you to a few links where you can watch the webinars from the Week of Warehousing. All Presentations and Slides are here . You will want to especially check out yours truly’s session on performance tuning. I got a lot of great questions from the webinars and will be...

Read More

AdamJorgensen

The Enduring DBA

11/3/2009 by AdamJorgensen  -  Comments: 0  -  Views: [1505]

We are all facing the challenges of this new economy. There are very few people and industries in the world today that have been unaffected by the failures and poor management of some of our largest institutions. I would like to discuss an alarming trend that I have seen in organizations around the country. Just being the Senior DBA will not protect you from a potential downsizing. Many people are not doing what they can to show the value they bring AND create for their company. There are lots o...

Read More

Page 1 of 1 (25 items)