quarta-feira, 23 de julho de 2014

Why TokuDB hates Transparent HugePages

http://ift.tt/WBNXeW

If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message: 2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with transparent huge pages enabled. 2014-07-17 19:02:55 13865 [ERROR] Please disable them to continue. 2014-07-17 19:02:55 13865 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) You might be curious […]

The post Why TokuDB hates Transparent HugePages appeared first on MySQL Performance Blog.



from MySQL Performance Blog http://ift.tt/Ifs2kC

terça-feira, 22 de julho de 2014

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

http://ift.tt/1sP5qxF

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.



from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ

Calculating and Verifying Check Digits in T-SQL

http://ift.tt/1mCEDwt

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we? Dwain Camps shows how it can be done in SQL in such a way that it could even be used in a constraint, and keep bad data out of the database.



from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ

Reference architecture for a write-intensive MySQL deployment

http://ift.tt/1wVAvNZ

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let me describe what we use, and later I will explain […]

The post Reference architecture for a write-intensive MySQL deployment appeared first on MySQL Performance Blog.



from MySQL Performance Blog http://ift.tt/Ifs2kC

Advanced Querying and Indexing

http://ift.tt/1wVB7mQ

You need to write fast queries for SQL Server. Learn about Brent Ozar Unlimited's 5 day course on how to write the fastest queries and design the best indexes in SQL Server.
Views: 3
0 ratings
Time: 02:03 More in Science & Technology


from Uploads by Brent Ozar ULTD http://ift.tt/1mza5Qd

The SQL Server Performance Class

http://ift.tt/1nhzgHy

You need to make your SQL Server run faster. Learn about Brent Ozar Unlimited's 4 day in-person training course on performance tuning SQL Server.
Views: 3
0 ratings
Time: 02:06 More in Science & Technology


from Uploads by Brent Ozar ULTD http://ift.tt/1mza5Qd

The Senior DBA Class of 2015

http://ift.tt/1nhz4YK

You've got to advise your team on the right decisions: is virtualization right for your SQL Server? Are you missing out on cool features from your SAN? Should you be using SSDs? Join Brent...
Views: 11
1 ratings
Time: 02:27 More in Science & Technology


from Uploads by Brent Ozar ULTD http://ift.tt/1mza5Qd

How to Read SQL Server Execution Plans

http://ift.tt/1wVASYY

A brief overview of Jeremiah Peschka's newest training: How to Read SQL Server Execution Plans. Learn more: http://ift.tt/1nhyXfX
Views: 5
0 ratings
Time: 02:34 More in Science & Technology


from Uploads by Brent Ozar ULTD http://ift.tt/1mza5Qd

segunda-feira, 21 de julho de 2014

SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

http://ift.tt/1loNjqB

This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.



from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ

Traits of a DBA - Part Two – The Personal Side of a DBA

http://ift.tt/1loNiTC

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.



from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ