Jul 28, 2020 | SQL Server 2012 |
There appears to be a bug in some versions of SSMS (SQL Server Management Studio) when it comes to generating scripts. You work hard as a DBA or data professional. It might be you are working on in house developed applications and databases. The software and databases...
Jul 6, 2020 | SQL Server 2012, SSRS |
Do you administer SQL Server Reporting Services? Have you configured SSL/TLS but SSRS Report Manager not using HTTPS? You might be a DBA or System administrator or even a developer who needs to manage and look after an instance of SSRS? Do you need to configure SSRS...
May 4, 2016 | SQL Server, SQL Server 2012, SQL Server 2014, SQL Server 2016, SSMS |
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this… “Can you get the text in management studio to word-wrap?” Word-wrap is not on by default. You can see from the image ...
Apr 11, 2016 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server Blog, SQL Server Consulting |
SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the premises of Microsoft partner is South Wales back in the day. It feels like the end of an era. If you still have SQL Server 2005 instances and databases you should...
Apr 6, 2016 | SQL Server 2012, SQL Server 2014, SQL Server 2016, TSQL |
I have been working nn an environment that had multiple copies of a database on the same SQL server instance. In this case the SQL Server was acting as both a UAT and Training environment.The application was supported by two databases. Each database had...
Dec 7, 2015 | SQL Server 2012, SQL Server 2014, TSQL |
New Year, new powerful SQL queries! Start the New Year off with some great Transact-SQL training and join me for Learning Tree’s Powerful SQL Queries for SQL Server one day online training course running on the 14th January. You will learn: •...
