So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.
A free day of training in paradise. Come to SQL Saturday in the islands on Apr 1, 2011.
Steve Jones thinks that security will be one of the biggest impediments to the adoption of cloud computing might be the security issues and hacking targets it provides.
How to rebuild your master database quickly and safely.
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
Many people deploy performance monitoring solutions in a "one-size-fits-all" manner. That is, they tend to build a solution that can be easily deployed to multiple servers and capture basic information from each server. The trouble is that not every server is identical, not even within the same shop. For example, not every server may have database mirroring deployed, which means your performance monitoring solution may be missing some critical pieces of information with regards to monitoring database mirroring.
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
SQL Saturday goes international on Feb 26, 2011. If you can attend, be sure you stop by.
Will you be a hybrid worker in your next job? Steve Jones notes that many of the new jobs that will be created in the future might involve hybrids.
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers