In this chapter we will talk about security recommendations for SQL Server Data Mining.

Data Mining Part 23: Security

by Daniel Calbimonte

SQLServerCentral.com

In this chapter we will talk about security recommendations for SQL Server Data Mining.

Grant Fritchey Reviews Minion Reindex

by Grant Fritchey

SQLServerCentral.com

Indexing

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.

Time for Learning

by Steve Jones

SQLServerCentral.com

Editorial

How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.

Finding Encrypted Data in a SQL Server Database

by Additional Articles

MSSQLTips.com

Encryption

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.

Selecting from sub-queries as tables

by Ben Kubicek

SQLServerCentral.com

Sub-queries

Using sub-queries as tables only requires an alias

Which Problem Are You Solving?

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones talks a bit about problem solving and how you should approach the issue.

Discrete and Continuous Data in SQL

by Additional Articles

SimpleTalk

data

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.