SQL Server Posts
Configure SQL diagnostic manager for non-standard ports
SQL Server uses the port 1433 as its standard listening port. Hackers know this and will use it to more easily hack into your SQL environment. Because of this, many DBAs will choose to not use the standard SQL port of 1433 for their SQL environment and will change the port to a ‘non-standard’ port. [...]
Why Back Up the Transaction Log if not Interested in Point-in-time Restore?
I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database because they do not care about point-in-time (PiT) restores. However, PiT restores are not the only reason to use full-recovery model nor is it the only reason to back up the transaction [...]
Plan Your SharePoint Farm Right with a SQL Server Alias
I was speaking at SPTechCon San Francisco earlier this month, and the topic of SQL Server aliases came up during Q&A towards the end of a half-day tutorial I was delivering. I’m glad I was able to spend a few minutes talking about the topic and its importance, but after thinking about the questions that [...]
Critical Release from Microsoft on SharePoint Security Vulnerability
On March 12, Microsoft released information about some critical vulnerabilities in SharePoint 2010 that could allow users to elevate their privileges using a specially made URL. Microsoft’s position is that customers who take advantage of automatic updates probably won’t need to do anything at all. Well, I know I can speak for most of us [...]
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t a surprise you get on production, as this is something easy to monitor (both database size and disk space are monitored by default with SQL diagnostic manager). But in other environments where [...]
SharePoint Posts
Configure SQL diagnostic manager for non-standard ports
SQL Server uses the port 1433 as its standard listening port. Hackers know this and will use it to more easily hack into your SQL environment. Because of this, many DBAs will choose to not use the standard SQL port of 1433 for their SQL environment and will change the port to a ‘non-standard’ port. [...]
Why Back Up the Transaction Log if not Interested in Point-in-time Restore?
I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database because they do not care about point-in-time (PiT) restores. However, PiT restores are not the only reason to use full-recovery model nor is it the only reason to back up the transaction [...]
Plan Your SharePoint Farm Right with a SQL Server Alias
I was speaking at SPTechCon San Francisco earlier this month, and the topic of SQL Server aliases came up during Q&A towards the end of a half-day tutorial I was delivering. I’m glad I was able to spend a few minutes talking about the topic and its importance, but after thinking about the questions that [...]
Critical Release from Microsoft on SharePoint Security Vulnerability
On March 12, Microsoft released information about some critical vulnerabilities in SharePoint 2010 that could allow users to elevate their privileges using a specially made URL. Microsoft’s position is that customers who take advantage of automatic updates probably won’t need to do anything at all. Well, I know I can speak for most of us [...]
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t a surprise you get on production, as this is something easy to monitor (both database size and disk space are monitored by default with SQL diagnostic manager). But in other environments where [...]