if datepart(dw, getdate()) in (6, 7)
    use pubs;

Browse by Tags

• .NET
• BNF
• C#
• database design
• good practices
• performance
• RTFM365
• security
• SOA
• SQL Server 2008
• SSIS
• SSRS
• tips and tricks
• T-SQL

• 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 Read More... Posted Monday, April 09, 2012 10:52 PM by Piotr Rodak | 4 Comments Filed under: tips and tricks, SQL Server 2008 R2, good practices, SOA, SSIS, C#, .NET Attachment(s): ServiceETLDemo.zip

• 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’ Read More... Posted Monday, January 02, 2012 4:05 AM by Piotr Rodak | 1 Comments Filed under: T-SQL, tips and tricks, SQL Server 2008 R2, SQL Server 2008, good practices, security

• 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 Read More... Posted Sunday, July 31, 2011 10:55 PM by Piotr Rodak | 8 Comments Filed under: T-SQL, performance, tips and tricks, SQL Server 2008 R2 Attachment(s): OUTPUT-testing_duplicates.zip

• 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 Read More... Posted Sunday, April 10, 2011 11:23 AM by Piotr Rodak | 1 Comments Filed under: T-SQL, database design, tips and tricks, SQL Server 2008 R2, good practices

• 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 Read More... Posted Tuesday, December 07, 2010 10:40 PM by Piotr Rodak | 0 Comments Filed under: T-SQL, database design, tips and tricks, SQL Server 2008 R2, RTFM365, BNF

• 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 Read More... Posted Sunday, November 28, 2010 3:30 PM by Piotr Rodak | 0 Comments Filed under: T-SQL, database design, SQL Server 2008 R2, SSRS