SQL server BIGINT

It has been a while since I wrote a blog post for TSQL Tuesday and there is no better time then now following on from Brent Ozar’s Invite about our favourite data types in SQL server.

Continue reading

Azure SQL Database – Contained user Model

I always follow a contained user model when setting up users within my Azure SQL Database. I do this so the user in question has access to only specific database(s) and does not have a login to the server. It becomes even more apparent the importance of this when you design a solution based on failover groups.

When a failover occurs to the secondary, I want a pleasant experience for the user. With the contained user model, the user goes with the database. I don’t want to do admin work on the new primary (post failover). Let’s see.

Continue reading

Azure SQL Database and Long-Term Backups

There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server.

As you can see, by default we have 7 days retention to allow for PITR – Point In Time Recovery, anything longer you will need to setup long term retention.

Continue reading

SQL Server Linux

If you have come from a windows background you may be curious about the world of SQL Server Linux. Yes, the operating system and the implementation of it differs to the traditional Windows environment but once installed, it’s just good old SQL server and those lovely DBCC commands and backup statements work, all your DMVs are ready for you too.

Continue reading