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 » tips and tricks   (RSS)
Showing page 1 of 3 (21 total posts)
  • Running SSIS packages from C#

    Most of the developers and DBAs know about two ways of deploying packages: You can deploy them to database server and run them using SQL Server Agent job or you can deploy the packages to file system and run them using dtexec.exe utility. Both approaches have their pros and cons. However I would like to show you that there is a third way (sort of) ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on April 9, 2012
  • Server level permissions for developers–why you should read books

    It is quite difficult recently for me to find some time to write a new post, so I don’t seem to be leading the rankings of the most frequent bloggers. I rarely recently have opportunity to lay my hands on the code too, so natural sources of ‘inspiration’ are less often. Hopefully this will change in 2012 and I will have more opportunities to write ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on January 1, 2012
  • OUTPUT clause and windowing functions

    A few days ago I was asked a question how to remove duplicates from a table. As usually in such cases, the duplicate values were related only to several columns, not all of them. So classical approach, to copy distinct data into temp table, truncate the table with duplicates and then copy the data back wouldn’t work. In such cases I find one of ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on July 31, 2011
  • 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
  • Uninstalling Reporting Server 2008 on Windows Server 2008

    Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar to some more unfortunate developers and admins ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on December 22, 2010
  • 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
  • database in use–a little trick to disconnect users

    While I am still waiting for my SQL Server 2008 R2 Dev Edition to come, there’s a little trick you can do if you want to drop users from your database and you don’t have sysadmin rights to kill sessions. You can set database to single user mode with this command: 1 alter database your_database set single_user with rollback immediate This ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on November 22, 2010
  • DEFAULT constraints and sp_bindefault

    When you deal with old databases, with origins somewhere around second half of nineteen nineties, you can expect all kinds of oddities, like funny naming conventions, (lack of) referential integrity, absence of clustered indexes and things like rules and defaults created separately from tables DDL. I just happen to work with such database. I see ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 20, 2010
  • Partitioned views

    I must say I am a big fan of views. They give flexibility of changing the logic of the data retrieval without affecting DAL layers in your application. I posted series of articles about updateable views and triggers on views, their application in SSIS for example. Recently we finished development of system that loads data from several external ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 10, 2010
  • SSMS Tips and Tricks: Scripting Inserts

    Sometimes you need to be able to script the loading of a table. SSIS and the Import/Export Wizard can do this, but there are times when you really need a complete set of insert statements. Red Gate’s SQL Data Compare or SQL Packager can do this, but not everybody has the budget for a commercial tool. SQL Server Management Studio 2008 can script ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 13, 2009
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement