SQL – Brian Williams

SQL

SQL Server Reporting Services (SSRS) – User domain\user does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

June 4, 2014

admin 1 min read

Error after a fresh installation of SSRS: User domain\user does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account […]

SQL

Install Team Explorer / TFS for SQL Server Data Tools for SQL 2012

July 12, 2013July 12, 2013

admin 1 min read

Team Explorer is not included by default in SSDT. Install the Visual Studio Team Explorer 2010 – ISO – http://www.microsoft.com/en-us/download/details.aspx?id=329 Make sure the Team Explorer […]

SQL

SQL Data Log file shrink

February 14, 2013September 29, 2015

admin 1 min read

SELECT file_id, name FROM sys.database_files BACKUP LOG [databaseName] TO DISK=‘nul:’ WITH STATS= 10 DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)