Three Steps to quickly solve SQL Server High CPU usage September 20, 2018 by Rakesh Patil Introduction SQL High CPU is one of the most important performance issues when monitoring SQL Server High CPU usage in SQL Server issue may be caused by slow query performance, load on server and/or some configuration settings which affects entire application performance also. Read more »
Using the SQL Coalesce function in SQL Server September 20, 2018 by Prashanth Jayaram String manipulation is a process to generate another form of existing data in a way the business uses or displayed as results in the reports. Previous SQL string function articles, I have written, including SQL string functions for Data Munging and SQL Substring function overview discussed data preparation and data management tasks using built-in SQL Server string functions. Read more »
How to embed a Power BI Report Server report into an ASP.Net web application September 20, 2018 by Sifiso W. Ndlovu Every once in a while, teams from different functional areas of the business (i.e. business intelligence, software development, web development etc.) would join forces to form a cross-functional development team with a common goal of integrating a business intelligence artefact such as a SQL Server Reporting Services (SSRS) report into a front-end web application. There are many reasons for forming such a partnership including a lack of report-development skill by web developers, BI team owns a better reporting tool for data visualization, or maybe to prevent the software team from “reinventing the wheel” by developing a report that has already been produced elsewhere. Read more »
Deploy SQL Server with Cluster Shared Volumes – part 2 September 19, 2018 by Sreekanth Bandarla In the other article in this series: Deploy SQL Server for failover clustering with Cluster Shared Volumes – part 1 we have seen what a cluster shared volume is and what are the advantages and other considerations to keep in mind when deploying CSVs for SQL Server workloads. In this article, I will walk though actual installation of a failover cluster Instance leveraging CSVs. Read more »
Text Analytics with Microsoft Flow September 19, 2018 by Esat Erkec Twitter is a very popular social media platform which generates millions of tweets a day. These tweets include very valuable data for marketers or social media analyzers because they can analyze these tweets with specific algorithms and find out the sense of social media users. Read more »
SQL Server Data Import using SQL Operations Studio September 18, 2018 by Rajendra Gupta SQL Operations Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW. Read more »
SQL Server database backup tools September 18, 2018 by SQLShack This collection of content presents an overview of top SQL Server database backup tools, with product page links for each of the tools and screenshots if available. If you noticed a tool we missed, please let us know in the comments below. Read more »
Querying data using the SQL Coalesce function September 18, 2018 by Bojan Petrovic We all know that a Null value is a field with no value. The statements that we are running daily will have to deal with Null values, especially when it comes to strings concatenation (adding strings together). Read more »
Available options for generating heatmaps in an SSRS report September 17, 2018 by Sifiso W. Ndlovu As developers of business intelligence solutions, we tend to service different types of business users. Whilst a call center supervisor is more likely to consume reports that offer detailed breakdown of day-to-day performance of her call center agents, senior managers on the other hand often prefer big-picture analytical reports that represent data in a form of colorful graphs and charts. Not surprisingly, such reports often make use of heatmap controls to provide visually effective comparative view of business metrics against set targets. Read more »
SQL Join overview and tutorial September 17, 2018 by Prashanth Jayaram The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause. It’s the nature of traditional relational database systems where some table contains information related to other tables with a common key value. Using a SQL join, you can easily perform queries on related data-sets from multiple tables with these shared keys. Read more »
SQL Server database auditing tools September 17, 2018 by SQLShack This collection of content presents an overview of top SQL Server database auditing tools, with product page links for each of the tools and screenshots if available. If you noticed a tool we missed, please let us know in the comments below. All database auditing tools are sorted by alphabetical order. Read more »
Advanced SQL Interview Questions and Answers on SQL Server Architecture September 17, 2018 by Rakesh Patil These SQL interview questions and answers deal with the following topics: SQL Server High & Low-Level Architecture Transaction Log Architecture Query processing Architecture Memory Architecture New Features added in SQL Server versions 2008, 2008 R2, 2012, 2014, 2016 SQL Server High & Low-Level Architecture Read more »
SQL Substring function overview September 14, 2018 by Prashanth Jayaram The requirement of data refactoring is very common and vital in data mining operations. In the previous article SQL string functions for Data Munging (Wrangling), you’ll learn the tips for getting started with SQL string functions, including the SQL substring function for data munging with SQL Server. As we all agree that the data stored in one form sometimes require a transformation, we’ll take a look at some common functions or tasks for changing the case of a string, converting a value into a different type, trimming a value, and replacing a particular string in a field and so on. Read more »
SQL Server Reporting Services (SSRS) Shared Dataset September 14, 2018 by Esat Erkec In the SQL Server Reporting Service (SSRS) report development process; we can use a beneficial feature which is called the “shared dataset”. The purpose of SSRS embedded datasets are to retrieve data from target data sources for only one report but a shared dataset can be used by multiple reports to retrieve data. Read more »
How to perform a performance test against a SQL Server instance September 14, 2018 by Jefferson Elias Introduction Intended audience This document is intended for application developers and database administrators who plan to evaluate performance for any computer hosting a SQL Server instance. Read more »
Top free add-ins for SQL Server Management Studio (SSMS) September 13, 2018 by SQLShack This collection of content presents an overview of free SQL Server Management Studio (SSMS) add-ins, with product page links for each of the tools and screenshots if available. SSMS add-ins are presented in alphabetical order. If you noticed a free tool we missed, please let us know in the comments below. Read more »
SQL string functions for Data Munging (Wrangling) September 13, 2018 by Prashanth Jayaram In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server. In many cases, Machine learning outcomes are only as good as the data they’re built on – but the work of preparing data for analytics (that is, data wrangling) can eat up as much as 80% of your project efforts. Read more »
SQL Server transactional replication: How to reinitialize a subscription using a SQL Server database backup September 13, 2018 by Prashanth Jayaram A workload management is considered as a critical aspect of SQL Server transactional replication. Replication is the oldest of the high availability technologies in SQL Server and it is available since the inception of SQL Server. As a very mature technology, SQL Server transactional replication is also very robust and, in most cases, very straightforward to set up and manage. Read more »
Querying data using the SQL Case statement September 12, 2018 by Bojan Petrovic The Case statement in SQL is mostly used in a case with equality expressions. The SQL Case statement is usually inside of a Select list to alter the output. What it does is evaluates a list of conditions and returns one of the multiple possible result expressions. Read more »
SQL Server Execution Plan Operators – Part 1 September 12, 2018 by Ahmad Yaseen In the previous articles of this series, SQL Server Execution Plans overview , SQL Server Execution Plans types and How to Analyze SQL Execution Plan Graphical Components, we discussed the steps that are performed by the SQL Server Relational Engine to generate the Execution Plan of a submitted query and the steps performed by the SQL Server Storage Engine to retrieve the requested data or perform the requested modification operation. Read more »
