Blog Archives

SQL Tip: Identifying Column store index potential candidate tables in your databases for major query performance improvements

Column Store indexes appeared in SQL Server 2012 and by 2016 and beyond have progressed much further allowing their usage with fewer restrictions than before and this new storage mechanism for indexes and data provides significant gains for performance especially

Tagged with: ,
Posted in Column Store Indexes, SQL Server, sql server performance, Uncategorized

How to get GDPR compliant with Microsoft

When the EU’s GDPR (General Data Protection Regulation) is introduced next year, the bar for data privacy protection in the UK will be raised. For thousands of businesses GDPR highlights daunting issues of compliance. Organisations that fail to comply with

Tagged with: , ,
Posted in gdpr, security, SQL Server, SQL Server Administration, Uncategorized

SQL Tip: Memory limit too low. Instance failing to start

Quick note. SQL startup parameters set mistakenly by someone to be too low and instance is failing to start. Page/memory allocation errors in startup log of various types… Add startup parameter ‘-f’ and start the instance and change the memory

Tagged with: , ,
Posted in SQL Server, SQL Server Administration, SQL Tips, Uncategorized

SQL Server 2016 – Always Encrypted and the GDPR

Originally posted on Matthew McGiffen DBA:
The European General Data Protection Regulation (GDPR) is coming, bringing new rules about the protection of Personally Identifiable Information (PII). For those of us in Europe – or wishing to sell software products and…

Posted in Uncategorized

SQL Central Management Server – Definition, Benefits and setup

Central management servers store a list of instances of SQL Server that is organized into one or more central management server groups. Actions that are taken by using a central management server group act on all servers in the server group. This includes connecting to servers by using Object Explorer and executing Transact-SQL statements and Policy-Based Management policies on multiple servers at the same time

Tagged with: ,
Posted in SQL Server, SQL Server Administration, Uncategorized

Database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported.

This is the error message or similar to it when you try to attach a database from a more advanced version of SQL Server to an old one. To resolved 1. Try to locate a SQL Server Version most advanced

Posted in Uncategorized

PAGE_VERIFY Database Option

Short story… PAGE_VERIFY Database Option should be set to “CHECKSUM” . This will reduce your chances of data corruption significantly and has (almost) no performance impact. That almost means a little CPU overhead but yes you should not jeopardize the

Posted in Uncategorized

Largest FREE Microsoft eBook Giveaway!

Microsoft Director of Sales Excellence – Eric Ligman Eric Ligman, Microsoft Director of Sales Excellence Blog https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/

Posted in Uncategorized

How to configure SQL Database mail (or any other application) to send emails using Office 365 (Exchange Online): A walk through and options

  Hi, What I have come to understand is that with Office365 email routing the configuration settings for email relay are, Server:                                 smtp.office365.com Port Number:    587 Authentication:                Basic (An email address and password) We can set this up

Tagged with: ,
Posted in email, SQL Server, Uncategorized

SQL Tip: Read + Write (or any) role on databases, all existing and new ones

Trying to avoid the double hop issue which configuring linked servers, I opted for local users. After setting them up I asked the developer who requested this as to which databases he wanted to be read across the servers /

Tagged with:
Posted in SQL Server, tsql, Uncategorized