Using a form for data entry is an excellent way to control what you allow a user to select and where you want them to type. Forms look professional, and have the ability to save the entered data as a text file. This data can then be easily imported into excel for data analysis.
Many SQL Server performance problems will come down to poor physical disk performance or inadequate memory resource. This article takes a look at the Buffer Cache and some of the tools that we have for troubleshooting poorly performing SQL Server instances and queries.
Throughout this article we will meet a number of Dynamic Management Views, Functions and System Views:
UNIX is a multi-user, multi-tasking Network Operating System.
UNIX was first developed in 1969 by AT&T for a DEC PDP platform and throughout the 80s was ported to many different hardware platforms, made possible through licenses to the source code. AT&T also made their source code available to some US universities, one of which was Berkeley University, and they developed their instances of UNIX.
By the mid 80s there were two main variants of UNIX source code available to computer manufacturers:
In 1991 Linus Torvalds developed the Linux operating system. Linux is a UNIX look alike operating system, but was a complete rewrite and was not developed from the main System V or BSD source code.
The objective for the Linux operating system was to develop an Open Source operating system. Open source means that the source code is freely available in the public domain. As a result of this there are now a number of variants of Linux including (to name but a few): RedHat, CentOS, Suse, Debian, Ubuntu, Fedora.
SQL Server is Microsoft's server based Relational Database Management System (RDBMS) providing a robust, reliable and scalable solution for live OLTP business applications data and historic OLAP reporting and analysis systems.
Our portfolio of SQL Server training courses caters for all job roles within the data management, development, and data analysis business intelligence areas of interest.
There are many options to choose from when using conditional formatting, however at times we will need to use formula to manipulate our conditions further.
In this article we look at how you can query an Excel workbook as if it were a table in a SQL Server Database.
The SQL Server OPENROWSET function can be used to connect to a variety of data sources by means of a data provider:
You may think that an Excel Workbook already provides a table of data to you, and in a sense it does, an area consisting of Rows and Columns, with column and row headings and values.
It is, however, possible to create formal Tables from ranges of cells on an Excel worksheet.
Well, here are a few reasons:
In the following example we can see a drop list that a user can choose from when populating a Country column value.
