THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Design » SQL Server 2008... » T-SQL   (RSS)
  • Security – how to assign rights to database objects

    A few days ago my team mate asked me to check out why one of the logins doesn’t have right to execute to a few stored procedures. Allegedly it had the right before. After a few minutes of digging in the source control it turned out that these procedures were scripted with explicit EXECUTE rights to them. However, some later updates to the code did ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on April 10, 2011
  • BNF – how to read syntax?

    A few days ago I read post of Jen McCown (blog) about her idea of blogging about random articles from Books Online. I think this is a great idea, even if Jen says that it’s not exciting or sexy. I noticed that many of the questions that appear on forums and other media arise from pure fact that people asking questions didn’t bother to read and ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on December 7, 2010
  • Setting reporting database–what happens behind the scenes

    When you install reporting server, you have in general two options available – either you install the reporting server and configure its database at the same time, or install just reporting service and point it to an existing database later. We had recently opportunity to configure server to point to existing reporting database. We encountered a ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on November 28, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement