-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2017

SQL Server 2008 RTM - Maintenance Plans need Integration Services installed

The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not go into here I have been building some SQL Server 2008 instances. This is because of a large SQL Server migration project that I’m working on for a client. The…

Read more

2 comments, 483 reads

Posted in The SQL DBA in the UK on 31 January 2017

Enabling Remote Access to the Dedicated Admin Connection

Recently I was running a health check on one of my clients SQL Servers and I noticed that access to the dedicated admin account was disabled. They would not be able to connect to the Dedicated Admin Account (DAC) remotely.  It is generally good practice to enable remote admin connections.…

Read more

0 comments, 562 reads

Posted in The SQL DBA in the UK on 30 January 2017

SQL Server Community Events

By David Postlethwaite

I have just come back from a successful SQL Saturday in Vienna, Austria where I had 60 people listening to my presentation on SQL 2016 new features.
It was interesting how many people still wanted to know about SQL Server 2016 even though it’s been out for…

Read more

0 comments, 377 reads

Posted in The SQL DBA in the UK on 26 January 2017

How to Count the Total Number of Rows Across Multiple Tables

I have been working on SQL Server Consulting assignment,  a SQL Server 2014 migration for a new client over the past few weeks. When I’m undertaking such tasks I’m often asked additional questions that make my  day a little interesting. 

I got a question last week How to Count the…

Read more

9 comments, 3,546 reads

Posted in The SQL DBA in the UK on 22 January 2017

SQL Server 2016 SP 1

By David Postlethwaite

SQL Server 2016 SP1 was released in November 2016 only five months after the initial release.

There have been some significant changes and additions in this release. The most significant of which is that many features that once only existed in Enterprise edition, such as Always Encrypted,…

Read more

0 comments, 2,362 reads

Posted in The SQL DBA in the UK on 9 January 2017

gethynellis.com 2016 Review

The year gone was an interesting year for gethynellis.com and GRE Solutions. Any year that has a new release of SQL Server is always an interesting time, as learning and writing about new SQL Server features is always a fun thing to do. David has a great talk that he…

Read more

0 comments, 445 reads

Posted in The SQL DBA in the UK on 5 January 2017