My Blog

AdamJorgensen : Most Recent postings

Don't miss a thing - Get free updates by RSS

• My First SQL Lunch
  SQL Lunch has been a great resource for a while now, delivering lunchtime presentations. I was recently asked to be the new co-host for SQL Lunch and I was honored to accept. We continue to drive some great speakers and content. I was the speaker yesterday and we covered building a cube over lunch. Feel free to check out the recording this week at http://bit.ly/ceaqiT !.  Register so you can get notified about all the upcoming SQL Lunch topics and speakers we have coming up. We will not sell or ...
  Webinars, speaking engagements
  3/2/2010  by AdamJorgensen  Comments: 0
• Batch Starting SQL Server Services
  Many times when going from demo to development to client demo, we are always starting and stopping our SQL Server services on the laptop very often. This can be a pain when you have to constantly go through the configuration manager. I have taken some common code and put into two batch files for your example. The code for the batch files will start all of your services and then there is a second file that will stop them. The code is as follows <Start Services File> NET START "MsSqlServer" ...
  shortcuts, Tips and tricks
  2/27/2010  by AdamJorgensen  Comments: 0
• Day 4 - Pragmatic Works Webinar Series
  Hey gang ! I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis Services Cube to and I’m going to show you how we can make it useful for reporting in short amount of time. We currently have over 800 folks for each of two sessions so there are some slots left. Get registered now athttp://pragmaticworks.com/resources/webinars/February2010Webinar.aspx  . Don’t miss it!
  Webinars
  2/25/2010  by AdamJorgensen  Comments: 0
• Brad McGehee is coming to SQL Lunch
  Mr. Exceptional DBA is coming to our SQL Lunch. Patrick and I are excited to welcome Brad MCGehee to SQLLunch.com. "No Fluff Just Stuff " for a presentation on being an exceptional DBA. Brad is always a crowd pleaser so make sure you get on and check it out!
  Webinars
  2/24/2010  by AdamJorgensen  Comments: 0
• I'm Presenting Tomorrow - Zero to Cube !
  I’m presenting tomorrow on Zero to Cube in 60 minutes. This is an all Demo Session for work with cubes and putting data in a form that can be analyzed and reported on quickly and efficiently through SQL Server Analysis Services.  Come check it out at http://pragmaticworks.com/resources/webinars/February2010Webinar.aspx . Brian Knight will be presenting the 9 am session since I will be travelling, but you’ll get me for the 1pm ! I’m looking forward to seeing all of you there !
  Webinars
  2/24/2010  by AdamJorgensen  Comments: 0
• Day 3 - Pragmatic Works Webinar Series
  Hey Guys and Gals ! If you missed the webinars today, you missed a great show! Brian took us through the fundamentals of SSIS and getting started with this exciting product. SSIS is such a powerful tool, not just for ETL and data warehousing, but for environment management, workflow processing and automation and enablement. Check out the recordings here and get started ! http://pragmaticworks.com/resources/webinars/February2010Webinar.aspx
  Webinars
  2/24/2010  by AdamJorgensen  Comments: 0
• Find Ultimate Parent at any Level From Any Level
  Recently I got a forum question that I thought would be a good blog entry for others to share. The question was “Adam, Is there a way to get the ultimate parent of a member when you have no idea what level it is at, how many levels separate it from the ultimate parent? Will just adding a large levels parameter value be valid even if that value is greater than the actual levels?” To Find the parent at any specific level, you can not only use member functions such as parent, prevmember, etc.., but...
  MDX, Member Level Functions
  2/23/2010  by AdamJorgensen  Comments: 2
• SQL Server 2008 R2 Gets a Real Date
  Hot Off The Presses ! This isn’t like when you stood in line at the kissing booth in high school. SQL Server 2008 R2 has a real date for release. It will be on the May price list and available May 2010. This is important since we have so many customers already leveraging many of the new features, and we are active evangelists for many of the new and very cool pieces of functionality. Check out the details here:http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-get...
  SQL Server 2008 R2
  2/23/2010  by AdamJorgensen  Comments: 0
• Day 1 - Pragmatic Works Webinar Series
  WOW – what a great turnout for our webinar series today. We had two sessions on Monday, looking for some great tips on getting started with management studio and introduction to T-SQL. We have over 750 people for each session, allowing us to help over 1500 folks get going in SQL Server yesterday. Session 1 – Jorge Segarra – @SQLChicken on Twitter – http://sqlchicken.com/  on the Web. Jorge took us through the ins and outs of Management Studio and managing a SQL Server database. The questions and...
  Webinars
  2/23/2010  by AdamJorgensen  Comments: 0
• Why doesn’t my Intellisense work?
  After yesterdays’ webinar, we got a lot of great feedback and questions. Once of the more common questions was around intellisense, getting it to work and why some folks don’t have it, even though they are running SQL 2008. The trick here is, you need to be running SQL 2008 engine, not just client tools. The intellisense feature is an engine feature that is bubbled up through the client tools in 2008. How do I know? Check out this screenshot of me connected to my system. The version you’re conne...
  SQL Server, Intellisense, SQL Options
  2/23/2010  by AdamJorgensen  Comments: 0