Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Shawn Melton

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,777 reads

How to use the IsNothing Inspection Function in SSRS

SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.  Read more...
By Shawn Melton 2015/02/12 | Source: SQLServerCentral.com | Category: report development
Rating: |  Discuss |   Briefcase | 4,525 reads

SSRS - Report for Stored Procedure with Multiple Values Passed

You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.  Read more...
By Shawn Melton 2014/12/09 | Source: SQLServerCentral.com | Category: report development
Rating: |  Discuss |   Briefcase | 5,802 reads

SSRS - Report for Stored Procedure with Parameters

You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.  Read more...
By Shawn Melton 2014/11/04 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,976 reads

Server Role Membership Validation

Need to know how to verify if a login has server-level access to your SQL Server instance?  Read more...
By Shawn Melton 2014/06/17 | Source: SQLServerCentral.com | Category: server roles
Rating: |  Discuss |   Briefcase | 2,313 reads

PowerShell Basics

Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.  Read more...
By Shawn Melton 2013/02/22 (first published: 2011/01/24) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 23,965 reads
   Items 1 to 6 of 6