Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Dallas Snider

Dallas Snider

Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida. He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received a B.A. in Physics from Hendrix College. Before joining UWF, he worked as a data warehouse developer for Northrop Grumman Information Systems and prior to that as a database application developer for Acxiom and Euronet. Dr. Snider’s teaching and research interests include data mining, data warehousing, information visualization, and software development.

2017 Awards
MSSQLTips award

MSSQLTips award

2016 Awards
MSSQLTips award

MSSQLTips award

2015 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

2014 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

Analysis Services Administration

Configuring the Analysis Services Processing Task in SQL Server 2012 Integration Services (7/10/2013)

Analysis Services Development

A Quick Way to Start Learning SQL Server MDX (1/25/2013)
Binning SQL Server Data to Reduce Column Cardinality (2/5/2016)
Classic Machine Learning Example In SQL Server Analysis Services (6/4/2013)
Comparison of Queries Written in T-SQL and SQL Server MDX (3/28/2013)
Data Mining Clustering Example in SQL Server Analysis Services SSAS (7/5/2013)
Explaining the Calculations of Probability and Importance for Complex Association Rules in SQL Server 2012 Analysis Services (4/4/2014)
Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart (11/10/2014)
How to handle the MAXIMUM_STATES warning message in the SSAS Neural Network Data Mining Model (11/6/2015)
Interpreting the SQL Server Analysis Services Classification Matrix (12/31/2015)
Introduction to the SQL Server Analysis Services Logistic Regression Data Mining Algorithm (1/29/2015)
Introduction to the SQL Server Analysis Services Neural Network Data Mining Algorithm (5/9/2014)
Microsoft Naïve Bayes Data Mining Model in SQL Server Analysis Services (10/7/2013)
SQL Server 2012 Analysis Services Association Rules Data Mining Example (3/7/2014)
SQL Server Analysis Services MDX Average Calculation (12/4/2013)
Testing KPIs for SQL Server Analysis Services (12/30/2013)

Analysis Services Dimensions

Change Sort Options on Dimension Attributes in SQL Server Analysis Services (5/15/2014)
Defining Role Playing Dimensions for SQL Server Analysis Services (11/27/2013)

Analysis Services Measure Groups

Using MDX to Calculate Both Values and Percentages for Analysis Services (1/8/2013)

Analysis Services Performance

Analysis Services Tutorials

Introduction to the SQL Server Analysis Services Linear Regression Data Mining Algorithm (8/11/2014)

Application Development

Connecting a Java Program to SQL Server (2/21/2017)
Inserting Rows into SQL Server from a Java Program (3/6/2017)

Big Data

Export from Hadoop File System to a SQL Server Database Table (10/10/2016)
Load SQL Server T-SQL Query Results to Hadoop Using Sqoop (9/20/2016)
Sqoop Runtime Exception: Cannot Load SQL Server Driver (9/14/2016)
Use Sqoop to Append SQL Server Data to an Existing HDFS File (11/29/2016)
Use Sqoop to Load Data from a SQL Server Table to a Hadoop Distributed File System (8/29/2016)
Using Sqoop WHERE Argument to Filter Data from a SQL Server (9/7/2016)

Compression

SQL Server 2012 Partitioned Index Compression Comparison (8/28/2013)

Data Types

Precision and Scale Impact for SQL Server Data Types (10/22/2014)
SQL Server Performance Test for Bit Data Type in a WHERE Clause (1/8/2016)

Dates

SQL Server Data Aggregation for Data with Different Sampling Rates (12/4/2014)

Encryption

How much overhead does encryption add to a SQL Server query (4/2/2014)

Functions - User Defined UDF

Create Your Own RANDBETWEEN Function in T-SQL (8/4/2014)
SQL Server T-SQL Code to Calculate a Moving Average (3/8/2016)
Video on how to create your own RANDBETWEEN function for SQL Server (9/11/2014)

In-Memory OLTP

Quick Guide to Installing SQL Server 2014 (5/29/2014)

Integration Services Analysis Services Tasks

Introduction to the Dimension Processing Destination in SSIS 2012 (7/22/2013)

Integration Services Control Flow Transformations

Integration Services Excel

Configure the Flat File Source in SQL Server Integration Services 2012 to read CSV files (4/3/2013)

Integration Services Security

SFTP in SQL Server Integration Services SSIS Package with Bitvise (9/17/2015)

JOIN Tables

How to Join to the Same Table Multiple Times for a SQL Server query (2/24/2015)

Other Database Platforms

Connecting WEKA to SQL Server 2016 (1/9/2017)

Professional Development Career Planning

Starting as a SQL Server Business Intelligence Developer (10/10/2014)

Reporting Services Development

Reporting Services Formatting

Create a Greenbar Report in SQL Server Reporting Services (3/31/2015)
Remove Question Mark and Show Correct Total Number of Pages in SSRS Report (5/29/2015)
SQL Server Reporting Services Expression Builder to Reformat or Convert Text Box Values (6/3/2015)

Reporting Services Security

Security

Generating A Password in SQL Server with T-SQL from Random Characters (4/24/2015)
Generating a Password in T-SQL from a Table of Words (4/29/2015)

T-SQL

A More Versatile SQL Server Random Number Function (3/23/2015)
Advice for Learning T-SQL SELECT Statement Step By Step (2/5/2015)
Avoiding erroneous results when using T-SQL Trigonometric Functions in SQL Server 2012 (2/27/2014)
Calculating the Pearson Product Moment Correlation Coefficient in T-SQL (11/7/2016)
Integrating SQL Server Data Using Union, Case and Cast in T-SQL (11/4/2014)
Min-Max Normalization in T-SQL when the Boundaries are not [0,1] (7/19/2016)
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error (7/16/2015)
Script to Capture Performance Stats When Testing SQL Server T-SQL Statements (4/6/2017)
Select min and max values along with other SQL Server columns using T-SQL (8/22/2016)
SQL Server Min Max Column Normalization for Data Mining (12/23/2014)
SQL Server Random Sorted Result Set (2/26/2015)
SQL Server T-SQL Code to Return Consecutive Values Over a Certain Value (3/16/2016)
T-SQL Bitwise Operators in SQL Server (10/28/2015)
Transforming Cartesian Coordinates to Spherical Coordinates in SQL Server with T-SQL (7/26/2016)
Use a CrossJoin to Calculate Multiple Pearson Correlation Coefficients in T-SQL (12/13/2016)
Using T-SQL to Perform Decimal Scaling Normalization for SQL Server (2/11/2015)
Using T-SQL to Perform Z-Score Column Normalization in SQL Server (1/21/2015)
Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions (2/18/2013)

Testing

Install Your Own Copy of the SQL Server AdventureWorks2014 Database (2/17/2016)
SQL Server T-SQL Code to Generate A Normal Distribution (3/29/2016)

Triggers

Beware of Logic Errors in your T-SQL Triggers (10/14/2015)
Create a Simple SQL Server Trigger to Build an Audit Trail (10/7/2015)
SQL Server Trigger After Update for a Specific Value (9/10/2015)

Upgrades and Migrations

Quick Guide to Upgrading to SQL Server 2014 (6/6/2014)

More SQL Server Solutions