(Balance) I have come across an interesting feature when trying to set up index rebuild processes on SQL Server 2008R2. I am constructing an alter index rebuild statement including appropriate IGNORE_DUP_KEY and other settings and am receiving failures because of IGNORE_DUP_KEY.

(Pinal Dave) If you watch any SQL Server Developer, you will notice one particular task them doing every day frequently. It is they select the row from the table to see what are the various kinds of data it contains.

(Marcin Policht) In our most recent article published on this forum, we have presented some of the fundamental principles of Windows PowerShell, applicable in the context of managing SQL Server 2012, including description of two modules (SQLPS and SQLASCMDLETS) that implement a wide range of Databas

(Kun Lee) As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn’t contain the full log detail and t

(Ayman El-Ghazali) One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some old data from a table that stored webpage session information.

(Devi Prasad Gakkula) A deadlock is a situation in which two or more competing actions are each waiting for the other to finish, and thus neither ever does.

(Steve Stedman) Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were easy to get the job done, and the tools that I hated using were the tools that were the most difficult to use. Being good at what I

(Melissa Coates) Welcome to Part 1 of a 3-part series on using the new Entity-Based Staging Process in Master Data Services (MDS) 2012.

(Jeremy Kadlec) When writing SQL Server queries I either need to reference an existing data model or visualize the SQL Sever tables from my database in my head in order to complete my query.

(Jason Thomas) Sometime in January, visualization expert Stephen Few expanded on Tufte’s idea of Sparklines and came up with this new visualization called Bandlines. Bandlines use horizontal bands of color in the background of the plot area to display information about the distribution of values and