Script to Capture Performance Stats When Testing SQL Server T-SQL
In this tip we show how to run a repeatable SQL Server T-SQL test to capture run statistics.
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.
Inserting Rows into SQL Server from a Java Program
In this tip we cover how to write a Java program to connect to a SQL Server database using Windows authentication and insert a row into a database table using the INSERT command.
Connecting a Java Program to SQL Server
I need to write a Java program to connect to a SQL Server database using Windows authentication and retrieve rows from a SELECT statement. Read this tip to learn how.
Resolving the Maximum Request Length Exceeded Exception in SSRS
When deploying a report in SQL Server Reporting Services, I am receiving an exception error stating Maximum request length exceeded. Read this tip to learn how to resolve this issue.
Connecting WEKA to SQL Server 2016
Learn how to connect WEKA which is an open source data mining application to SQL Server 2016 to performance data analysis.
Use a CrossJoin to Calculate Multiple Pearson Correlation Coefficients in T-SQL
I need to calculate multiple Pearson product moment correlation coefficients for data that are stored in one SQL Server table. Read this tip to learn how.
Use Sqoop to Append SQL Server Data to an Existing HDFS File
Learn how to use Sqoop to append SQL Server data to an existing HDFS File with the T-SQL and command line code.
Calculate Pearson Product Moment Correlation Coefficient with T-SQL
I need to calculate the Pearson Product-Moment Correlation Coefficient for two sets of measurements that are stored in my SQL Server database. In this tip we cover how this can be done with examples.
Export from Hadoop File System to a SQL Server Database Table
I need to export data from the Hadoop Distributed File System (HDFS) to a SQL Server database table. Read this tip to learn how.
Load SQL Server T-SQL Query Results to Hadoop Using Sqoop
I need to load the results from a SQL Server T-SQL query to a Hadoop Distributed File System. How can I do this? How can I validate the data was loaded correctly?
Sqoop Runtime Exception: Cannot Load SQL Server Driver
I am receiving the following error when running Apache's Sqoop to connect to a SQL Server database: java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver How can I resolve this error?
Using Sqoop WHERE Argument to Filter Data from a SQL Server
I need to load a specific subset of data from a SQL Server table to a Hadoop Distributed File System. Learn how to use a WHERE clause to restrict the data loaded to the Hadoop Distributed File System.
Use Sqoop to Load Data from a SQL Server Table to a Hadoop Distributed File System
Learn how to use Sqoop to Load Data from a SQL Server Table to a Hadoop Distributed File System with step by step instructions.
Select min and max values along with other SQL Server columns using T-SQL
I have a dataset where I need to find the minimum and maximum values in a SQL Server table. In the case where multiple rows contain the same minimum or maximum value I only want to select the first occurrence. Read this tip to learn how.
Transforming Cartesian Coordinates to Spherical Coordinates in SQL Server with T-SQL
I need to transform Cartesian coordinate data in a SQL Server table to spherical coordinates. In this tip I show how this can be done in T-SQL.
Min-Max Normalization in T-SQL when the Boundaries are not [0,1]
I'm tracking weekly quantities of product sales and I would like to create a normalized score of product sales each week from 1 to 100. Read this tip to learn how to do this with T-SQL.
Plotting a Bell Curve in SSRS
Follow the step by step process in this tip to learn how to plot a Bell Curve with SQL Server Reporting Services.
SQL Server T-SQL Code to Generate A Normal Distribution
Learn how to build SQL Server T-SQL code to generate a normal distribution also known as a bell curve.
SQL Server T-SQL to Return Consecutive Values Over a Certain Value
Learn how to use a Common Table Expression (CTE) with SQL Server T-SQL code to find consecutive data points that exceed a particular value.
SQL Server T-SQL Code to Calculate a Moving Average
Learn how to calculate a moving average in SQL Server with T-SQL code with a sample data set. Learn how to validate the results and visualize them as well.
Install Your Own Copy of the SQL Server AdventureWorks2014 Database
Learn how to restore the AdventureWorks and AdventureWorksDW2014 SQL Server databases with Management Studio to follow along with numerous demonstrations.
Binning SQL Server Data to Reduce Column Cardinality
I have a SQL Server data set based on age with values from 0 to 100. From this dataset I need to build a histogram showing the age distribution in 10 year increments. Ultimately, I need to use this data as input for a SQL Server Analysis Services neural
SQL Server Performance Test for Bit Data Type in a WHERE Clause
Check out the performance implications for a bit, varchar or integer data type in SQL Server with a random data set.
Interpreting the SSAS Classification Matrix
Learn about the SQL Server Analysis Services Classification Matrix numbers as true positives, true negatives, false positives and false negatives.