SQLServerCentral.com Articles tagged data

Data Darwinism

Wed, 03 Apr 2013 06:00:00 UT

Data could be the way that more decisions are made, separating the competent from the incompetent in the future. Steve Jones isn't sure this is the best way to make decisions if we don't include a human element in the decision process.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Data Mining Introduction

Mon, 12 Nov 2012 07:00:00 UT

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.

Generating Data for Database Tests

Wed, 11 Apr 2012 06:00:00 UT

It is more and more essential for developers to work on development databases that have realistic data in both type and quantity, but without using real data. It isn't exactly easy, even with third-party tools to hand. Phil Factor shows how it can be done, taking the classic PUBS database and giving it a more realistic set of data.

Stairway to Data, Level 8: Data Encoding Schemes - Part II

Wed, 31 Aug 2011 06:00:00 UT

Joe discusses Hierarchical, Vector and Concatenation encoding before rounding up with general guidelines for designing encoding schemes.

Stairway to Data, Level 7: Data Encoding Schemes - Part I

Wed, 10 Aug 2011 06:00:00 UT

Joe discusses how to deal with the kinds of encoding schemes, how to use them and how to design them. He discusses Enumeration, Measurement, Abbreviation and Algorithmic categories

Stairway to Data, Level 6: Types of Scales - Part II

Wed, 27 Jul 2011 06:00:00 UT

Joe Celko introduces more powerful scales such as Interval, Log interval and ratio scales; before moving on to conversions, punctuation and units. Finally he gives guidelines as to how best to use scales in a database.

Stairway to Data, Level 5: Types of Scales – Part I

Wed, 06 Jul 2011 06:00:00 UT

Joe Celko discusses Nominal, Categorical, Absolute, Ordinal and Rank scales. These are the weakest scales we can use, starting with the weakest.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Stairway to Data, Level 4: Temporal Data

Wed, 15 Jun 2011 06:00:00 UT

Joe Celko tackles the most difficult of all the types of data handled by SQL, temporal data, and explains how to avoid the commonest traps for the unwary programmer

Stairway to Data, Level 3: Strings

Wed, 01 Jun 2011 06:00:00 UT

Character-handling in SQL is not particularly straightforward, and confusion about collation and character encoding is a common cause of problems with searching, joining, and sorting.

Stairway to Data, Level 2: Numerics

Wed, 18 May 2011 06:00:00 UT

A confusion about the nature of numbers can lead to a number of problems in database applications. Joe Celko gives a simple guide to the subject

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Data Loss or Downtime

Fri, 07 Jan 2011 07:00:00 UT

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.

Decompressing on Compression in SQL Server 2008....

Wed, 02 Sep 2009 06:00:00 UT

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...