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: 21870Comments: 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: 15583Comments: 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: 15468Comments: 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: 10288Comments: 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: 9595Comments: 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: 8659Comments: 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: 7595Comments: 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: 6922Comments: 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: 6771Comments: 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: 6357Comments: 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: 6344Comments: 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: 6228Comments: 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: 5710Comments: 35
Loading Advertisement...

Top MS SQL Server Experts

  1. jogos

    246,566

    Guru

    1,668 points yesterday

    Profile
    Rank: Sage

  2. acperkins

    246,249

    Guru

    1,000 points yesterday

    Profile
    Rank: Genius

  3. lcohan

    194,990

    Guru

    2,000 points yesterday

    Profile
    Rank: Genius

  4. anujnb

    179,525

    Guru

    2,000 points yesterday

    Profile
    Rank: Wizard

  5. ScottPletcher

    154,405

    Guru

    6,500 points yesterday

    Profile
    Rank: Genius

  6. matthewspatrick

    131,392

    Master

    1,620 points yesterday

    Profile
    Rank: Savant

  7. ValentinoV

    126,429

    Master

    1,800 points yesterday

    Profile
    Rank: Genius

  8. EugeneZ

    120,790

    Master

    2,000 points yesterday

    Profile
    Rank: Genius

  9. TempDBA

    112,141

    Master

    1,168 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,585

    Master

    40 points yesterday

    Profile
    Rank: Genius

  13. dtodd

    88,114

    Master

    0 points yesterday

    Profile
    Rank: Genius

  14. huslayer

    81,392

    Master

    0 points yesterday

    Profile
    Rank: Sage

  15. ralmada

    75,583

    Master

    400 points yesterday

    Profile
    Rank: Genius

  16. BCUNNEY

    74,206

    Master

    0 points yesterday

    Profile
    Rank: Guru

  17. dqmq

    66,272

    Master

    0 points yesterday

    Profile
    Rank: Genius

  18. rajeevnandanmishra

    60,246

    Master

    2,000 points yesterday

    Profile
    Rank: Guru

  19. dbaduck

    58,208

    Master

    2,000 points yesterday

    Profile
    Rank: Sage

  20. CodeCruiser

    55,120

    Master

    0 points yesterday

    Profile
    Rank: Genius

  21. Qlemo

    53,598

    Master

    2,000 points yesterday

    Profile
    Rank: Genius

  22. ryanmccauley

    52,252

    Master

    0 points yesterday

    Profile
    Rank: Sage

  23. Cluskitt

    50,880

    Master

    800 points yesterday

    Profile
    Rank: Wizard

  24. sdstuber

    50,836

    Master

    0 points yesterday

    Profile
    Rank: Genius

  25. mark_wills

    49,374

    10 points yesterday

    Profile
    Rank: Genius

Hall Of Fame