Archives: September 2011
I am sure many times we all might have come across situations where we need to search/find a string value in all the string columns of a given table/view in SQL Server and return the matching rows from that table.
Unfortunately, we do not have any straight forward… Read more
Many of you know recently the PASS board announced that elections will be coming up for three seats on the board for the upcoming term. I believe that the board has come a long way thanks to the efforts of some key individuals. Even so, I believe we have more… Read more
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms built into SQL Server Analysis Services gives you this power.
The Adventure works data base comes with views that are already set up to perform data mining. Let’s take a… Read more
Truck is loaded up and heading to the airport to make an appearance at SQL Saturday #97 in Austin TX with some awesome speakers. Wish me luck, when I leave Austin I hope that many more TempDB’s are optimized.
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized. These appliances include all the hardware, software and services for a complete, ready-to-run,… Read more
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are:
Related posts:Read more
Just a reminder that there are a few seats left for SQL In The City: LA on the 29th of October. It’s a free event put on by Red Gate Software. I’ll be speaking there. But much better than that, you can listen to, and interact with, Steve Jones,… Read more
Quick update for all of you!
Hey there everyone! We are going to have some awesome surprises, new software features and the hottest nerds at the event in our booth at PASS! Make sure to stop by and check us out. Come say hi, get a hug, see an awesome… Read more
So I am really close to Atlanta geographically, but I?m never there. I?m going to change that after this SQL Saturday. I flew in the morning of, broke several well intentioned speed laws on my way to the event and got there in time to help our sales Engineer Brad… Read more
I love wearing all my SQL Saturday speaker shirts. Here lately the trend has been nice golf or running shirts which look great with a pair of slacks. Today I work my speaker shirt from SQL Saturday #81 (Birmingham AL). I was shopping this evening at a local supermarket when… Read more
We've got a great few months ahead of us with our buddies at the BR .net User Group!
October's meeting is on the topic of Change Data Capture (CDC) as…
Wow! Can't believe today is the last day of September! Fall, here we come! Although Summer is over, Autumn is truly an exciting and good time to be a SQL Server Professional! So many great events coming up soon, especially the summits of all summits - PASS, the largest SQL Server and… Read more
Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles, CA on October 28, 2011. It will be held at the Skirball Cultural Centre in the Santa Monica Mountains, just outside of Los Angeles.
The event will provide six hours… Read more
Two years ago when SQL Server MVP Deep Dives: Volume 1 was released, I had the opportunity to contribute two chapters. In SQL Server MVP Deep Dives Volume 2, I not only had the opportunity to contribute a chapter, but the privilege of being the section editor of the Performance… Read more
Presentation Files: 10 Things All BI Administrators Should Know
I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from… Read more
0 comments, 1,149 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 September 2011
Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday. It has been a lot of fun, so thank you to everyone who has come out and hopefully learned something from one of the sessions I have done. So,… Read more
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing SQL Server using PowerShell
PowerShell is ubiquitous in Windows now and can be used to view and manage any part of the Windows systems, it uses the .NET framework… Read more
I have spent about 1 hour a day reviewing what I have selected for the week with the really cool Build Your Schedule for Summit 2011.
Sunday Oct 9th is…
As I have announced in all of my sessions last week in Budapest at the SolidQ summit, you can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions J
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays conference can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions J