It Server

Universal IT Server

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? SSMA for Oracle now…

In my previous blog post, I briefly talked about smart transaction log backup, monitoring and diagnostics along with other community driven improvements we released in SQL Server 2017 CTP 2.0. In this blog post we will go deep into a new DMF sys.dm_db_log_stats which we released in SQL Server 2017 CTP 2.1 that will enable…

In my previous post on Easy way to get statistics histogram programmatically, I referred to statistics as the building blocks on which the Query Optimizer reasons to compile a good enough plan to resolve queries. Knowing the status of distribution statistics over a given table and set of columns allows the user to have insight…

Today at //BUILD, Microsoft announced a limited preview of the Azure Database Migration Service which will streamline the process for migrating on-premises databases to Azure. Using this new database migration service simplifies the migration of existing on-premises SQL Server, Oracle, and MySQL databases to Azure, whether your target database is Azure SQL Database, Azure SQL…

The community already uses tools that can make it easier to read and analyze query plans (including SSMS), but these require significant expertise in understanding query processing and plans in order to be able to actually find and fix root causes. In the latest version of SSMS that released last week, we debut a new…

There are many instances in SQL Server management where one person would like to find all the TCP ports that SQL Server is binding to. Finding all the TCP ports that SQL Server is listening on might be for security related auditing, connectivity troubleshooting, or for some form of automation. One such example is used…

While SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, adaptive query processing and resumable online indexing…

I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the talk, I opened up the floor for the audience to ask me questions. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. When I run the…

This past week SQL Server Tiger Team delivered a webinar session for the HADR PASS virtual chapter. During the session, I talked about some of the enhancements which were introduced in SQL Server 2016 and SQL Server 2016 Service Pack 1. The enhancements which I covered during the session fall in three broad categories Fundamental…

In my previous blog post, I shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the SQL…

NavePoint Navepoint 9U Deluxe IT Wallmount Cabinet Enclosure 19-Inch Server Network Rack With Locking Glass Door 16-Inches Deep Black
Speakers (NavePoint)
  • Dimensions: 20 H x 24 W x 18 D
  • Fits Standard 19 rack-mount equipment
  • Maximum rail depth of 13 . Total Usable Space of 16 front to back.
  • Removable side panels for easy access.
  • Top and Bottom open brackets for cable and wire access. Cage Nut kit included.

Related posts: