There are many tools you can use to work with SQL Server and provide guidance and information about things that need attention in your systems. From best practices analyzers to classification tools, to performance management tools – there are a whole host of utilities that can help in significant ways. However, as you’re deploying and using these tools, it’s critical […]
Tag: sql
Parsing Intents and Their Targets into SQL Queries with spaCy: Part 2
In the previous article of this series, you learned that spaCy allows you to train its parser to be specific to your domain, which can be useful if you, for example, are developing a conversational application. In the example given in the article, you were guided through the steps of preparing training examples for the parser and then training the...
Parsing Intents and Their Targets into SQL Queries with spaCy: Part 1
People use natural languages to communicate with each other. To efficiently interact with a machine, good knowledge of programming languages is required. Natural Language Processing (NLP) is here to enable human-machine communications through natural languages. This is however, a very general notion of what NLP is. Intuitively, it may seem that an NLP-enabled application understands human speech natively, like a...
SQL Readability
One of the things I have found helpful is to be consistent on how your layout your SQL queries. Consistency is probably more important than any particular little option. If your queries are consistent throughout, then others looking at your code will be able to understand more quickly what is going on. In this area, I really do like having […]
Application of Triggers and Understanding the Transaction Procedures in Database Part – 1
Application of Triggers and Understanding the Transaction Procedures in Database Part – 1 Introduction In the cutting – edge technology of Relational Database Management System (RDBMS), the information in a table / relation is connected to some additional tables / relations too. For that reason, every time an individual alters the information in one table / relation or another, the...
Attribute Discretization Part I: Introduction and Overview
Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords...
Why Learning Fluent SQL Will Provide More Business Opportunities
Why Learning Fluent SQL Will Provide More Business Opportunities If your business deals with records, whether of contacts, inventory or other business needs, then you know the value of organizing those records for easy access. If you use a Structured Query Language (SQL) database, then you have already positioned yourself for both simplicity and the expansion of your business. SQL...
Using Non-Equi Joins
Using Non-Equi Joins Non-equi joins are those ones where the join condition uses an inequality comparison. This can be useful when defining self joins – ones defined on the same table. Suppose you have a table whose rows contain information about football teams. You need to make up a schedule for a series of games where each team is to...
Monitoring Blocked Processes with Event Notifications
Monitoring Blocked Processes with Event Notifications Author: Basit A. Farooq Introduction SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict in which...
Getting Started With Hierarchical Queries
Getting Started With Hierarchical Queries Hierarchical queries return rows in the order that forms a hierarchical tree where each row is located at a certain level in a hierarchy, having a parent, children, or both. The best way to understand this concept is to build some hierarchical queries against database objects that permit it. For example, you might issue such...