Had a great breakfast at Daley's in #Chicago by the Cottage Grove green line stop today.
| SMO is open source! | https://github.com/microsoft/sqlmanagementobjects |
| Golang version of sqlcmd | https://github.com/microsoft/go-sqlcmd |
David Shiflet
@shueybubbles@techhub.social
- 7 Followers
- 13 Following
- 32 Posts
Here for NBA/NFL and Microsoft Data Platform. he/him
Rocky Lhotka 🤘🖖#oss #sqlcmd tool written in #golang - very nice improvement over the old sqlcmd tool!
GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)
The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads) - GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (wi...
Hey #sqlserver #ssms users - anyone else nerding out over the new Output window content in version 19?
I have two performance tips for #sqlserver #SSMS users.
1. If you are working with a very busy database where backups or deletes are holding locks and SSMS can't expand OE nodes or open property sheets, use this registry hack to put SMO queries in Read Uncommitted mode. https://guibubbles.wordpress.com/2017/06/05/ssms-and-smo-query-isolation/
2. When opening Object Explorer to an Azure SQL Database instance as a non-admin user is taking a long time, set your "Connection Timeout" value to a small number like 10 or even 5 seconds. This will cause some background connections to fail more quickly and unblock the real work.
Bill FellowsHear me out on this one. #SSMS #SSMS19
Checking for open transaction before closing query windows is helpful for terrestrial installations of SQL Server.
Checking Azure DB/MI for open transactions, so very not helpful. (Not helpful because of the blocking window per tab that takes 15 seconds to feels like forever to check which is bad for people like me who have easily 30+ open tabs at a time)
So, why not both?
An underreported aspect of a cross country move - dairy product flavors (particularly cow milk) vary enough from region to region that it's noticeable in lattes. I'm now adjusting to #Chicago milk as I had to 7 years ago after the move to South Carolina.
We're in Elmhurst for the next month+ before our #Chicago move. There are lots of food choices within a short walk. Two Brothers from Italy has great pasta. Egg Harbor Cafe served up a great omelet. Cupcakes from Cosmic Cakes are super tasty and Hello Donut is top notch. What should we try next? Whose pizza tops the bill?
I cringe every time a dishwasher soap ad shows someone removing their cookware from a dishwasher. Hand wash that pot!
Bob PusateriI was today old when I learned #SSMS has an option to suppress the save dialog that pops up each time you try to close a query tab.
#SSMS users looking for support - you can help us help you by clicking the "Show details" button in the error dialog and sharing the full message. #sqlserver