Profile

Cover photo
Antonio Barbosa
261 followers|5,875 views
AboutPostsPhotosVideos

Stream

Antonio Barbosa

Shared publicly  - 
 
 
Take a step.....
1
Add a comment...

Antonio Barbosa

Shared publicly  - 
2
Filipe Santos's profile photo
 
E so vida boa... 
 ·  Translate
Add a comment...

Antonio Barbosa

Shared publicly  - 
 
Let's see if a few read this :)
 
SQL database normalization

The main purpose of database normalization is efficiency. This is achieved by eliminating redundant data (a record is stored in a single table, not several times in different tables) and creating* data dependencies that make sense* (not storing unnecessary data again, just using a relation to connect to 2 different entities). One of the definitions of normalization I like is “how to resolve the developer tendency to squeeze as much data as possible into as few tables as possible”

Besides the fact that SQL queries are written faster on normalized databases (as you’re don’t have to roam through different tables containing the same records, figuring which table to query), they are also executed faster, as a normalized database takes up a less space and data is logically stored

There are various guidelines based on Microsoft recommendations, and the levels of normalization are from the first normal form (1NF, the lowest) till the fifth normal form (5NF, the highest level of database normalization). The forms 1NF, 2NF, and3NF are most common

#SQLServer #SQLnormalization
3
1
Antonio Barbosa's profile photoMilena Petrovic's profile photo
2 comments
 
It's a good article and should / must be read. Thank you ;)
Add a comment...

Antonio Barbosa

Shared publicly  - 
 
 
This simple setting will warn you if someone's trying to hack into your Gmail or Google account. You may have them enabled already, but pass it along to someone who might not:
2
1
Add a comment...
Have him in circles
261 people
Eric Lu's profile photo
Mark Holmes's profile photo
Wil Sisney's profile photo
Pedro Lemos's profile photo

Antonio Barbosa

Shared publicly  - 
 
Ainda não fecharam?
Ainda precisam de mais 5 razões?
 
5 razões para fechar a sua conta do Facebook http://ow.ly/mRxv8
 ·  Translate
1
Add a comment...
 
 
Database mail

For all of us who love to be up to date with what’s going on in a database, there’s database mail. You can schedule its sending, or even have it fired by a trigger

I must admit that I’ve searched for a way to add an attachment using SQL Server Management Studio | Management | Database Mail, but it seems it’s not possible

The only way to add an attachment to your emails sent via SQL Server is to use T-SQL such as:

EXEC msdb.dbo.sp_send_dbmail
  @profile_name='Millie Profile',
  @recipients='milena.petrovic@apexsql.com',
  @subject='ApexSQL Log report',
  @body='ApexSQL Log completed successfully. See the attachment',
  @file_attachments='E:\Test\exporttest1Details2.sql'

In SQL Server 2014, I’d like to have database SMS as a new feature ;) It’ll be my favorite

#SQLServer #SQLDatabaseMail
1
Add a comment...

Antonio Barbosa

Shared publicly  - 
 
Alerta #pl118  
 
Taxa sobre leitores de MP3, discos externos e "pens" volta a gerar polémica http://goo.gl/zZzj3
 ·  Translate
1
Add a comment...

Antonio Barbosa

Shared publicly  - 
 
 
Sign and store your documents in Google Drive with SignEasy

Google Drive works with a number of third-party apps that help you get stuff done on the go. SignEasy, a digital signature app, makes it simple for businesses to get your docs signed directly from your phone and tablet. With SignEasy's new Google Drive integration for iOS, now you can import a document from Drive, sign it digitally on your iPhone or iPad, and save the final document back to your Drive. 

Visit the SignEasy blog to learn how it works: http://goo.gl/m4tuH
1
Add a comment...

Antonio Barbosa

Shared publicly  - 
 
- Estão disponíveis atualizações que corrigem os erros introduzidos na atualização de ontem.
- Mas ainda ontem atualizou para corrigir os erros da atualização de Quinta!?!
- Pois, e amanhã ou segunda irei atualizar para corrigir os erros que vão ser introduzidos hoje...

#MeuDia_A_Dia  
 ·  Translate
2
Add a comment...
People
Have him in circles
261 people
Eric Lu's profile photo
Mark Holmes's profile photo
Wil Sisney's profile photo
Pedro Lemos's profile photo
Links
Contributor to
Basic Information
Gender
Male