(Tim Smith) PowerShell has many uses for SQL Server DBAs and Developers. There have been several tips written about different aspects and how PowerShell can be used with SQL Server. In this video tip, Tim Smith looks at six useful PowerShell scripts that can be used to simplify day to day tasks.

(Pinal Dave) Recently I got an email from one of the student who attended my SQL Server 2014 Pluralsight Course from last year, he was trying to use Buffer Pool Extension feature and got into some unique trouble. Here is the email from him:

(Chris Shaw) This article is part 5 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive.

(Tim Radney) Being responsible for the performance of SQL Server can be a daunting task. There are many areas that we to have to monitor and understand. We are also expected to be able to stay on top of all those metrics and know what is happening on our servers at all times.

(Jason Crease) Application developers wouldn’t think about writing code or working on a team that wasn’t using source control. And, if they’re working on a team and doing agile development, then they’re probably doing continuous integration as well. These good practices are part of the overall Appli

(Daniel Calbimonte) Tabular Mode for Analysis Services was introduced in SQL Server 2012 and PowerShell for Analysis Services is also supported in SQL 2012 and later versions. In this tip, we will look at how to automate some tasks for Tabular Databases using PowerShell.

(Derik Hammer) When creating a SQL Agent Job to execute a PowerShell script, you have to decide which way that you want the PowerShell to run. Depending upon which version of SQL Server that you are using and which job step type that you choose, you might be running in different versions of PowerShe

(Ed Elliott) In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing and why we need to do it.

(Pinal Dave) This seems to be the third week that I am writing about ReadOnly databases, this blog is in continuation of last weeks notes. When I wrote the notes from last week, one of my blog reader said if it is possible to get the ReadOnly error without making the database into a ReadOnly databas

(Chris) Last week I was at a client site showing them how to set up the Integration Services Catalog. We were walking through the steps in how to create it and we input the password into the Create Catalog configuration screen.