Category Archives: SSMS
-
SSMS Put pinned tabs in their own row
2July 21, 2022 by Kenneth Fisher
A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that …
Continue reading -
I’m writing a SQL Server security presentation and I need your help.
5February 24, 2022 by Kenneth Fisher
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going …
Continue reading -
Help, not all of my column is displaying in the output of the query!
1February 22, 2022 by Kenneth Fisher
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we …
Continue reading -
Creating a configurable SSMS script
1May 18, 2021 by Kenneth Fisher
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
Continue reading -
What is (local)?
Leave a commentApril 27, 2020 by Kenneth Fisher
When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
Continue reading -
Change the size of the grid results view in SSMS
1March 4, 2020 by Kenneth Fisher
After my post last month about configuring your tools I’ve been on a make my life easier kick and one …
Continue reading -
Configure your tools : T-SQL Tuesday #123
5February 11, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing …
Continue reading -
What does the User Mapping tab of Login Properties really tell us.
6June 24, 2019 by Kenneth Fisher
In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, …
Continue reading -
A transport-level error has occurred when sending the request to the server.
4March 27, 2019 by Kenneth Fisher
Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not …
Continue reading -
What version of SQL is SSMS scripting for?
Leave a commentMarch 25, 2019 by Kenneth Fisher
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
Continue reading