Search Results: TSQL

• 
  SSAS Dimension Properties : Misc and Source

  Previously I’ve blogged about both Basic dimension properties ( here ) and Advanced dimension properties ( here ), so today I’d like to finish off this initial set by blogging about the misc and source sections of the properties of an attribut

  Author:  ChrisSchmidt     Date: 3/4/2013     Section: Blog

  tags : dimension misc properties, dimension properties, dimension source properties
• 
  SQL Server 2012 TSQL Conversion Functions Part 4

  SQL Server 2012 TSQL Conversion Functions Part 4 In this forth blog post we will cover the new Conversion functions available in SQL 2012. This is the second to last topic of this miniseries of blog posts covering the new TSQL function in SQL server 2012.

  Author:  ChrisAlbrektson     Date: 6/11/2012     Section: Blog

  tags : SQL Server 2012 Functions, TSQL, TSQL 2012
• 
  FREE I.T. TRAINING FOR BASIC TSQL

  The company I work for, Pragmatic Works, has a non profit organization called Pragmatic Works Foundation. We offer a free week of TSQL training for individuals who would like to join the I.T. community. The material covered will be based on SQL Server 200

  Author:  SMcDonald     Date: 6/29/2010     Section: Blog

  tags : foundation, pragmatic works, tsql, t-sql, free training
• 
  Back to the TSQL Basics! Part 2 of Many :-)

  Tonight I want to talk about the different types of Keys in your relational database. Diving into the keys was encouraged by one of our proud BIDN.com bloggers who responded to a previous post. I also believe getting a little heavy in the topic will be go

  Author:  SMcDonald     Date: 6/22/2010     Section: Blog

  tags : alternate key, candidate key, composite key, foreign key, natural key, relational database keys, surrogate key, tsql, pragmatic works
• 
  Back to the TSQL Basics! Part 3 of Many :-)

  As I have mentioned in my previous blogs, I am definitely starting at the basic level of TSQL. I am doing this because there are a lot of people who are looking for a change in career and want to get into database administration. Starting at the basics is

  Author:  SMcDonald     Date: 7/2/2010     Section: Blog

  tags : commands, pragmatic works, tsql
• 
  SQL Server 2012 TSQL Logical Functions Part 2

  Last week I started a 5 part miniseries covering the new TSQL functions in SQL 2012. Last week in part 1 I covered the new string functions. This week we will be taking a look at the Logical functions. The first function we will be looking at today is the

  Author:  ChrisAlbrektson     Date: 3/13/2012     Section: Blog

  tags : SQL Server 2012 Functions, TSQL Functions
• 
  SSRS 2008 R2 June Webinar Details

  Today I gave a presentation on how to create some awesome reports using the Sparkline, Map and Data Bar (all R2 features). I also discussed some of the different areas you could use expressions and showed some different examples. I am really excited that

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

  tags : Databars, Maps, Pragmatic Works, Sparklines, SSRS, SSRS 2008R2, Training on the T's, Sherri McDonald
• 
  One last day in the Foundation Class

  As some of you may know, I work for Pragmatic Works. Not only are we already an awesome company to work for, but something else that is pretty fantastic is give away a free week of BI training. This training is given to people who have served in the milit

  Author:  SMcDonald     Date: 3/3/2011     Section: Blog

  tags : Foundation, Free BI Training, Pragmatic Works, Reporting Services, SSRS, TSQL, Sherri McDonald
• 
  Windows could not start the SQL Server Analysis Services Default Service

  So today I was firing up my vm to do some work with Analysis Services Multidimensional. I booted it up, opened up SSMS, and went to connect to my AS instance. Then I received a pretty straightforward error message: Ok, I thought, no big deal. Start &ndash

  Author:  ChrisSchmidt     Date: 1/3/2013     Section: Blog

  tags : SSAS service
• 
  Hierarchies in SSAS Multidimensional: What’s really happening up (or down) in there?

  A few days ago I got an interesting question. The question was “When you build an hierarchy in SSAS, what’s actually happening to it on disk?” As in, how does the file system actually place it in files so it can easily identify the hiera

  Author:  ChrisSchmidt     Date: 3/5/2013     Section: Blog

  tags : hierarchies, natural hierarchy, unnatural hierarchy
• 
  How to move the tables without having clustered index from one file group to another file group simply in SQL 2008.?

  Hello All, This might not be the proper for the blog post but it helps me to understand more regarding the transfer of tables within different file groups in MS-SQL. So, I think it will be more helpful to the others who indeed needs such information relat

  Author:  Anil     Date: 1/18/2012     Section: Blog

  tags : File groups FG's, T-SQL
• 
  Speaking at Auckland, New Zealand SQL Users Group

  On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group . This will be my first International speaking engagement. I will be doing a session on SQL Server Integration Services . Since I don’t have time to make the trip to

  Author:  PatrickLeBlanc     Date: 4/25/2010     Section: Blog

  tags : Speaking, SSIS, Users Group, Patrick LeBlanc
• 
  Speaking at Charlotte, NC - SQL Saturday #33

  If you are near Charlotte, NC , I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server Compression 101 is at 1:30 PM. This is the first SQL Saturday under PASS management. If you have not registered for this event do so, seats

  Author:  PatrickLeBlanc     Date: 3/1/2010     Section: Blog

  tags : Compression, Speaking, SQL Saturday, Patrick LeBlanc
• 
  JSSUG Speaker Idol 2012 Review

  Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what the events all about here . The event was a success and the speakers all got some great feedback from our panel of experienced speaker

  Author:  DevinKnight     Date: 8/21/2012     Section: Blog

  tags : JSSUG, Speaker Idol
• 
  Return Indexes for a Particular Table using TSQL

  I posted a blog recently about returning a listing of all indexes for database , which is good if you want to see how many are in a database. However, you may want to return the indexes for one particular table. Script 1 shown below will do just that! Jus

  Author:  briankmcdonald     Date: 10/16/2010     Section: Blog

  tags : Brian K. McDonald, List Indexes For Table, TSQL
• 
  SQL Server 2012 TSQL String Functions Part 1

  With all the excitement from the release of SQL 2012 RTM the other day I have decided to create a 5 part series covering the new TSQL functions that are now available to us. This first blog will consist of the string functions that have been added. Over t

  Author:  ChrisAlbrektson     Date: 3/9/2012     Section: Blog

  tags : SQL Server 2012 Functions, TSQL Functions
• 
  TSQL for the Absolute Beginner Series 1 of hmmm....not for sure

  Let’s learn a little T-SQL. Yes, I am doing a series on T-SQL for the absolute beginner who is interested in understanding how to get specific pieces of information for their company’s data. Do you know what are the top selling products or who

  Author:  SMcDonald     Date: 11/29/2011     Section: Blog

  tags : SQL server Management studio, SSMS, T-SQL
• 
  Fully Qualified Stored Procedures

  The other day while working at a client site, we were creating SSIS packages that would execute using TSQL in order to load a database. We wanted to eliminate having a bunch of different shared data sources and then having to create configuration files fo

  Author:  SMcDonald     Date: 11/3/2010     Section: Blog

  tags : fully qualified, Pragmatic, Sherri McDonald, SSIS execute SQL Task, stored procedure, Harding coding
• 
  Creating the SSIS 2012 catalog

  In SSIS in SQL Server 2012, it is no longer necessary (for new installations/packages) to install a separate integration services instance onto the server. It can all be managed from within the database engine. In order to be able to utilize this feature,

  Author:  ChrisSchmidt     Date: 12/17/2012     Section: Blog

  tags : Catalog, SSIS 2012
• 
  Tabular Databases: The workspace server was not found

  Sometimes, due to environment changes or some other reason, you want to change the workspace database that you are developing your tabular model against. I recently had a need to do this as my old tabular database instance was no longer active. When I wen

  Author:  ChrisSchmidt     Date: 22 days ago     Section: Blog

  tags : ssas 2012 tabular, workspace database was not found, workspace databases
• 
  Sorting Month Names In DAX

  I was recently helping a client set up their PowerPivot workbook for the first time and when they brought the months over on the pivot table, the results of the month weren’t sorted. So for example, April and August were the first months the list. T

  Author:  ChrisSchmidt     Date: 10/19/2012     Section: Blog

  tags : PowerPivot
• 
  Using the new TSQL MERGE Statement with SQL Server 2008

  Using the new TSQL MERGE Statement with SQL Server 2008 The MERGE statement that was added with SQL Server 2008 provides a better way to manage and update/delete/insert into our dimension tables for our data warehouses. It is very common, when loading dat

  Author:  bretupdegraff     Date: 12/4/2009     Section: Blog

  tags : ETL, MERGE
• 
  TSQL Basics Part 4 - Stored Procedure

  First and foremost, let's start off with a definition of a Stored Procedure: It is a compiled set of SQL Commands stored within a database server and is executed as single entity. In this blog, I wanted to show you how to create a couple of different Stor

  Author:  SMcDonald     Date: 7/19/2010     Section: Blog

  tags : BIDN, Parameters, Pragmatic Works, TSQL, Stored Procedures
• 
  SQL Server Analysis Services Webinar

  Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics themed free training. This webinar is for anyone trying to understand the basics behind Analysis Services and how to get started design

  Author:  DevinKnight     Date: 4/1/2013     Section: Blog

  tags : Decision Matrix, Webinar
• 
  Practice Your PASS Session on the SQL Lunch

  We at the SQL Lunch would like to extend an invitation to all of the PASS speakers. If you are looking for a place to practice your PASS session please email us at webmaster@sqllunch.com . Don’t worry, you can have up to 90 minutes or you can break your s

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

  tags : PASS, Speaking, SQL Lunch