Activity overview
Latest activity by paschott
Lots of good tips from Andy's session today. I'll have to review some of those and take some notes for future use. The cheat sheet will be quite helpful. / comments
Lots of good tips from Andy's session today. I'll have to review some of those and take some notes for future use. The cheat sheet will be quite helpful.
I enjoyed the DevOps/Remote Work session. Took me a little bit to get the right windows showing up. Didn't realize there was a "Chat" option until about 15 minutes in. Thought it was like other webinars where chat/questions went all together to comment. I'll need to go back and catch some of the other sessions from today on the replay. There were a couple of others that looked interesting. / comments
I enjoyed the DevOps/Remote Work session. Took me a little bit to get the right windows showing up. Didn't realize there was a "Chat" option until about 15 minutes in. Thought it was like other web...
Azure SQL Monitoring - suppress DTU/IO warnings during index/stats maintenance?
We have a couple of Azure Runbooks that fire a couple of times during the day. These are to update the stats and maintain indexes. We run the stats updates during the day and index maintenance at n...
Possible to install web piece in Azure WebApp?
Seems like this should be possible, but can't find any details about this in the docs or forums. Ideally, we'd like to spin up a web app to host the Web View for SQL Monitor. That would allow us to...
In this case - just over 30s of query time that is timed out when the query normally runs subsecond. There are a handful that do that and some logins we'd likely exclude that only do maintenance or ETL loads or the like. So - kind of a long-running query, but a little different. I wouldn't want to pick up someone running an ad-hoc query, just long-running queries from a specific account. Ideally then only when it's a certain number of long-running queries within a given time range. / comments
In this case - just over 30s of query time that is timed out when the query normally runs subsecond. There are a handful that do that and some logins we'd likely exclude that only do maintenance or...
Possible to monitor excessive timeouts?
We have a couple of apps that irregularly, but often enough to be problematic, start suffering from timeouts. Is there an easy way to get alerted for those cases when queries start timing out?
So was this fix not included in build 2247? I don't seem to have auto-complete working with the same scenario - SSMS 17.2, SQL Prompt v8 build 2247, Azure AD Universal w/ MFA. / comments
So was this fix not included in build 2247? I don't seem to have auto-complete working with the same scenario - SSMS 17.2, SQL Prompt v8 build 2247, Azure AD Universal w/ MFA.
INSERT - SELECT formatting issues w/ SQL Prompt 6.x
I'm trying to format my INSERT / SELECT code and when I use CTRL+K+Y, my SELECT statement gets indented under the INSERT like so:INSERT dbo.MyTable
( MyTableName
, Description
)
SEL...
Issue with declaring @pv for BLOB data in 10.4.8.62
I generated scripts for our databases that disable triggers and constraints before modifying data in the database. I noticed that for several of these scripts, there is a DECLARE @pv command at the...
BUG: EAP 3 w/ MERGE statements
I can't edit a stored proc that uses MERGE when using EAP3 against a SQL 2008 database using the SQL 2008R2 SSMS. I have to disconnect my query window in order to use SSMS without throwing a SQL P...