In the previous newsletter article, we covered some important uses for email and email etiquette (don’t miss another professional newsletter tip—signup for the free newsletter here). A follow-up client question (regarding the previous newsletter article) was “Do you think Chat and IM is an appropr

(Marcin Policht) In our articles published recently on this forum, we have been discussing the use of dtexec.exe command line utility in executing SSIS projects and packages. Its superior role in this area results primarily from its flexibility, which not only allows you to control execution behavio

(Shaun J Stuart) I’ve finally had a chance to play around with SQL Server 2012 and one of the nice things I’ve discovered is that it features a warning when a transaction log file has an excessive number of virtual log files.

(Michael K. Campbell) I recently ‘inherited’ a couple of SQL Servers for a client – running SQL Server 2008 (Enterprise Edition). In the process of ‘taking over’ these boxes I’ve scrutinized a number of jobs and details – including backups. One thing that I found, interestingly enough, is that while

(Ben Snaidero) I am trying to use the ON DELETE CASCADE option when creating a foreign key on my database, but I get the following error:

(James Serra) In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member attributes” box on the “Edit Entity” screen is too small. It only fits four rows. This can be very annoying as you will need to use the scroll bars on just ab

(Pinal Dave) Here is the email which made me write this blog post. When I write a blog post I write keeping in mind that if the developer is not familiar with the concept he will attempt this on the development server.

(satnam singh) Recently we had an issue in our Production environment, on the Reporting Database Server the Transactional Replication procedure was being blocked due to execution of some heavy T-SQL queries and as a result business users were unable to view the latest data.

(Nelson John) It is common scenario that, we might need to extract the data from the SQL server based on some pattern. For example extract all customers information who has a valid PAN card number (XXXXX0000X). SQL server is not very powerful in pattern matching.We can easily implement simple patter

(Tibor Nagy) In the previous tip we learned that outdated statistics can cause SQL Server performance problems. My question is: How can I find out which statistics are outdated in my SQL Server database?