If you've heard of the cloud, and wondered what it could do for your business, you've probably encountered a dazzling lexicon of jargon about it - as well as some who claim it's the future of IT, and others who say it's complex and problematic. So what is cloud computing and what is the truth? As is so often the case, it comes down to using the technology effectively, not just using it because it's there...
The dictionary definition of cloud:
If you work with SQL Server based applications then probably quite a few!
No matter what the application you are working with (CRM, Sales Order Processing, Financial Accounting, Contact Management, Booking System (to name but a few!)) there is a database behind it. Most common applications will store their data in either a Microsoft SQL Server Database or an Oracle Database (of course there are other relational database platforms out there).
Adding a Button to an Access Form using the Command Button Wizard
Adding an OpenQuery Macro to an Access Form
The SQL Server MDX SELECT statement supports the specification of up to 128 axes, but we generally only use two in our queries.
Specialist client tools might require data to be delivered via more than two axes, but in the main two axes is plenty for our requirements.
Yesterday I posted a blog article about the R Service available in SQL Server 2016 and showed an example of using regular expressions with the stringr R library.
In this blog I am talking about how R can be implemented for chart plotting purposes in SQL Server.
So, we have had SQL, TSQL, MDX, DMX, DAX to keep us busy in the SQL Server world for years now so I guess it was about time another language came along to join them!
The R Service enables integration of R scripts into TSQl scripts.
In this article I take you through the following:
The CROSS APPLY statement behaves in a similar fashion to a correlated subquery, but allows us to use ORDER BY statements within the subquery. This is very useful where we wish to extract the top record from a sub query to use in an outer sub query.
This is the first of a series of blogs containing useful pieces of code.
The following piece of code allows you to add a new Worksheet into your Workbook.
Sub NewWorksheet()
MDX is a challenging query language. It is completely different to the SQL query language despite having a SELECT statement!
MDX queries are all about hierarchies, measures and members and when it comes to carrying out tasks that are simple in SQL it may not be so simple in MDX.
Most of the time when we work with MDX queries we are interested in bringing out aggregate values that are stored in our cube, but occasionally we may want to derive values from the stored cube data.
ASP .NET Web Forms and ASP .NET MVC are both Frameworks using APIs that hook into the ASP .NET Core functionality for web development.
Each of these frameworks has its merits, but MVC was introduced to overcome some of the shortfalls of Web Forms.
