Yes you can, as I did this last week. Obviously SQL Server 2008 is coming out of extended support on 9th July 2019. See here. Simply ensure you have enabled .NET 3.5 SP1 before installing SQL Sever 2008 though and it installs like a charm. Oh, don't forget to change your firewall settings to allow...
Now could be the time to think about Performance Tuning your SQL Server. Sequallity has 18 years experience of doing just that. We will monitor your current performance and recommend a course of action to improve the productivity of your SQL Server. We can then help you implement the suggested changes or train you to...
Sequallity Ltd are pleased to announce our brand new training website. On the site we outline all the training courses we offer in SQL Server and Power BI. Our mission is to ensure that you and your staff have the appropriate skills to manage your SQL Server. Keeping it finely tuned and maximising productivity. As...
Our SQL Server Health Check has taken years of experience to develop. We have created a thorough and concise structure for reviewing and health checking SQL Server databases. Many of our customers use this service monthly to help keep an eye on things, whilst others get in touch when they suspect operational issues. Our health...
Learn how to write effective SQL statements from the ground up in this TSQL Training Course. Understand the set paradigm, right from the start. No experience is necessary to go to a good level with good explanations and lots of examples. This course can be 1 day to 3 days depending on your level of...
Microsoft have upped their game, Power BI, R, Azure Machine Learning and integrating all of these together. Here’s a free book from Microsoft about Data Science with Microsoft SQL Server 2016. You might need a Microsoft account but then why wouldn’t you? Download it here!
SQL Server 2016 is out next year. This will be the fourth version in 6 years; R2 was released in 2010. Anyways you can get the new Community Technology Preview of Microsoft SQL Server 2016 here. Be warned though that you must have an Microsoft login, and I know not everyone does. https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
Way back 10 years ago, I started out as a freelance SQL Server consultant. In those days I fixed PCs as well as did the SQL part to maximise my income. The PC side was doing really well and to be honest I could have taken that a lot further and made some good money...
In the UK we are very lucky, there are lots of free SQL Training happening all the time. They realise their form in the shape of conferences. There are two excellent free conferences in the UK, namely SQL Bits and SQL Relay. SQL Bits is excellent, many excellent SQL Server professionals have freely donated their...
OK, so we know that for larger tables, SQL Server only automatically updates statistics (from AUTO_UPDATE_STATISTICS) when they go above the 20% range come rain or shine, don’t they? Well, yes they do, but from SQL Server 2008 R2 Service Pack 1 and later you can have a much more aggressive way of automatically updating...
