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

Guest Columnist: Rob Farley

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Ownership Chaining

Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment.   Read more...
By Rob Farley 2006/10/03 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,501 reads

A Fix() Function in T-SQL

SQL Server provides a decent ROUND function to help you cut off numbers after the proper number of decimal points. But what if you don't know how many decimals the number will have? Author Rob Farley brings us a UDF he built to do just this.   Read more...
By Rob Farley 2006/07/25 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 14,329 reads

Management Studio with SQL Server 2000

SQL Server 2005 has a new administrative tool called Management Studio, with many enhancements and changes from Enterprise Manager. But it's not just for SQL Server 2005 as new author Rob Farley shows us how to use this tool with SQL Server 2000.   Read more...
By Rob Farley 2006/06/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,880 reads
   Items 1 to 3 of 3