quinta-feira, 23 de outubro de 2014

Top 5 Things to Look for in a Disaster-Recovery-as-a-Service (DRaaS) Provider

http://ift.tt/1tgeNYd

For SQL Server users who can't afford to build, configure, test, and maintain an effective SQL Server disaster recovery plan (DRP), disaster recovery as a service (DRaaS) can be a great option.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Firebird 3 Beta 1 Unofficial Installers for Windows and Linux are available


Firebird 3 is on its track to release: the first Beta version of source code was tagged, and now Firebird core developers work on Beta 2, with intention to release final Firebird 3 in the beginning of 2015. 

How to ensure that Firebird 3 will be stable and reliable? How to make it happen earlier? The answer for these questions is: intensive beta-testing with wide community support.

To start effective beta-testing earlier and to supply Firebird developers with convinient path to Firebird 3 we started Firebird 3 Launch Campaign (www.firebird3.com).  It has 3 parts:

1) Firebird 3 distributives, materials and documentation, with focus on Firebird 3 new features, configuration tips and tricks, performance testing, and, of course, beta-testing.  

2) Banners for Firebird 3. To support Firebird 3 Launch Campaign, simply put Firebird 3 banner  to your blog/web-site, and point them to www.firebird3.com

3) Social activity: starting with simple posts and «likes», then we will continue with contests and special prizes. Join Firebird in Facebook  (https://www.facebook.com/FirebirdSQL ) and LinkedIn (https://www.linkedin.com/groups?gid=2078215) to be part of the action!

We believe that Firebird 3 will become the best version of Firebird ever, and to encourage you and all Firebird developers we prepared a lot of very interesting materials for Firebird Launch Campaign.

Stay tuned for Firebird 3 news!



Check out my new book on MariaDB http://www.amazon.com/dp/B00MQC06HC

Monitoring progress and temporal memory usage of Online DDL in InnoDB

http://ift.tt/1vR6dyT

Introduction Online DDL is a new feature in MariaDB 10.0. Online DDL is processed through below 4 tasks in sequence. InnoDB::ha_prepare_inplace_alter_table(..) InnoDB::ha_inplace_alter_table(..) InnoDB::ha_commit_inplace_alter_table(..) mysql_rename_table(..) InnoDB storage engine allocates temporal memory buffer for transaction logging in phase 1 where row changes during this phase are logged. Size of this buffer is at start sort_buffer_size and it… Continue reading

from The MariaDB Blog http://ift.tt/1pKKMuy

quarta-feira, 22 de outubro de 2014

MariaDB 10.1.1: FLUSH and SHOW for plugins

http://ift.tt/1wpwzWK

One of the most popular plugin types both in MariaDB and MySQL is INFORMATION_SCHEMA plugin type. INFORMATION_SCHEMA plugins add new tables to the INFORMATION_SCHEMA. There are lots of INFORMATION_SCHEMA plugins, because they can be used to show just anything to the user and are very easy to write. MariaDB 10.1.1 comes with nine INFORMATION_SCHEMA plugin:… Continue reading

from The MariaDB Blog http://ift.tt/1pKKMuy

PASS Summit Announcement: Day 2, Women in Technology Keynotes

http://ift.tt/1DBxjfD

Kelsey Levitt
Recently announced are two new keynote speakers for PASS 2014. The Day 2 keynote will be presented by Dr. Rimma Nehme, and the keynote speaker for the Women in Technology Luncheon will be Kimberly Bryant.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

NULLs and SQL SERVER... details matter!

While refactoring a function made  by a developer , I came across a situation where the COALESCE was not helping to prevent null values​​. In case it was an assignment of value to a variable based on a query.

Observe the test code below:

CREATE TABLE #teste 
  ( 
     codigo INT 
  ) 

DECLARE @codigo INT; 

SELECT @codigo = COALESCE(codigo, 0) 
FROM   #teste 

SELECT @codigo AS [Retornando NULO] 

DROP TABLE #teste 

If you run the above code, notice that the result is null, even using the coalesce function. In case, the developer decided issue by adding a check with IF testing checking if the variable is null.

This is not wrong, but I think we should reduce the flow of unnecessary code. We can work around the problem by adding the default value in the variable declaration. Thus, if the query returns nothing, the variable retains the original value.

CREATE TABLE #teste 
  ( 
     codigo INT 
  ) 

INSERT INTO #teste 
VALUES      (1) 

DECLARE @codigo2 INT = 0; 

SELECT @codigo2 = COALESCE(codigo, 0) 
FROM   #teste 

SELECT @codigo2 AS [Retornando ZERO] 

DROP TABLE #teste

Check out my new book on MariaDB http://www.amazon.com/dp/B00MQC06HC

NULLs no SQL SERVER ... detalhes que podem incomodar!

Ao refatorar uma função desenvolvida por um desenvolvedor, me deparei com uma situação onde o COALESCE não estava ajudando a evitar os valores nulos. No caso, foi uma atribuição de valor a uma variável com base em uma query.

Observe o código de teste abaixo:
CREATE TABLE #teste 
  ( 
     codigo INT 
  ) 

DECLARE @codigo INT; 

SELECT @codigo = COALESCE(codigo, 0) 
FROM   #teste 

SELECT @codigo AS [Retornando NULO] 

DROP TABLE #teste 

Se você executar o código acima, perceberá que o resultado é nulo, mesmo usando a função coalesce. No caso, o desenvolvedor resolveu problema adicionando uma verificação com IF verificando testando se a variável está nula.

Isso não está errado, porém acho que devemos diminuir ao máximo fluxos desnecessários de código. Podemos contornar o problema, adicionando o valor padrão na declaração da variável. Desta forma, se a query não retornar nada, a variável mantém o valor original.

CREATE TABLE #teste 
  ( 
     codigo INT 
  ) 

INSERT INTO #teste 
VALUES      (1) 

DECLARE @codigo2 INT = 0; 

SELECT @codigo2 = COALESCE(codigo, 0) 
FROM   #teste 

SELECT @codigo2 AS [Retornando ZERO] 

DROP TABLE #teste 

Check out my new book on MariaDB http://www.amazon.com/dp/B00MQC06HC

Be Careful! SQL Server Backups Can Bite You!

http://sqlmag.com/database-backup-and-recovery/be-careful-sql-server-backups-can-bite-you

Imagine that you move a database from an old server to a new server. Then, the product team tells you that data is missing. What happened here?

read more



from SQL Server Pro http://ift.tt/1kCjeYg

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

http://ift.tt/1wosmme

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Goodbye Big Data, Hello All Data?

http://ift.tt/1x8vKSk

You need a strategy for all your data
Big Data doesn't really mean anything. With SQL Server 2014 and the democratization of data, it appears that "traditional data" and Big Data are merging.
Content Classification:  Curated

read more



from SQL Server Pro http://ift.tt/1kCjeYg