Tag: SQL Server Management Studio

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in October. This release features improved compatibility with previous versions of SQL Server and a stand-alone web installer.

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in October. This release features improved compatibility with previous versions of SQL Server and a stand-alone web installer.

In a recent post by Adam Machanic, he asked his followers to send him the items they thought were the worst features of SQL Server. The list he developed is called the “SQL Hall of Shame”. He put together the following list:

In-Memory OLTP

English Query

Data Quality Services (DQS)

Master Data Services (MDS)

Auto-Shrink

Auto-Close

Auto-Grow

Notification Services (SSNS)

Query Notifications

Buffer Pool Extension (BPE)

Management Data Warehouse (MDW) / Data Collector

Lightweight Pooling / Fiber Mode

JSON

SQL Server Management Studio (SSMS)

Connect to SSIS from SQL Server Management Studio

DROP DATABASE IF EXISTS

Columnsets (and Sparse Columns in general)

SQLCLR

Utility Control Point (UCP)

Raw Partitions

Uninstall

Service Broker (SSB)

Not Freeing Allocated Memory Except Under Pressure

Database Engine Tuning Advisor (née Index Tuning Wizard)

DBCC PINTABLE

Virtual Interface Adaptor (VIA) Network Protocols

Mirrored Backups

SQL_VARIANT

If you read the article by Adam Machanic, you’ll get the detail for each item on the list.

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in May. This release features improved compatibility with previous versions of SQL Server, a stand-alone web installer, and toast notifications within SSMS when new releases become available.

Any time you are doing a presentation in front of a group of people, you need to make sure they can see what you are doing. This is usually accomplished by projecting the image of your Windows desktop onto a large screen using a projector or television. The issue is Windows will often show that desktop image using the defined resolution for someone sitting a few feet away from the screen instead of someone who may be twenty feet of more away from the image.

The solution of this issue is to adjust the Windows resolution to allow of this issue, but some products don’t deal well with the changes, like the SQL Server Management Studio (SSMS). In this article by John Paul Cook we learn a little about how to manually adjust the display settings inside of SSMS to make the images a little easier to read.

There is also a brief mention of the free Microsoft ZoomIt utility. I use the built-in Magnifier utility in Windows 10. This utility uses simple shortcuts to make life simple:

Windows (logo) key & Plus (+) key: This combination zooms the screen.

Ctrl & Alt & F: Shows full-screen view.

Ctrl & Alt & L: Shows the lens view.

Windows (logo) key & Esc: Exits utility and returns to normal

I have done several presentations, usually to a technical crowd, and I can never get the display anywhere close to “perfect” for displaying the details I want to show. I resort to a practiced routine of zooming into my Transact-SQL text, in-zooming and re-zooming to the next part of the screen I want them to look at, then using ALT-Tab to switch to a different application, etc. It doesn’t matter, in my opinion, what you do as long as the final impression of the presentation is meaningful to the observer.

My focus it making sure the crowd learns what I’m trying to teach and they understand what I did (and how I did it) to get the same results I showed during the presentation. I’m careful to make sure, by practicing ahead of the actual event, that everyone will be able to see the presentation clearly. I also make sure the switching between in-zoomed and zoomed doesn’t confuse the observer.

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest preview of SQL Server Management Studio (SSMS) using build number 13.0.16000.28.

Get it here:

Download – The version number for the latest preview is 13.0.16000.28 (16.5)

New in this release

Fixed an issue where a crash could occur when a database with table name containing “;:” was clicked on.

Fixed an issue where changes made to the Model page in AS Tabular Database Properties window would script out the original definition. Microsoft Connect Item: 3080744

Fixed the issue that user is not able to set the font size for object explorer, registered server explorer, template explorer as well as object explorer details. Font for the explorers will be using the Environment font.
Microsoft Connect Item: 691432

Fixed the issue that SSMS always reconnect to the default database when connection is lost.
Microsoft Connect Item: 3102337

Fixed many of high dpi issues in policy management and query editor window including the execution plan icons.

Fixed the issue that option to config font and color for Extended Event is missing.

Fixed the issue of SSMS crashes that occur when closing the application or when it is trying to show the error dialog.