Question Is there a simple way to reconnect a query window that is “not connected” to the original connection that was used by that query without manually picking the server name needed? If I click the Connect button on the SQL Editor toolbar or right … [Read More]
Last week, SentryOne announced their new PAC Community Ambassador program. I’m incredibly excited to be part of this new program. PAC? Huh? SentryOne doesn’t fuel their monitoring software with power-pellets, the PAC is their Product Advisory Council. This is a group of their users and … [Read More]
Writing a good resume is hard. People will tell you lots of rules about what you should always or never do with your resume. Should you follow those rules? Are things different because of your industry/background/geography/niche? Should you be clever or classic? It depends™. There is … [Read More]
Question I have a two node sql server 2008 r2 cluster that we just did an OS upgrade from windows 2008 r2 to windows 2012 r2, the OS upgrade was done in place so the SQL Server Installation stayed in tack. The cluster role won’t … [Read More]
This morning, when I logged into Twitter, the tweet at the top of my timeline was from Shane O’Neill (blog|twitter). It was to his blog post, Shane, What’s wrong with DELETE EXISTS?. It’s not that unusual that Shane would talk to himself in the third … [Read More]
The latest malware to make the headlines is really interesting to me. It’s a ransomware worm called Petya. Ransomware is particularly interesting to me as a DBA, because DBAs are responsible for keeping data safe, and ransomware is specifically designed to destroy your data. I’m … [Read More]
UPDATE: Unfortunately, due to a change in plans, I’m not going to be at PASS Summit this year, so I won’t be hosting this meetup in 2017. Check out details here. Last year, I organized an (unofficial) PASS Summit LGBT Meetup. It was a bit … [Read More]
Question I am wondering if it is possible to split up a very large query to have parts of it done on the secondary read only servers, or If this feature only allows me to run separate queries or scripts on the secondary servers. I … [Read More]
Question I have created a table with 650 Numeric(19,4) columns. When I switch on Page Compression, by running I get Msg 1975, Level 16, State 1Index ‘PK_Mytable’ row length exceeds the maximum permissible length of ‘8060’ bytes. but 650 times 9 bytes is only 5850 … [Read More]
Question I have a vendor solution that uses a sql server (2008r2) database. We are allowed to do anything we want in our own schema, but cannot modify dbo objects without vendor permission. Any customization we make is in our own schema (cust). We have … [Read More]
Copyright © 2025 | Andy Mallon | am2.co