Posts grid page

Corruption in Model Database – Part 1: The Discovery
January 9, 2015

After trying to connect to SQL Server service I got the following error message:

and the additional information wasn't that "informative"! Using Continue reading

Aproach to inicial Log file size
December 20, 2014

With a database that works with only SELECTs or with very few INSERT/UPDATEs then - log file size = 5% to Continue reading

Creating a Virtual Switch in Hyper-V
December 15, 2014

If we want to create virtual machines that have to communicate between them or have access to internet, we must Continue reading

SSMS Tool Pack
November 12, 2014

A great tool for SSMS by Mladen Prajdić

SSMS Tool Pack

http://www.ssmstoolspack.com/

Continue reading
ERROR: The security database does not have a computer account for this workstation trust relationship
October 2, 2014

Aconteceu no Microsoft Server 2012 R2 aquando do logon de domínio....

A solução é relativamente simples:

Entrar no servidor com um utilizador local Continue reading
Admin password reset in Windows Server 2012 R2
October 2, 2014
Start system with Windows Server 2012 R2 media DVD On Setup Screen click NEXT Select "REPAIR YOUR COMPUTER" option On "Choose an option" Continue reading
Recovery objectives (RPO e RTO)
August 12, 2014

With simple words:

RPO: Recovery point objective = Data loss Describes the acceptable latency of data that will not be recovered.

RTO: Recovery Continue reading

Useful Apps for Windows and SQL Server
June 11, 2014
SQL Server Apps and Tools SQL Load Generator SQL Sentry Plan Explorer SQL Query Stress SSMS Tools Pack ApexSQL Complete Performance Analysis of Logs (PAL) Tool SQL Continue reading
Drop all connections of a database
April 11, 2014
USE Master; GO DECLARE @dbname SYSNAME; SELECT @dbname =‘ABC_Database’; DECLARE @spid INT; SELECT @spid = MIN(SPID) FROM master.dbo.sysprocesses WHERE dbid = DB_ID(@dbname); WHILE @spid IS NOT NULL BEGIN EXECUTE Continue reading