Search Results: tips and tricks

• 
  SSIS 2008: Tips and Tricks video by Steve Swartz

  Today I listened to this very good informative video by Steve Swartz which I wanted to share with you all. This is a presentation by Steve Swartz in the Microsoft TechEd Europe 2010. In this presentation Steve says that he desires to teach you how to fish

  Author:  indupriya     Date: 1/7/2011     Section: Blog

  tags : Microsoft TechEd Europe 2010, Steve Swartz, SSIS Tips and Tricks
• 
  Sharepoint Administration Expo -- February 11

  Here is a link to the Free Sharepoint Administration Expo organised by SSWUG on February 11th 2011 from 9 am to 1 pm PST Sessions will cover the following topics: * Configuring SharePoint Anonymous Access: Tips and Tricks * Understanding SharePoint Blogs,

  Author:  indupriya     Date: 2/1/2011     Section: Blog

  tags : Sharepoint Adminsitration Expo, Sharepoint Expo, SSWUG
• 
  Speaking at Greater New Orleans .Net User Group (GNO.NET)

  This week I will speaking at the Greater New Orleans .Net User Group. My topic is Introduction to the SQL Server Profiler. If you want to learn some tips and tricks that you can use when trying to identify performance problems with your SQL Server stop by

  Author:  PatrickLeBlanc     Date: 7/12/2010     Section: Blog

  tags : Patrick LeBlanc, User Groups, Speaking
• 
  Free T-SQL Training - SQL Lunch #25 (Transact-SQL Development and Deployment)

  Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL development and deployment . Go to SQL Lunch and add this event to your calendar or use the link in this posting. To receive notifications ab

  Author:  PatrickLeBlanc     Date: 7/13/2010     Section: Blog

  tags : Speaking, T-SQL, SQL Lunch
• 
  SQL Rally 2012 Recap In Yo’ Face!

  This past Thursday and Friday I attended my first PASS SQL Rally event in Dallas, Texas. The week was full of some pretty amazing sessions presented by some even more amazing speakers. If you were a DBA looking for performance tuning tips or other ways to

  Author:  DustinRyan     Date: 5/14/2012     Section: Blog

  tags : community, SQLRally
• 
  First SQL Lunch of the Year - SSRS Tips and Tricks with Pam Shaw

  Last Year was a great year for the SQL Lunch. We had so many great presentations. I am really excited about this year and what we have coming up. There are three lunches scheduled for this month and we are going to be making a BIG announcement about what

  Author:  PatrickLeBlanc     Date: 1/11/2011     Section: Blog

  tags : SSRS, SQLLunch
• 
  Complete SQL Server Query Perfomance Tips and Tricks

  SQL Query Performance Tips: Difference between Clustered and Non-Clustered Index Data Structures When you first create a new table, there is no index created by default. In technical terms, a table without an index is called a “heap”. As you w

  Author:  pkumar3     Date: 5/1/2012     Section: Blog

  tags : SQL Server, SQL Server 2008 R2
• 
  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 com

  Author:  AdamJorgensen     Date: 2/27/2010     Section: Blog

  tags : Tips and tricks, shortcuts
• 
  Turn Rows into Columns in Excel

  Have you ever had to take a long column of data in Excel and turn it into a column? There are several ways to do this but lately I have been using a new PASTE feature to do this.Here’s how it works. 1. Take a long row of data as shown below. 2. Select and

  Author:  AdamJorgensen     Date: 11/22/2010     Section: Blog

  tags : tips and tricks
• 
  And Here I Go.....

  After some false starts during the past 4 years, I'm finally going to take the plunge into Business Intelligence, SQL Server style! I attended SQL Saturday #130 in Jacksonville, FL and while it was not my first SQL Saturday, I have to admit just like the

  Author:  adavid     Date: 5/1/2012     Section: Blog

  tags : newbie
• 
  My First day in Pragmatic Foundation Works Sep 2012

  Introduction given today by Joe Salvatore was amazing.The way he introduced to basic select statements and select statements for filtering data and using different clauses with real time examples was very awesome and interactive . Also we were asked to wr

  Author:  Lavy     Date: 9/18/2012     Section: Blog
• 
  SQL Server Management Studio (SSMS) Tips and Tricks

  1. Change the status bar in the "New Query" window to red when connected to production or green when connected to development. I recently uninstalled the SSMS Tools Pack ( www.ssmstoolspack.com ) because it was crashing whenever I connected to an Analysis

  Author:  MMilligan     Date: 10/26/2012     Section: Blog