Para quem não conhece, a SQLPass é, segundo o próprio site:   "uma associação independente, não-comercial, dedicada a apoiar, educar e promover o Microsoft SQL Server. De grupos de usuários locais, grupos de interesse especial (SIGs) até webcasts e o PASS Community Summit - o maior evento...

English Portuguese A nice SQL Server 2005 quiz created by Software Architecs . The quiz has 7 technical questions about SQL Server 2005. My Results?   Quiz link: http://www.software-architects.com/TechnicalArticles/Quiz/tabid/82/language/en-US/Default.aspx Source: Cristian Lefter blog Um quiz muito...

Okay, so rule number one of user interface design is consistency - make sure people don't have to learn new things too often and be sure to use the same design (bad or otherwise) everywhere. So why in gods name did the SQL Server team feel the need to replace the File Browser with their own mess of an...

This post is more for my memory than anything else but ... I've had issues restoring a SQL 2005 database from a backup today using the SQL Workbench with the following error message: - The backup set holds a backup of a database other than the existing 'MyDatabase' database. RESTORE DATABASE is terminating...

We're not talking about swallows (African, European or otherwise) but Database Migrations that ship with Ruby on Rails. There's a cool bit of functionality which lets you stores database schema and incrimental changes in code files as well as a framework which offers the ability to roll the database...

Well, Red Gate have done it again , they've come up with another fantastic product ! This time they've addressed and area which has been ignored for a *long time* with a tool which will help you refactor that *horrible* SQL code you crank out on a daily basis. SQL Refactor is an Add-In to Microsoft...

I recently blogged about a small but frustrating bug in SQL Server relating to creating new columns of type varchar . Douglas Reilly linked to my blog posting about the bug , and it consequently got picked up and placed at the top of the Dr. Dobb's Database Update e-mail. Well - it's shocked...

I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've found a little bug. If you create a column, enter...

Esse é um assunto que a grande maioria dos administradores de banco e de redes deixa passar batido… seja por desconhecimento ou simplesmente por achar que os ganhos de performance são tão insignificativos que não vale a pena o esforço… mas que como vamos ver vale sim a pena ser discutido… Eu não vou...

Você quer aprender mais sobre o SQL Server 2008? Então reserve o sábado, dia 07/11/09 inteiro! A comunidade, com o apoio da Microsoft vai realizar um evento online com mais de 12 horas de duração ininterruptas! Com alguns dos melhores profissionais de SQL Server no Brasil compartilhando seus conhecimentos...