SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2011

A SQL Server Hardware Nugget A Day – Day 29

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

0 comments, 1,368 reads

Posted in Glenn Berry's SQL Server Performance on 30 April 2011

Download: Powershell a Day -April 2011

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

2 comments, 1,519 reads

Posted in Vinay Thakur on 30 April 2011

Powershell Day 30

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

0 comments, 1,428 reads

Posted in Vinay Thakur on 30 April 2011

Seize the Moment

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

1 comments, 1,346 reads

Posted in SQL RNNR on 29 April 2011

SQL Saturday 74 Is Here! Register Now! Show Up Tomorrow!


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

0 comments, 1,446 reads

Posted in BrianKMcDonald on 29 April 2011

Physical Row Location

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

0 comments, 3,201 reads

Posted in SQL RNNR on 29 April 2011

Learn T-SQL in 5 Minutes

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

0 comments, 2,161 reads

Posted in SQL Awesomesauce on 29 April 2011

Business Intelligence Careers SearchSQLServer.com Interview

I had a very interesting conversation recently with a good friend of mine.  She’s at the top of her game as a first class enterprise DBA in a major medical institution.  She was interested in my career advice because she’d recently received an unsolicited invitation for a higher paying job…

Read more

0 comments, 1,433 reads

Posted in Kevin E. Kline on 29 April 2011

Antivirus solutions that are free

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

0 comments, 1,619 reads

Posted in James Serra's Blog on 29 April 2011

Re-blog – April 22-28

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:

Read more

0 comments, 1,429 reads

Posted in StrateSQL on 29 April 2011

Powershell Day 29

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

0 comments, 1,421 reads

Posted in Vinay Thakur on 29 April 2011

SSRS Error: A connection to the database is required for all requests and processing

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

1 comments, 19,891 reads

Posted in What I Learnt @ Work on 29 April 2011

Love What You Do

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

A Royal Wedding: A Day Off

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

2 comments, 1,503 reads

Posted in The SQL DBA in the UK on 29 April 2011

A SQL Server Hardware Nugget A Day – Day 28

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

0 comments, 1,615 reads

Posted in Glenn Berry's SQL Server Performance on 28 April 2011

SQLSat 83 – Johannesburg

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

5 comments, 1,694 reads

Posted in SQL RNNR on 28 April 2011

3 Days Remaining Before The Next SQLRally Price Increase

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

0 comments, 1,575 reads

Posted in Kendal Van Dyke on 28 April 2011

Drop the Noise

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

0 comments, 1,427 reads

Posted in SQL Awesomesauce on 28 April 2011

DBA relationships – The data custodian


As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right people have the right access to the right information is an extremely large part of our jobs – at least it is for me any way.

I’m pretty sure…

Read more

0 comments, 2,226 reads

Posted in measure twice, cut once. on 28 April 2011

SQL People Interview

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.




More content at http://KevinEKline.com

Read more

0 comments, 1,605 reads

Posted in Kevin E. Kline on 28 April 2011

Older posts