Archives: November 2009
I haven’t worked out how to incorporate this blog into my website yet (www.gre-sqlserver-solutions.com) but when I do hopefully the…
Do you know that there are actually two branches of SQL Server 2008 code right now? Actually I would bet there are 3 branches, but we have two publically available branches to choose from:
- The RTM branch
- The Service Pack 1 branch
I’ve known this for awhile, but haven’t thought… Read more
I’m fond of browsing the discount shelf at the bookstore, it’s another way to see books that I might otherwise miss, tending to spend my time around the business and computer section. I found Let’s Create for a mere $2.99 and decided to get it, nothing makes for good family… Read more
For those of you who are not familiar with Ola’s database maintenance scripts, they are designed to help you backup, optimize indexes, and perform integrity checks on… Read more
If your not interested in speaking, but would like to attend the event, PASS… Read more
I’d like to say thanks to Andy and Judith over at the Ft. Worth SQL Server User Group for having me as a guest last Wednesday. I got to meet a few new people, and meet up with several others whom I hadn’t seen in a while. I look forward… Read more
If all goes well, by the time you read this on Thanksgiving I’ll be up in the mountains of Colorado. No SQL Server questions to answer, no editorials to write, no articles to edit.
I think I say it often, but it bears some repeating. Get away from your day… Read more
I know Thanksgiving has some deeper meanings, but at one level it’s all about the food. Food is a good way to celebrate family, having foods that you all enjoy and evoke good memories. However, cooking all that food isn’t always simple and is often stressful. Some years we’ve opted… Read more
Just as an FYI, I’ve added one new slide deck and webcast to http://KevinEKline.com/Slides/, as well as quite a few upcoming user group events where I’m speaking in http://KevinEKline/Upcoming-Events/.
I’m starting a new series called Sequels for SQL Server. In this series, I point you to sites… Read more
It is said that you should not give direct table access (even select permission) to a user or group. But with the new ORM tools like N-Hybernate what do we do? N-Hybrbate is not designed for Stored Proc access. They are not even planning to have Stored proc support. So… Read more
I had to run our weekly conference call this week. My boss is out of the office, but he’s been trying to get everyone to participate by having different people run meetings on different weeks. I’m not the best employee in this sense, and not always prepared, so I’ve tried… Read more
I have noticed that one of the best way to learn about a certain topic is to write an article regarding it. When you do write an article, it forces you to do some research, read lots of documents and then try it out. You do not want to give… Read more
I saw a post recently about the tempdb being overly large and causing issues for a user. The person was having issues shrinking the files and wasn’t sure what to do. Someone else responded that snapshot isolation might be an issue and I found that interesting. I hadn’t thought about… Read more
I'm looking over the comments about DBAs and local Administrator rights and I noticed an interesting trend: no one discussed the separation of duties aspect. Basically the comments that were returned either said, "DBAs should have that knowledge," or "You can't do the job without it because..." so let's took a… Read more
6 comments, 1,784 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2009
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server.
I have added several new queries this time, and tweaked… Read more
Earlier this week I posted Part 1 and Part 2, today I want to wrap up by thinking about how to handle success and judging success. I think that’s important, because I’m advocating that you (and me) put some extra effort into something that is speculative. No guarantees you help… Read more
Virtually all successful DBAs I know put a lot of focus on education, and the best way to make it happen is to create your own professional development plan for the new year. This way, you will be better able to find time (and resources) to accomplish your learning goals. Read more
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries? Should we tremble with horror at the sight of a hash join?
Well, it depends.
There’s no single join type that’s best in every scenario and there’s no join type… Read more
I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in the Bittersweet Blues of Life, and reading of the kind of schedule Wynton Marsalis' father, Ellis kept in order to feed his family and teach the next generation of… Read more
1 comments, 590 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 November 2009
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass tables as parameters to stored procedures. You cannot pass a variable table or temp table, you can only pass a Table Type, which is an alias data type or a…