Top Articles

Pie Chart Techniques

ValentinoV10/29/2009, 12:00 AM

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips.  This article explained how to optimize a Column Chart.  Today I have returned to show you some Pie Chart implementation techniques. As usual, I will

Topic: MS SQL ReportingTags: SSRS, SQL Server Reporting Services 2008, pie chart, reporting services, charting

Views: 21668Comments: 12

Your First OLAP Report

ValentinoV01/24/2010, 12:00 AM

This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting

Topic: MS SQL ReportingTags: SSRS, SQL Server, Reporting Services, mdx, olap, SSAS, Analysis Services, cube

Views: 15402Comments: 12

Retrieving Data From Excel Using OPENROWSET()

ValentinoV05/04/2010, 12:00 AM

The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a significant amount of time has probably come into contact

Topic: MS SQL ServerTags: import Excel, openrowset, SQL Server, SQL

Views: 15259Comments: 6

Adding an Else to your Switch

ValentinoV01/16/2010, 12:00 AM

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T

Topic: MS SQL ReportingTags: Reporting Services, SSRS, IIF, Switch, if, switch else, sql server

Views: 10196Comments: 7

Dynamic Pivot Procedure for SQL Server

mark_wills05/15/2009, 12:00 AM

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively

Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT

Views: 9543Comments: 16

Chart Optimization Tips

ValentinoV09/26/2009, 12:00 AM

Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services.  These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to

Topic: MS SQL ReportingTags: SQL Server Reporting Services 2008, chart, SSRS, Reporting Services

Views: 8557Comments: 14

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

aelliso307/07/2010, 12:00 AM

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t

Topic: MS SQL ReportingTags: SSRS 2008 SQL Server R2 User Access Control UAC Permission Error

Views: 7503Comments: 6

PIVOT Transformation - SSIS - Complete Tutorial

reza_rad02/15/2010, 12:00 AM

Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft : Mi

Topic: SSISTags: PIVOT, PIVOT Transformation, SSIS, Tutorial

Views: 6844Comments: 9

Delimited String Parsing in SQL Server 2005 and later

BrandonGalderisi11/20/2008, 12:00 AM

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa

Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008

Views: 6744Comments: 8

SARGable functions in SQL Server

rob_farley02/24/2010, 12:00 AM

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou

Topic: SQL Server 2008Tags: SQL Server, Indexing

Views: 6340Comments: 6

Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else.

RiteshShah02/04/2010, 12:00 AM

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008,

Topic: SQL Server 2008Tags: Encryption, decryption, backup database, restore database, certificate, symmetric key

Views: 6319Comments: 13

Connect to your SQL Server

angelIII10/28/2009, 12:00 AM

If you are already familiar with all the terms, you can skip this section.   Anyone else just read on for the quick introduction of the terms that are important to know and distinguish, when troubleshooting SQL server login issues.  First, the pur

Topic: MS SQL ServerTags: MS SQL Server, Database, Instance, Connect

Views: 6191Comments: 20

Speedier Execution of Stored Procedures in SQL Server

Bobaran9807/30/2009, 12:00 AM

I started a new job about six months ago, and with that job I inherited a mission-critical SQL Server 2005 database with over 800 stored procedures and tens of millions of records.  I also inherited what appeared to be a growing problem:  certain of

Topic: MS SQL ServerTags: parameter sniffing, stored procedure, query, sql server, sql server 2005, sql server 2008, sql server 2000, t-sql, optimization, sql

Views: 5701Comments: 35
Loading Advertisement...

Top MS SQL Server Experts

  1. jogos

    239,998

    Guru

    0 points yesterday

    Profile
    Rank: Sage

  2. acperkins

    239,949

    Guru

    4,000 points yesterday

    Profile
    Rank: Genius

  3. lcohan

    186,990

    Guru

    3,500 points yesterday

    Profile
    Rank: Genius

  4. anujnb

    176,525

    Guru

    0 points yesterday

    Profile
    Rank: Wizard

  5. ScottPletcher

    145,505

    Master

    0 points yesterday

    Profile
    Rank: Genius

  6. matthewspatrick

    121,732

    Master

    2,300 points yesterday

    Profile
    Rank: Savant

  7. ValentinoV

    121,329

    Master

    0 points yesterday

    Profile
    Rank: Genius

  8. EugeneZ

    115,990

    Master

    0 points yesterday

    Profile
    Rank: Genius

  9. TempDBA

    108,073

    Master

    664 points yesterday

    Profile
    Rank: Sage

  10. angelIII

    100,133

    Master

    0 points yesterday

    Profile
    Rank: Elite

  11. HainKurt

    93,046

    Master

    0 points yesterday

    Profile
    Rank: Genius

  12. mwvisa1

    88,485

    Master

    10 points yesterday

    Profile
    Rank: Genius

  13. dtodd

    88,114

    Master

    0 points yesterday

    Profile
    Rank: Genius

  14. huslayer

    80,892

    Master

    0 points yesterday

    Profile
    Rank: Sage

  15. BCUNNEY

    72,206

    Master

    600 points yesterday

    Profile
    Rank: Guru

  16. ralmada

    69,983

    Master

    0 points yesterday

    Profile
    Rank: Genius

  17. dqmq

    66,272

    Master

    0 points yesterday

    Profile
    Rank: Genius

  18. rajeevnandanmishra

    57,446

    Master

    1,000 points yesterday

    Profile
    Rank: Master

  19. CodeCruiser

    55,120

    Master

    0 points yesterday

    Profile
    Rank: Genius

  20. dbaduck

    53,688

    Master

    0 points yesterday

    Profile
    Rank: Sage

  21. Qlemo

    51,598

    Master

    1,000 points yesterday

    Profile
    Rank: Genius

  22. Cluskitt

    50,080

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  23. mark_wills

    49,344

    2,100 points yesterday

    Profile
    Rank: Genius

  24. sdstuber

    49,336

    1,000 points yesterday

    Profile
    Rank: Genius

  25. wdosanjos

    45,169

    1,002 points yesterday

    Profile
    Rank: Genius

Hall Of Fame