SQL Clone
SQLServerCentral is supported by Redgate
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,587 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,366 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,901 reads
   Items 1 to 3 of 3