(Pinal Dave) Recently I was trying to help one of my clients to install Service Pack 3 for SQL Server 2008 R2 instance. Nothing was coming up when we were hitting setup.exe.

(Grant Fritchey) The purpose of a database build is simple: prove that what you have in version control can successfully create a working database, and yet many teams struggle with unreliable and untested database build processes that slow down deployments and prevent the delivery of new functionali

(Robert Sheldon) With recent improvements in solid-state drive technology, it’s time to consider SSD devices for SQL Server storage uses. SSDs can address I/O performance problems, but wear is a worry.

(Tim Radney) With the introduction of Azure SQL Database and the addition of more functionality in v12, database administrators are starting to see their organizations more interested in moving databases to this platform.

(Daniel Farina) In my previous tip, First Steps on Performance Troubleshooting, I suggested that when facing a performance problem you should take a look at the transaction log. In this tip I will show you how you can use transaction log related wait types to perform a diagnosis.

(Jack Vamvas) Question: I’m on SSMS and trying to access the SQL Server instance but I’m getting this error:

(Manoj Pandey) In my [previous post] I discussed about the system SPs that we can use to get details of a SQL Job, like its Name, ID, Description, Schedule, etc. But what if you need to check these details of various SQL Jobs?

(Greg Larsen) Have you ever wanted an easier way to provide security at the record level? If so, well now you can easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. In this article I will introduce you to how easy it is to use this new feature as a way

(Pinal Dave) Sometimes I get to see very weird errors by my blog readers and I have no clue about it. Getting a picture about what has happened in the past gives some hint about the solution. This post is a result of once such interaction, where we will see about Exception Code c0000005.

(Vidhya Sagar) It’s been a week I was playing around this new feature. Now I’m going to dropdisable this feature so save some $ in my Azure subscription 🙂