Data and digital privacy laws don’t change very often but the online world has evolved a lot since the Data Protection Act of 1998. As such, an overhaul of the EU laws have been long overdue and new regulation is arriving in the form of the General Data Protection Regulation (GDPR).
Managed Service Accounts with SQL Server
Managed Service Accounts (MSA)
In Windows 2008 R2 onwards a new object type was created in Active Directory called msDS-ManagedServiceAccount, which is more commonly referred to as a Managed Service Account (MSA). MSAs allow for a type of Active Directory (AD) account that is automatically managed...
Return of the (DBCC) Clones
SQL Server 2014 SP 2 introduced an interesting feature to provide a data free copy of a production database.
SQL Server is adapting, so must its users
The next generation of SQL Server skills won’t be about making it even faster, more reliable or more secure – as an industry we’ve already cracked that and there’s little left to learn. Instead, they’ll be about executing predictive analytical models and integrating with open source data platforms...
Globally Drop Objects
PowerShell provides an extremely efficient method to globally clean up and drop objects within your SQL Server estate based on some pattern matching in the object names. Some of the reasons you may wish to do this are: -
SQL Server 2016 Upgrade Advisor Automation
The SQL Server 2016 Upgrade Advisor is a great graphical user interface for analysing your existing SQL Server database to discover any features or syntax you are using that are not compatible with a 2016 upgrade.
Browsing into the future of database platforms
Past success is no guarantee of success in the future. Database platforms, like web browsers, might be an established technology but the demands of them are likely to change more in the next two years than in the previous 25.
Stretch Database - SQL Bits XV Q&A
When I was at SQL Bits this week someone was asking me about SQL Server 2016’s new stretch database features. The attendee in question was asking about backing up and restoring the production database for development purposes. In their case the development team like to work with up-to-date..
Databases with their own server level settings
Being a futurist, I like new features and SQL Server 2016 and Azure SQL Database have one that’s really caught my eye!