SQL Server 2016 Stretch Database One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud. By leveraging the Stretch Database feature your applications can silently migrate data to the cloud without having to change your existing code. Stretch Database … [Read more…]
What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats and technologies to combine data … [Read more…]
Leveraging SQL Server Database Schema Data warehouses typically pull data from various sources and combine the data into a common repository. Keeping up with the source systems and what data is being pulled from each system can be challenging. One method that can be used to easily identify the source and type of data in … [Read more…]
SQL Server 2014 Deprecated Features – Database Engine Everyone looks at the new features when trying to determine when to upgrade from an older version of SQL Server to a newer release. There are many factors to consider and for every environment certain features have a higher priority and need for implementation than others. However, … [Read more…]
T-SQL EXCEPT and INTERSECT Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same result set. EXCEPT returns the records from the query on the left that are not found in the right query. INTERSECT returns the distinct rows that are in both the right and left queries. … [Read more…]
T-SQL UNION Set operators allow you to combine data from two or more queries and return the results in a single set. There are 3 set operators available T-SQL EXCEPT, INTERSECT and UNION. This article is focused on the UNION operator. UNION is used when you need to combine data from multiple queries into a … [Read more…]
SSRS Farm Overview Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and 2014. SQL Server allows for the deployment of 2 or more servers running SQL Server Reporting Services to increase the performance of your reporting environment. SSRS stores its data in 2 databases (reportserver and … [Read more…]
T-SQL Random Numbers using RAND() SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1 of float datatype. To create a random number execute Select Rand(), in my example it returned .0131039082850364. If I wanted to always return the same number I can include a seed value, such as … [Read more…]
Row_Number SQL Server SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number() function. You can use this function to return a sequential number in your result set that begins at 1. There are 2 arguments that can be passed into the function that determines how the … [Read more…]
SQL Server Management Studio Reports Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within your database is critical to the performance of your applications. One tool you can leverage to see what is happening are the built in reports in SSMS. SQL Server includes basic reports that you … [Read more…]