-
School of Hard Knocks: SQL Server, Storage Spaces Direct and Cluster Shared Volumes edition
While I work 100% with cloud based SQL Server deployments these days, my life is not all unicorns and PaaS services. Surprisingly (or not) enough, many of the environments in the cloud are still build on top of good, trusty virtual machines. Except that sometimes they’re not good or trusty. There are definitely some good…
Posted by
-
Sometimes the VM in Azure is the best option for your SQL Server workloads
I have previously written quite a few post about how much I like the Platform-as-a-Service databases for SQL Server (and for databases in general), and I do like them quite a bit. But would I recommend them for all use cases and workloads? Heck no! At the moment there are some features and limitations in…
Posted by
-
Do you know how many different types of users there are in SQL Server?
The answer to this question is not 2, happy and unhappy users. This time we’re discussing security, not the end user experience of your perfectly tuned databases. I was recently having a discussion around SQL Server security, more specifically about the logins and user. The question I was asked after going through couple examples was,…
Posted by
-
How to give everyone in Azure access to your database, the easy way
Sometimes I run into things in cloud that really just blow my mind away. Not that long ago I learned how you can give everyone in Azure, no matter what subscription or region they are in, an access to your database. And it was super easy too. It’s just one click to allow whole (Azure)…
Posted by
-
Low Impact Maintenance for Multi-Terabyte Data Estates
Core responsibility of a DBA is to make sure that the databases they are responsible for are maintained properly. In a nutshell this usually means that you are taking backups of the data, checking the consistency of the databases and maintaining statistics and indexes. Performing these tasks gives the DBA the ability to provide the…
Posted by
-
SQL Server 2019 security improvements: Feature Restrictions
Very recently I was working on a customer databases, when I more or less stumbled on a something I had not noticed before. Apparently at some point the latest version of SQL Server (I was working with Azure SQL DB) had a new security enhancement added into it called Feature Restrictions. As this was something…
Posted by
-
Platform-as-a-Service databases and the future of the DBA role
I just realized that it has been awhile since my last post, so I figured it’s time to do one before the end of the year. Last few months have been rather hectic with me migrating new workloads to Cloud as well as taking the time to visit PASS Summit 2019 to learn more about…
Posted by