For Day 29 of this series, I am going to talk about some of the basic things that you should consider from a hardware perspective when you are trying to increase the basic resiliency and availability of an individual database server. These are some of the first steps you… Read more

I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can download the consolidated pdf file which contains all the 30 days blog post. Download the file from here

Read more

Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that we should also we try to follow following best practices. *Best practice is not always best. It may vary depends … Continue reading →

Read more

Today I had a bit of regret slap me in the face.  That face slap came from participation in a SQL Quiz on twitter that was hosted by Paul Randal (Blog | Twitter).  The questions being thrown out there were deep technical internals type of questions.  These weren’t… Read more

 

Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well known SQL Server Guru’s. Register for the event right now…Pack up your computer tomorrow morning and head over to UNF Campus at 8:00 AM tomorrow. You will get some awesome… Read more

SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s.  You can see this evidenced in many ways in the product.  A couple of the things that make me think this is the case boils down to two functions that are new in SQL… Read more

I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach a n00b T-SQL in 5 minutes. I can guarantee that after my five minute talk, you’ll be an expert in T-SQL to rival the best of the best, or your… Read more

Read more

So my sister called me the other day to tell me she has a message on her laptop that said she has a virus.  Those of us working in the IT industry know we are the one’s all our friends and relatives turn to when they have a computer issue.… 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:

• The Power of N (4/22/2010) – Viewing data in other character sets.
• What is the size of your index?

Read more

Day 29 Advance Security As discussed in earlier blog about “Security” Day 7. Continue on that we will discuss here -what all security features Powershell provides. How to use them. Security is good but securing the things without using is … Continue reading →

Read more

This error

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

occurs when the SQL SERVER instance, to which SSRS is pointed to, is down or a very silly mistake, the SSRS is not… Read more

I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South Carolina. Case in point: when I went to the grocery store on Wednesday, just about every cold and sinus product was completely sold out. So I've had a hard time… Read more

This is a little off topic:

Well Well, it’s the 29th April and all being well in about 2 hours from now the second in line to the throne will be getting married. Wherever you are in the world I’m sure the pictures will beamed straight to your TV. I… Read more

For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel desktop chipsets and Intel consumer level SSDs, and how they will work together. This technology is relevant for desktop systems initially, but will probably show up in laptop systems… Read more

Awesome news.  I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011.  I saw that they were opening up the presentation schedule a little bit to allow for remote presenters and I decided to give it a try.

I got an email notification yesterday that… Read more

If you've been considering registering for the first ever SQLRally May 11-13 in Orlando it's coming down to crunch time. We're less than two weeks away and there are only 3 days left to sign up for the 2 day portion of the conference at $349 - starting May 1… Read more

I’m reading Tim Ferriss’ “The Four Hour Work Week” (FHWW) right now, and it’s got me thinking about (among other things) clearing a lot of the “noise” out of my day.

I don’t need to work for 8 hours solid.  None of us can do that, anyway…we need… Read more

Read more

Many thanks to Microsoft SQL Server MVP Andy Leonard (blog | twitter) for conducting a series of interviews of prominent SQL Server types, including me.  The interview found here.

Read more