SQL Server

In which cases it is necessary to manually add statistical objects to tables and indices in Microsoft SQL Server.The statistics can be generated automatically and updated depending on certain...

The first cross-platform SQL Operations Studio tool from Microsoft for database developers and administrators.Microsoft SQL Operations Studio (or SOS, as the product was called) is the first tool...

The new module provides additional benefits to customers who do not have high-level support from Microsoft.Microsoft is constantly releasing new products and plug-ins for SQL Server, continuing...

Tempdb is a critical system database in Microsoft SQL Server. Its unique feature is that it is a shared resource that all users of an SQL Server instance access to place temporary user objects, such...

Dynamic administrative views, time statistics and client statistics of SQL Server Management Studio.Configuring database performance is not the most enjoyable task for database professionals, but...

Almost all my recommendations addressed to developers of SQL Server, Visual Studio and VB.NET are based on readers' suggestions. Your ideas have made Reporting Services (SSRS) more effective.At...

T-SQL is an extension of the SQL language that is used in Microsoft SQL Server. This section contains materials for learning Microsoft SQL Server and T-SQL language. This is one of my favorite...

Many are already familiar with SSRS, know what it is and how to use them, but also many do not know this MS SQL server component, so now let's get acquainted with SQL Server Reporting Services,...

SQL Azure Database is a cloud version of SQL Server developed by Microsoft specialists. SQL Azure product is very similar to the local version of SQL Server; it is a cloud relational database that...

In August 2010, Microsoft announced an updated line of SQL Server Migration Assistant products - free tools that accelerate and simplify the migration of various corporate DBMS to Microsoft SQL...

SQL Server 2019 - advanced security and compliance mechanisms, industry-leading performance, high availability and advanced analytics for all your data, and now support for working with large...

Microsoft SQL Server Express is a version of Microsoft SQL Server relational database management system, which is free for download, distribution and use. It contains a database specifically...

SQL Server Management Studio is a single universal environment for accessing, configuring and administering all MS SQL Server components, as well as for developing system components, editing...

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft Corporation. The main query language used is Transact-SQL, developed jointly by Microsoft and...

On December 13, 2017, Dell EMC announced that it is providing support for Dell EMC PowerEdge 14th generation servers in the Dell EMC Ready Bundle for Microsoft SQL Server and Dell EMC Microsoft...

Starting with Microsoft SQL Server 2008, by default the local administrators group is no longer added to SQL Server administrators during the installation, this can only be done manually.As a...