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
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
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
I am from Bucharest, Romania and I am working with SQL Servers since 2006. I have been working closely with all SQL versions starting with SQL Server 2000. I am the DBA lead at BullGuard and spend my free time traveling, reading other tehnical blogs and preparing for some MS certifications.
See more about me and why I started this blog.
