Reduce AWS Costs for SQL Server Storage, Compute and Database as a Service
In this tip we look at some things to consider to help you reduce your costs of running your database platform on AWS.
John Grover is a 25-year IT veteran with experience in industries from (physical) warehousing, and health care to his current position in higher education. His experience with databases started with Oracle but he has crossed over from the “Dark Side” and is now a SQL Server MCITP. John is currently the database team lead for a hybrid SQL Server and Oracle environment at the University of Notre Dame. His experience with SQL Server includes clustering, mirroring and running in a virtual environment.
Using ssh to connect to Linux for the SQL Server DBA
Learn how to connect to SQL Server on Linux using a secure connection.
7 Things Every SQL Server DBA Should Know About Linux
In this tip we will help you make the transition to SQL Server on Linux and show you things you need to know about Linux.
Top 10 Linux Commands for SQL Server DBAs
In this tip learn about some important Linux commands to help you administer SQL Server on Linux.
How To Resize an AWS Volume Using The AWS Console or PowerShell
Read this tip to learn how to expand AWS Elastic Block Storage (EBS) volumes to support your SQL Server databases at Amazon.
Backing up your SQL Server to Amazon’s Cloud in Three Easy Steps
My organization is beginning to invest in Infrastructure as a Service (IaaS), one of the things we are interested in doing is migrating backups to the cloud. In this tip we cover the steps to backup databases to the cloud.
Restoring the SQL Server Master Database Even Without a Backup
While researching this article I was surprised by the number of DBAs who back up their user databases, but not their system databases. They either do not fully understand the importance of these databases or have been lulled into complacency by years of s
How to recover a suspect msdb database in SQL Server
When I restarted one of my (thankfully) test instances today I got a message that msdb was in suspect state and needed to be recovered or repaired. What I thought would be a simple exercise in database recovery taught me a few things about the system da
SQL Server Database Connectivity Testing Using PowerShell
You've just commissioned a new SQL Server. A user or developer insists the database is down, they can't connect and they are getting any one of several error messages. You know the SQL Server instance and SQL browser service are running, but rather than j
SQL Server Alerts with Text Messaging from SQL Server Database Mail
I need to get alerts from my SQL Server databases 24/7, but I don't always carry my laptop to check email and when I do, I may not be near an internet connection. I always have my cell phone with me, though. Can I get my SQL Servers to send me a text mess
Creating custom T-SQL conditions and policies for SQL Server Policy Based Management
In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Manageme