Posted by yrushka on May 13, 2011
Few days ago, inside a Software project, I had to enable and configure MSDTC (Distributed Transaction Coordinator) between 2 machines: a Web Server using NServiceBus to process messages in a transaction and a SQL Server.
I encountered some issues and I would like to detail the order of few configuration steps as well as testing methods that should be done/checked before MSDTC in fully functional.
Step 1… Continue reading
Posted by yrushka on May 6, 2011
xp_cmdshell is a very powerful built-in extended stored procedure that can be used to execute from within SQL Server – any external operating-system command. xp_cmdshell combined with sqlcmd utility allows administrators or developers to execute SQL scripts to Remote SQL Servers.
This xp_cmdshell configuration option is disabled by default in SQL 2005 and following SQL editions because some malicious users can perform abusive operations using this option. Access to xp_cmdshell should… Continue reading
Posted by yrushka on April 11, 2011
Did you know that starting with SQL 2005 all future versions of SQL allow tracing of all DDL or DCL modifications done on all DB objects?
I was inspired by Jonathan Kehayias blog to dig deeper and check other useful output from the default trace.
Let me remind you what are Data Definition Language (DDL) and Data Control language (DCL) statements:
DDL statements: are used to define… Continue reading