Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Writing
167 results found
Introduction to SSRS Report
Writing
Part 2
It has been just over a month since I wrote the article Introduction to SSRS Report Writing Part 1. I wanted to follow-up that article with a blog to show you how to write an expression on how to alternate the colors in your report. Now, if you are new to
Author:
SMcDonald
Date: 1/24/2011 Section:
Blog
tags :
Expression
,
Introduction to SSRS
,
Pragmatic Works
,
Reporting Services
,
Sherri McDonald
Reporting on an SSAS Cube with SSRS 2008
In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.
Author:
DustinRyan
Date: 5/7/2010 Section:
Article
tags :
MDX query
,
MDX query designer
,
SSRS cube report
,
SSRS 2008
Hey, >> PragmaticWorks authors / bloggers << -- a writing question for you
Something that I admire about the Pragmatic Works employees that I read on here - you all seem to have very concise writing styles. Are you hired already having strong written communication skills? Do you have additional training for that? Do you "just" p
Author:
KeithHyer
Date: 10/26/2011 Section:
Forum
tags :
blogging
,
technical writing
,
writing
SSIS MySQL Destination
Here are a few links that may be of assistance. I don't know that there is a destination specific to MySQL, but these demonstrate how to configure the existing ODBC drivers to access MySQL. http://blogs.msdn.com/b/mattm/archive/2009/01/07/writing-to-a-mys
Author:
KeithHyer
Date: 3/29/2013 Section:
Forum
tags :
ADO.Net
,
MySQL
,
ODBC
SQL Server 2012 - IIF Function
In earlier versions of SQL Server, when you were writing T-SQL, how many time you asked yourself "is there a if function?". Even when you used CASE function, how many time did you said "if there was a if function, this was a lot easier". Well, finally wit
Author:
marcoadf
Date: 12/19/2011 Section:
Blog
tags :
case
,
function
,
if
,
IIF
,
limitation
,
nested
Want a Chance for FREE Training @Pragmatic Works
I am super excited to announce that there is a strong demand for the Foundation Training to be held more frequently. Our last one was held in August and several people were hired for Jr. DBA and Report Writing opportunities. We also have more companies in
Author:
SMcDonald
Date: 9/2/2011 Section:
Blog
Intro to SSRS Basic Report
Writing
Part 1
In this article, Sherri will show you how to put together a very basic report and then eventually we will build on that same report in my next post.
Author:
SMcDonald
Date: 12/16/2010 Section:
Article
tags :
Reporting Services
,
SSRS
,
Sherri McDonald
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was: None of the result expressions in a CASE specification can be NULL. It was a long T-SQL script (and a long
Author:
JoseChinchilla_SQLJoe
Date: 11/16/2011 Section:
Blog
tags :
case
,
case statement
,
Error
,
sqlserver
,
syntax
,
T-SQL
Valuable lessons in loading a .dbf file in SSIS packages
During my short time here at Pragmatic Works I have come across some VERY valuable lessons. The most important one so far is being able to decipher certain error messages in SSIS when executing a package that keeps failing; something I am sure everyone in
Author:
tiffswn
Date: 3/8/2011 Section:
Blog
tags :
CANNOTACQUIREFROMCONNECTIONMANAGER
,
error code 0xC0202009
,
Jet Driver
,
OLE DB
,
SSIS
,
Connection Manager
DTS TO SSIS Migration
Yes writing expressions for Perameterized Queries has Pros and Cons Pros: 1) Provider independent approach (e.g. OLEDB uses ? ADO.NEt uses @ ...and ParameterNames are different for each type of provider... its nightmare to remember all that). 2) When your
Author:
NayanPatel
Date: 12/21/2009 Section:
Forum
tags :
Execute SQL Task
,
Expression
How to use a Like operator in MDX
Hello BIDN Community, As I am sure that most of you know T-SQL fairly well and know how to use the %Like% operator when writing T-SQL. For those of you that don’t know here’s a sample of how you can write a simple T-SQL query using the Like operator. SELE
Author:
ChrisAlbrektson
Date: 11/24/2010 Section:
Blog
tags :
Like
,
MDX Like Function
,
MDX Like Operator
,
SSRS
,
vbamdx!INSTR
,
MDX
Knight's Microsoft Business Intelligence 24 Hour Trainer Releases!
As an author, nothing professionally beats the excitement you receive when you receive the box of pre-release books from the publisher. It's the cap on many months of late nights writing and editing chapters and in this case creating videos. Then, there's
Author:
BrianKnight
Date: 9/29/2010 Section:
Blog
tags :
sharepoint
,
ssas
,
ssis
,
ssrs
,
book
FILE SYSTEM TASK/RENAME OF LOG FILE
Hi, Thanks for responding...I have tried everything. I have even created a separate package with just the Foreach Loop Container with the File System Task and it works fine. It is only when I integrate it with the main package workflow. I have even tried
Author:
FSANCHEZ98
Date: 1/7/2010 Section:
Forum
tags :
Archive
,
Foreach Loop Container
,
Rename File
,
Variable Expression
Basic Configuration: SourceSafe 2005 and SQL Management Studio 2005
Prerequisites: Let's assume you have installed SQL Server 2005 client tools and the Visual Source Safe client on the same machine. You're all updated, patched and ready to start some query writing. Naturally ( it's natural - right? ) you want to have your
Author:
KeithHyer
Date: 6/2/2011 Section:
Blog
tags :
configuration
,
management studio
,
source control
,
versioning
,
sourcesafe
MDX Functions MDX Examples MDX Queries
Here is list of SSAS MDX Functions which we commonly use in writing MDX queries. You can find details about most of MDX function by clicking it. Time Set Statistical Navigation YTD TOPCOUNT COALESCEEMPTY ANCESTOR QTD BOTTOMCOUNT COUNT ANCESTORS MTD CROSSJ
Author:
sirfnet
Date: 1/13/2011 Section:
Blog
tags :
MDX Tutorial
,
SSAS
,
SSAS MDX
,
SSAS Tutorial
,
MDX
Creating Named Sets In Your Cube
Named sets are simply MDX expressions defined with an alias that return a set of members. If you find yourself writing complex MDX expressions to return a set of members often or if you have a commonly used expression, consider creating a named set. This
Author:
DustinRyan
Date: 11/28/2011 Section:
Blog
tags :
dynamic named set
,
static named set
Adding Existing Reports to Reporting Services Solution
If you’re anything like me, you create a ton of objects and have them in various projects. And sometimes, you may want to include one of those objects in another project. This is often the case when you download an example from the web somewhere, but it d
Author:
briankmcdonald
Date: 12/13/2010 Section:
Blog
tags :
Add Existing Report to solution
,
Brian K McDonald
,
SSRS
,
Reporting Services
FREE WEBINAR - SSRS: How awesome are my reports!!!
That’s right, I said it. Do you want to look like an over achiever? Do you want your reports to stand out above the rest so your boss thinks you spent all night at home adding some personal touches? Join my session to learn how to use some of the cool R2
Author:
SMcDonald
Date: 6/8/2011 Section:
Blog
tags :
Free Webinar
,
Pragmatic Works
,
SSRS
,
Sherri McDonald
Pray For Me...I'm
Writing
The Bible!
Prayer Cat Prays Well not THE Bible, but rather the SQL Server Bible ! I'm incredibly excited and proud to say I'll be one of the primary authors on the 2011 edition (aka "Denali"). Who are the rest of the folks involved on this venture? Check out this gr
Author:
sqlchicken
Date: 5/24/2011 Section:
Blog
tags :
Denali
,
sql11
,
sqldenali
,
books
Querying Oracle from SSIS
I've been working my way through various problems related to querying an Oracle DB from SSIS. In case it helps anyone, here's what I learned. Microsoft Provider or Oracle Provider? When I first started writing packages that queried Oracle, I assumed the O
Author:
JustinJohnson
Date: 8/5/2011 Section:
Blog
tags :
oracle
,
ssis
Learning the art of sorting in Analysis Services
Second Day learning MDX and I have discovered that writing simple properly sorted queries in Analysis Services is a true art For example, in using Adventure Works 2008R2 database, I am trying to bring Sales amount results from all Products Subcategories a
Author:
nube07
Date: 12/29/2011 Section:
Blog
tags :
Analysis Services sortin
,
bdesc
,
desc
,
MDx sortig
MDX Time Calculations Done the Right Way
In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...
Author:
DevinKnight
Date: 8/11/2010 Section:
Article
tags :
MDX
,
SSAS
MDX 101: Introduction to MDX
In this article, Dustin will cover the basics of the Multi Dimensional Expression (MDX) Language and introduce you to writing your first MDX statement.
Author:
DustinRyan
Date: 9/1/2010 Section:
Article
tags :
Introduction to MDX
,
Learn MDX
,
mdx
,
MDX query syntax
Writing
Parametrized MDX for Reporting Services
In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!
Author:
DevinKnight
Date: 9/30/2010 Section:
Article
tags :
MDX
,
SSRS
How to read write variable inside DataFlow ScriptComponent
In this article we will walk through how to read and write variables inside DataFlow Script Component at various processing pahse (Before, After and During Buffer Processing)
Author:
NayanPatel
Date: 6/17/2011 Section:
Article
tags :
dataflow
,
read write variables
,
script-component
,
ssis
Page 1 of 7 (167 items)
<< Prev
1
2
3
4
5
6
7
Next >>
Go to page:
[Go]