Pesquisa

sexta-feira, 27 de dezembro de 2013

Softwares muito úteis

Lista de softwares muito úteis para desenvolvedores e analistas de software. Lista baseada no post “Scott Hanselman's 2014 Ultimate Developer and Power Users Tool List for Windows

NimbleText
NimbleText is a powerful tool that makes it easy to manipulate text and data.
http://nimbletext.com/

AutoHotkey - Automation. Hotkeys. Scripting.
Fast scriptable desktop automation with hotkeys. Creating your own apps and macros has never been easier.
http://www.autohotkey.com/

LINQPad
LINQPad lets you interactively query databases in a modern query language: LINQ.
http://www.linqpad.net/

LINQ Tools
There are a number of mostly free tools that come in handy both from a usability and a learning experience.
http://www.thinqlinq.com/Post.aspx/Title/LINQ-Tools

dotPeek - Free .NET Decompiler and Assembly Browser
dotPeek is a free-of-charge .NET decompiler from JetBrains, the makers of ReSharper and more developer productivity tools.
http://www.jetbrains.com/decompiler/

Fiddler
The free web debugging proxy for any browser, system or platform
http://www.fiddlertool.com/

WinMerge
WinMerge can compare both folders and files, presenting differences in a visual text format that is easy to understand and handle.
http://winmerge.org/

NCrunch is an automated concurrent testing tool for Visual Studio.
It intelligently runs automated tests so that you don't have to, and gives you a huge amount of useful information about your tested code, such as code coverage and performance metrics, inline in your IDE while you type.
http://www.ncrunch.net/

Query Express
Query Express is a simple Query Analyzer look-alike, but being small and free it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects to Oracle and other OLE-DB compliant databases.
http://www.albahari.com/queryexpress.aspx

dbForge SQL Complete
dbForge SQL Complete is a useful add-in for Microsoft SQL Server Management Studio and Microsoft Visual Studio. Free and advanced paid editions of the SQL code formatter offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.
http://www.devart.com/dbforge/sql/sqlcomplete/

ClipX
ClipX is a tiny clipboard history manager. It is sweet, it is free, use it.
http://bluemars.org/clipx/

Log Parser Lizard GUI - FREE Query Software
Log Parser is wonderful because it effectively lets you run SQL queries against text files
http://www.lizard-labs.net/log_parser_lizard.aspx

Fonte: Scott Hanselman's 2014 Ultimate Developer and Power Users Tool List for Windows

sábado, 14 de dezembro de 2013

CREATE DATABASE permission denied in database 'master'

1.  shut down SQL Server from services

2.  open cmd window (as admin) and run single-user mode as local admin with this command:
"c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -m -s SQLEXPRESS

3.  open another cmd window (as admin)

4.  open sqlcmd:
sqlcmd -S .\SQLEXPRESS
Now add the sysadmin user:
a.  sp_addsrvrolemember 'domain\user', 'sysadmin'
b.  GO

5.  now Ctrl+C the single-user mode from the first cmd window to kill SQL Server.  Now restart it from services the normal way.  Log into Management Studio and the user you created should be listed under logins with the credential of "sysadmin."

Fonte: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/76fc84f9-437c-4e71-ba3d-3c9ae794a7c4/sql-express-2008-r2-create-database-permission-denied-in-database-master?forum=sqlexpress