Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 R2 evaluation to the free Express version, I ...

To wrap up this series of PowerShell articles, let's take a look at a few tips and tricks for working with PowerShell in SQL Server on a regular basis. To wrap up this series of PowerShell articles, ...

Use PowerShell to script objects on a schedule or in a special order. Use PowerShell if you need to switch between windows and SQL commands or even share data between the two. It’s much easier in ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Before you can change an ACL, you must get the current one. There are two ways to do this with PowerShell. Learn how to get the current ACL and modify it.

Most of us have dealt with hardware that stays in service well past its planned end-of-life date or that, for reasons of budget and bureaucracy, doesn’t even make it into service until well into its ...

Ever wondered what it would be like to run Microsoft SQL Server on Linux? A few years back, one would say that's nothing but a pipe dream. However, Microsoft has since been slowly accepting that open ...

I have PS v3.0 installed on my W7 SP1 but when I'm trying to open an interactive session to Server 2012 - enter-pssession - I'm being told my version is not supported by the server...? PowerShell ...