-
SQL Server Backups to Azure Part 2: Setting up the Storage Account
This is the second part of a 4 part blog post series about backing up SQL Server to Azure. If you wonder why you’d like to back up data to Azure in the first place, please read the Part 1 of this series that explains some benefits of using Azure for backups. In this post,…
Posted by
-
SQL Server Backups to Azure, Part 1: Introduction
I’ve said it before, and I say it again: Understanding how database backups and restores work is one of the more important topics for DBAs to understand. This time we’ll approach the topic from the cloud, and more precisely, from the Azure perspective. Why cloud perspective, you might as? For one simple reason. Even if…
Posted by
-
Moving data (back and forth) with backups
Backups, backups, and backups. That’s pretty much my answer to what should be the top 3 priority topics that any DBA needs to understand well. And that’s what we’re going to be looking at this post, backups! Backups play a vital and important role in keeping your data (and in some cases your career) safe,…
Posted by
-
Fun with Filegroups
Filegroups are an interesting and useful (if not actually all that fun, despite the title) concept within SQL Server. They provide not just a way to group objects like tables together, but also provide a mechanism to help us to speed up the backup, restore, and recovery of the databases. And occasionally, they can even…
Posted by
-
Hiding (mostly) in plain sight: Dynamic Data Masking
One of the more recent additions to SQL Server security features is the Dynamic Data Masking (DDM), included with the 2016 version. Like the Transparent Data Encryption I blogged about recently, DDM is a feature that is relatively easy to implement, and doesn’t require a lot of changes to the application. And just like pretty…
Posted by
-
Protecting Data at Rest: Transparent Data Encryption
I recently read an article which stating that since the GDPR came in force, there has been 59,000 data breaches reported in the EU. I must admit, that while I did anticipate that we’d see a surge in these numbers, due to reporting requirements in the legislation. I really did not expect the numbers to…
Posted by
-
Looking back to 2018
Note: This post is not a technical one, but one focusing on a professional (and maybe personal) growth. As we’re already well on our way to 2019, I figured that now is as good time as any to look back, all the way to the year 2018! As I mentioned in passing in a previous…
Posted by
SQLStarters
Recipes for Cloud Database Experts
Categories
- AWS (11)
- Azure (34)
- Blockchain (1)
- Career advice (5)
- Containers (1)
- Databases (40)
- DevOps (4)
- DMV (4)
- Failover Clustering (5)
- Ignite (1)
- Microsoft (13)
- PASS Summit 2013 (5)
- PASS Summit 2014 (2)
- PASS Summit 2015 (5)
- PASS Summit 2016 (1)
- PASS Summit 2017 (1)
- PerfMon (6)
- Performance Monitor (6)
- Performance troubleshooting (8)
- Security (15)
- SQL Server (74)
- SQL Server Administration (76)
- SQL Server DBA (70)
- SQL Server Service Packs (2)
- TCP Chimney Offload (1)
- Tools and Utilities (15)
- Uncategorized (12)
- Windows Administration (11)
- Windows Networking Features (7)
- Windows Server Management (16)
Find me in social media
Search by tag
#automation #azure #azurevm #db2 #opensourcedb #oracle #sqlserver AWS Azure Azure Cloud VM Backups Cluster Validation Database Design Dynamic Management Views IaaS IPSEC Managed Instances Monitoring NETSH PerfMon Powershell Query Tuning SQL Database SQL Database SQL PASS sqlserver SQL Server SSL T-SQL Testing