SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. It was first launched in 1989 and continues to be popular to this day.

SQL stands for Structured Query Language and is used to communicate with the database. SQL Server fully supports this language and allows you to perform CRUD operations using INSERT, SELECT, UPDATE and DELETE statements.

SQL Server is popular at being used in conjuction with .NET applications and allows the two to work side by side, transfering data between the application and the database.

Other features include the use of profiler tools to debug usage, supporting multiple databases per server, and being able to support large amounts of data.

Examples Using the sys Schema in SQL Server

3 months ago

The Object Catalog and Dynamic Management Views are some of the features that are stored in the sys schema. They contains many objects that are built-in to every SQL Server database. Information about the tables, stored procedures and views contained within your database can be retrieved through these objects. They also give you information, like […]

SQL: Joining and Grouping

4 months ago

With so much choice out there, it can be easy to concentrate on emerging technologies rather than the basics. But from time-time, going over the basics can be beneficial to get the best performance. It’s a term used a lot in sport, and it’s no different with Software Development. In this article, I’m going to […]

Tools to Improve Slow SQL Queries in SQL Server

5 months ago

It can be frustrating when the cause of your slow web application is down to the queries it makes to the database. This can be down to many reasons, including: Computer hardware Large volumes of traffic querying the database simultaneously Too many joins with other tables Querying against a table that has lots of records […]

Three SQL Server features you may not use too often

6 months ago

Common SQL features regularly used in your web application will include the normal CRUD operations. However, SQL Server has many more features. Here are three that I picked out that you may not use too often: Check Constraints Check constraints is a way that you can check the integrity of your data when you are […]