Microsoft Dynamics CRM – Filtered Views and SQL Server 2014

Microsoft Dynamics CRM makes extensive use of filtered views – these are standard views in the database, but they prevent unauthorised users (including DBAs) from seeing sensitive data by the way they are coded. During several migrations of Microsoft Dynamics CRM from both the 2011 and 2013 versions to 2015, my project teams have hit performance issues […]

Another reason to sign-up for Visual Studio Dev Essentials

The March update for Visual Studio Dev Essentials has announced that SQL Server 2014 Developer Edition is now free for Dev Essentials members! It was always great value for non-production development and testing, but now – it really shows how Microsoft SQL Server is really gunning for Oracle’s database customers. Exciting news! Starting today, SQL […]

Kalen Delaney is coming back to SQLBits

Kalen Delaney is coming back to SQLBits XV in May in Liverpool – Kalen’s session will be on the thursday, and is called SQL Server Query Plans – Reuse or Recompile. In Kalen’s words, it will cover the plan cache, how and when SQL Server decides whether to reuse or recompile a plan, and how to […]

SQL Server Licensing

SQL Server licensing isn’t straightforward, and it certainly isn’t as easy as it used to be.  In days gone by, we’d buy a licence for each physical socket no matter how many cores there were, and we’d get High Availability (HA) and Disaster Recovery (DR) generally for free. The release of SQL Server 2012 heralded […]

What Port Is My SQL Server Listening On?

Like most application software, SQL Server listens on a specific port for client connections. What is the default port for SQL Server? The default port is 1433. It is strongly recommended not to run SQL Server on the default port, as it is well-known. The general guidance is to choose a port number that is much […]