22Jun

Have you backed up your SQL Logins today?

0 Comments
Automation, Backup, dbatools, Logins, PowerShell, SQLServer, syndicated

Why am I asking? Have you never have been in a situation where: the master backup is corrupted you need to rollback a password change know the list of permissions on a specific day (the scenario: “yesterday was OK, today is not working” due permission changes) Do you see the pain?! If you are not […]

06Mar

Scaling from Basic Availability Groups to Advanced AG

0 Comments
availability groups, basig availability groups, high availability, sql server, standard edition, upgrade

A good news came along with SQL Server 2016: finally we have the famous AlwaysOn Availability Groups (AG) working on Standard edition! But life is not a bed of roses… and obviously AG in a lower edition then Enterprise would bring some drawbacks. Now the AlwaysOn Availability Groups feature is split into two different “categories”: Basic […]

15Feb

Creating an Azure SQL Database – 101

0 Comments
101, cloud, sql database, sql server

The cloud is more and more part of our lives and as a data professional, we have the need to follow this new wave. It doesn’t matter if you are a SQL Server developer or a database administrator, the cloud is the way to go…as projects on this area are popping up from everywhere. There are […]

14Feb

It is possible to run scripts inside SSMS on multiple instances without using CMS? Yes, it is!

3 Comments
SQLCMD, SQLSever, syndicated

Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option. What is SQLCMD mode in SSMS? First let me say that sqlcmd has a command line utility called sqlcmd.exe which allows to connect and run scripts from the command line. This utility exists from SQL […]

19Jan

Find and fix SQL Server databases with empty owner property using dbatools PowerShell module

0 Comments
PowerShell, SQLServer, SSMS, syndicated

A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”. The following image shows the error message. I have seen this message before so I know that the problem is that the database does not have a defined owner. We can confirm this by running […]

Page 2 of 212