(Pinal Dave) In this blog, I’ll show how to use ApexSQL Log, a SQL Server transaction log viewer. You can download it for free, install, and play along.

(Michael Simons) In Visual Studio 2013 Update 2 (as well as Office Developer Tools for Visual Studio 2013 – March 2014 Update) some enhancements are available in the area of attaching to SQL Views. These enhancements were made based on the feedback we received from the community.

(Greg Larsen) I’m going to deviate from my normal how-to topic related to SQL Server, and focus more on a touchy feely topic. In this article and my next article I’ll be exploring the traits of a DBA. Over the years I’ve been asked a number of times what does it take to become a DBA, or what kinds

(Kalen Delaney) This is just a quick post to describe a test I just ran to satisfy my own curiosity.

(Chris Webb) In last week’s post I showed how to create a simple LIKE function in Power Query which could be used in a calculated column. This week I’m going to show you how you can use this function in a condition when joining two tables together.

(Kenneth Fisher) One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). I was rather curious so I spent some time getting it all down on paper.

(Saurabh Dhoble) It is important to set up SQL Server Agent Security on the principles of ‘executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that

(Pinal Dave) Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the performance and scalability of SQL Server databases a

(Steve Endow) I’m working with a Dynamics GP customer that is experiencing some SQL Server connection issues and errors. They started to notice the issue with a third party GP product that was logging SQL connection failures.

(Michael J. Swart) SQL Server 2014 will make use of its newly re-written Cardinality Estimator when the database’s compatibility mode is at least 120. But there’s more to the story.