Archives: January 2011
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate creating scripts for all your databases at once. What’s the first thing that popped into my head? Yep, Powershell.
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we had not yet sent out an official request. That email has now gone out the door. Here it is for those who might be interested in presenting. Please consider this… Read more
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a great relationship, a fantastic friendship. Look, it’s not you, it’s me. I want more. I want to take our relationship to the next level.
That’s why I’m excited as can… Read more
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or, it even reinforces bad decisions. Regardless of the purpose, the means by which these changes are implemented when they involve taking things away is deprecation. Usually in SQL Server the… Read more
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central. I know it pops up at least once a week on Ask SSC. I’m sure I’ve seen it on Twitter #sqlhelp. “Why is my log file growing?” and… Read more
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some great idea and then it all goes south. For example, I was going to explain the difference between a table/heap scan and a clustered index scan. The problem was, I… Read more
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown (blog|twitter) of SQLawesomesauce, is Resolutions. In particular, Techie Resolutions. I have to do this because Jen just received her MVP award, in case you’ve been… Read more
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I did get that question during my DMO presentation at the PASS Summit. I did not have an answer. I did get an answer from Johan Biknens (twitter) from… Read more
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began about 10 years ago, but this SeV Revolution Jacket is just getting started! This jacket has a silky lining and all of the features you've come to expect from…
Temporary Post Used For Theme Detection (7152665d-114f-4469-a816-6ca6880e832a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (95b57a7c-aa49-471e-a63c-76ea6775d1d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)