This is in continuation of the previous articles How to monitor internal data structures of SQL Server In-Memory database objects and SQL Server In-Memory database internal memory structure monitoring.
Read more »Manipulating SSAS OLAP cubes using SSIS
February 12, 2020There are many operations that we may run while working with OLAP cubes such as cube and partitions processing, executing administrative tasks, performing analysis and more… Three query languages that are used to run these operations: multidimensional expressions (MDX), data mining expressions (DMX) and XML for Analysis (XMLA). We can mainly write and execute these queries in SQL Server Management Studio, but many times we need to implement them within a flow that executes other tasks over other services (database engine, file system…)
Read more »SQL AS keyword overview and examples
February 11, 2020SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.
Read more »Learn SQL: The INFORMATION_SCHEMA Database
February 7, 2020The best way how to explain what the INFORMATION_SCHEMA database is would be – “This is the database about databases. It’s used to store details of other databases on the server”. What does that mean, how we can use it, and what we can do with this data is the topic of today’s article.
Read more »Different methods to attach SQL Server MDF files
February 7, 2020This article demonstrates different methods to attach SQL Server MDF files. First, let me explain about the database files.
Read more »Importing a BACPAC file for a SQL database using SSMS
February 6, 2020This article gives you an overview of BACPAC package and its usage in SQL Database data refresh (data import and export) using SQL Server management studio.
Read more »OLAP Cubes in SQL Server
February 6, 2020An Online Analytical Process (OLAP) cubes are used as an analytical tool. An OLAP Cube is a multi-dimensional database that is optimized for reporting purposes.
Read more »SQL Server functions for converting a String to a Date
February 6, 2020While working with raw data, you may frequently face date values stored as text. Converting these values to a date data type is very important since dates may be more valuable during analysis. In SQL Server, converting a string to date can be achieved in different approaches.
Read more »Filtering XML Columns using XQuery in SQL Server
February 6, 2020XQuery in the SQL Server helps to query and extract data from XML documents. XQuery gives different approaches to get information from the XML document and the equivalent can be used on applying a data filter or where clause on XML elements as well.
Read more »Web URL configuration in a Power BI Desktop report
February 6, 2020Power BI Introduction
Power BI Desktop provides many useful visualizations with simple configurations. You can represent data visually in different forms that help users and management in data interpretation. You can explore a broad category of Power BI articles here on SQLShack.
Read more »Getting started with Azure SQL Database
February 5, 2020In this article, we will uncover the basics of the Azure SQL Database.
Read more »Using PowerShell to split a string into an array
February 5, 2020In this article, I am going to explain the PowerShell script to split a string into an array. Before I explain it, let me just give you a small introduction of the PowerShell and the PowerShell array.
Read more »XQuery examples to delete SQL XML documents
February 5, 2020Delete operations over SQL XML should be possible with either erasing the XML document with the XML data type column or delete XML tag or attribute in the XML document using XQuery. The utilization of the XML data type with XQuery is tricky and significant in SQL Server.
Read more »Learn SQL: How to Write a Complex SELECT Query
February 4, 2020In my career, I’ve heard many times, things like “How to write a complex SELECT query?”, “Where to start from?” or “This query looks so complex. How you’ve learned to write such complex queries?”. While I would like to think of myself as of a brilliant mind or genius or add something like “query magician” to my social network profiles, well, writing complex SQL wouldn’t be the only thing required to do that. Therefore, in this article, I’ll try to cover the “magic” behind writing complex SELECT statements.
Read more »How to send database mail using a CLR stored procedure
February 3, 2020In this article, I am going to explain how we can send an email from SQL Server express edition using a CLR stored procedure. First, let me explain about the CLR stored procedures.
Read more »Drop unwanted (secondary) SQL Server transaction log files
January 31, 2020This article explores the use of multiple SQL Server Transaction Log Files and the process of removing the secondary transaction log file.
Read more »Converting commas or other delimiters to a Table or List in SQL Server using T-SQL
January 31, 2020Database developers often need to convert a comma-separated value or other delimited items into a tabular format. Delimiters include pipe “|”, hash “#”, dollar “$” and other characters. SQL Server compatibility level 130, and subsequent versions, support a string_split() function to convert delimiter-separated values to rows (table format). For compatibility levels under 130, developers have previously done this with a user-defined function, which incorporates a While loop or Cursor to extract the data.
Read more »Introduction to the XML data type in SQL Server
January 30, 2020The XML data type is a very common data type that is used to store unstructured or heterogeneous data in SQL Server. In this article, we will discuss the use of the XML data type along with its benefits, disadvantages, and limitations within various use cases.
Read more »Move a SQL database using the detach and attach method
January 29, 2020This article explores the process of moving a SQL database using the detach and attach method.
Read more »Introduction to SQL
January 29, 2020Today, data is the basis of any business. The world of enterprise computing is the epitome of data-driven businesses. The importance of structured storage of data is unquestionably in the focus. And at this time, with the computing model quickly shifting towards the cloud, and storage costs falling rapidly, enterprises are leveraging data more and more to tune their businesses.
Read more »Learn SQL: Aggregate Functions
January 28, 2020SQL has many cool features and aggregate functions are definitely one of these features, actually functions. While they are not specific to SQL, they are used often. They are part of the SELECT statement, and this allows us to have all benefits of SELECT (joining tables, filtering only rows and columns we need), combined with the power of these functions.
Read more »Association Rule Mining in SQL Server
January 28, 2020Association Rule Mining in SQL Server is the next article in our data mining article series in which we have discussed Naïve Bayes, Decision Trees, and Time Series until now. Association Rule Mining, also known as Market Basket Analysis, mainly because Association Mining is used to find out the items which are bought together by the customers during their shopping.
Read more »A SQL join on multiple tables: overview and implementation
January 28, 2020SQL join multiple tables is one of the most popular types of statements executed while handling relational databases. As known, there are five types of join operations: Inner, Left, Right, Full and Cross joins.
Read more »SQL Server collation introduction with collate SQL casting
January 27, 2020SQL Server collation refers to a set of character and character encoding rules, and influences how information is stored according to the order in the data page, how data is matched by comparing two columns, and how information is arranged in the T-SQL query statement. Collate SQL follows rules applied on a table when Select, Insert, Update or Delete operations are performed against contained data. Data always follows collation constraint rules, which are configured when creating an object.
Read more »Learn SQL: Join multiple tables
January 27, 2020If you want to get something meaningful out of data, you’ll almost always need to join multiple tables. In this article, we’ll show how to do that using different types of joins. To achieve that, we’ll combine INNER JOINs and LEFT JOINs. So, let’s start.
Read more »