Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 13433    Older >>
 

Database ownership and TRUSTWORTHY

Database ownership is an old topic for SQL Server pro's. Check this simple lab to learn the risks your databases can be exposed to.  Read more...
By Raul Gonzalez 2015/01/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,129 reads

You Better Learn to Work at Scale

We are managing more and more systems and databases all the time. To Steve Jones, that means we must be able to work at scale.  Read more...
By Steve Jones 2015/01/29 | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

Using T-SQL to Perform Z-Score Column Normalization in SQL Server

In data mining, we sometimes need to perform techniques such as Z-score normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms. Dallas Snider explains how to perform this in SQL Server with T-SQL code.  Read more...
By Additional Articles 2015/01/29 | Source: MSSQLTips.com | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 4,089 reads

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2015/01/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,772 reads

Normal Data

More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.  Read more...
By Steve Jones 2015/01/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 75 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2015/01/28 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 47,666 reads

Why Developers Need to Understand Execution Plans

If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.  Read more...
By Additional Articles 2015/01/28 | Source: SimpleTalk | Category: execution plan
Rating: (not yet rated)  Rate this |   Briefcase | 4,810 reads

Time for Learning

How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.  Read more...
By Steve Jones 2015/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.  Read more...
By Daniel Calbimonte 2015/01/27 | Source: SQLServerCentral.com | Category: roles
Rating: |  Discuss |   Briefcase | 1,467 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,111 reads

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...
By Additional Articles 2015/01/27 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 4,389 reads

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias  Read more...
By Ben Kubicek 2015/01/26 | Source: SQLServerCentral.com | Category: sub-queries
Rating: |  Discuss |   Briefcase | 9,217 reads

SQL Prompt Tip #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/01/26 | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,797 reads

Deploy the Database First

Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.  Read more...
By Steve Jones 2015/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Which Problem Are You Solving?

This week Steve Jones talks a bit about problem solving and how you should approach the issue.  Read more...
By Steve Jones 2015/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Discrete and Continuous Data in SQL

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.  Read more...
By Additional Articles 2015/01/26 | Source: SimpleTalk | Category: data
Rating: (not yet rated)  Rate this |   Briefcase | 6,047 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 26,828 reads

Custom SSMS

This week Steve Jones looks at those customizations that make your job easier.  Read more...
By Steve Jones 2015/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 226 reads

Going to Extremes to Release Bug Fixes and New Features

Extreme Programming (XP) is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use XP. But is their adherence to XP a personal preference or does it bring real benefits?   Read more...
By Additional Articles 2015/01/23 | Source: SimpleTalk | Category: extreme programming
Rating: (not yet rated)  Rate this |   Briefcase | 6,810 reads

Webinar: Oracle Exadata & In-Memory Real-World Performance

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...
By Press Release 2015/01/23 | Source: Red-Gate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 6,622 reads
   Items 1 to 20 of 13433    Older >>