As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic. Hopefully, this will [...]
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s. A video of the session is available at the Pragmatic Works website. As a part of that session, I received a couple dozen questions about security that we didn’t have a chance to go over during [...]
It’s the start of the month of May, or at least the first Monday in May. Hopefully you aren’t nursing too much pain from a weekend that included two fairly dissimilar holidays. First, there was Star Wars Day on Saturday. Followed by Cinco de Mayo on Sunday. There should have been something in there for [...]
In last week’s post, I talked about the steps required to backup a Azure SQL Database. That post leaves us asking what’s the use of having a backup of a database, if you aren’t going to restore it somewhere. And more importantly, if you can’t restore a database, or don’t know how, then the backup [...]
When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database. In fact, I wasn’t even sure if this concept was appropriate when it came to databases hosted in “the cloud”. What I found was that the concept of backing up databases in the Azure cloud [...]
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare. Among all of those new features, is the occasional little bell which offers us a chance to change how we investigate SQL [...]
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able to test not just a single volume’s capability to deliver data from storage, but to test the storage as a whole. Doing so is important since, what ever application, in my case SQL Server, is running [...]
After working on this monthly checklist for over a year, I’ve recently discovered that there isn’t anything that we should be doing with our SQL Server databases. Apparently, the platform is completely and absolutely self-maintaining and provides built-in disaster recovery without any effort on your part. Along with all of these features, you won’t be [...]
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them a run-through before your managers asks you to make recommendations on whether to upgrade and what the value in doing so will be. For those of us that don’t have the time to build out [...]
This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. The topic that was chosen for this month was PowerShell. And more specifically: “Blog about using PowerShell for doing, [...]
_1262.png)
