This is about a long term goal that I’ve had which isn’t posted on here, and that’s to eventually be a technical trainer in some capacity. The fact of the matter is I love to teach. I learned that when as a…
Archives: September 2009
create table MyTable (id int)
Create Table #Test (id int)
create proc MyProc
insert MyTable select @id
insert #test select @id
exec MyProc 2
select * from #test
drop table MyTable
drop procedure MyProc
I saw a question recently about temp… Read more
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production. Sales teams seem to insist on selling features and timelines without asking if it’s even close to possible, and operations wants to solve problems elegantly without regard to the realities… Read more
OK, there was something that Microsoft did to tick me off. SQL Server 2005 introduced us to so many exciting and useful DMVs, such as sys.dm_os_sys_info. This DMV, which would give us a set of useful information about the computer, and about the resources available to and… Read more
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008)… Read more
I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a great idea, one that I'd like to have working in my house, but it's not as simple as having a storage tank and a solar panel.
To me this… Read more
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going to charity. The book consists of over 50 chapters, each on a different SQL-Server related topic, from database architecture through development administration, database development, performance tuning and even Business Intelligence.… Read more
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9 different cities. I began my journey from my home, on the Big Island of Hawaii at 9:30 AM on Saturday, and arrived in Sydney at 8:30 PM on Sunday. Hawaii… Read more
If you are available for lunch today don’t forget to sign in and watch Thomas LeBlanc talk about Historical DMV information. To attend the meeting use this URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend. Also, if you would like to receive notifications about upcoming SQL Lunches register here: http://www.tsqlscripts.com/SQLLunch.aspx.
See you at Lunch Read more
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading to a newer version or adding a new server to a scale-out deployment. In some cases there have been consistencies, but in many these differences vary. These variances may have… Read more
I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I avoided the computer. I let both the desktop and laptop remain at idle, not even checking personal email until Sun night.
When I checked Sun night, I saw a newsletter… Read more
It seems that often I see posts that say “I’m out of space on my drive, what do I do?” The answer, as with most anything in SQL Server is, it depends.
The most common issue I see for running out of space is the lack of deleting database… Read more
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9 different cities. I began my journey from my home, on the Big Island of Hawaii at 9:30 AM on Saturday, and arrived in Sydney at 8:30 PM on Sunday.… Read more
I saw this post by Neil Davidson about sales people being different that discusses how sales people are compensated and why he is moving to a salary model instead of commission. I’ve never been a sales person, but I’ve had the interesting time of working with them at a mid… Read more
I was asked recently by Chris Shaw who is the site manager for SSWUG.org, if I was interested in speaking at the upcoming vConference. I was thrilled to have been asked as I've been wanting to do more community activities. I went out to the speakers list and my… Read more
2 comments, 371 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 September 2009
I just realized that blogs will soon be obsolete artifacts. Let me explain why:
- For over 10 thousand years “writing, painting and talking” have been the most basic communication tools we use to describe our lives. In the early computing days storage was very limited; I remember tools like…
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest starting school this year, it was time to add another computer to our inventory. Since my son’s computer needs are relatively minimal at this point, I decided to buy a… Read more
There was a time when health information was merely a collection of facts about you. You visited a doctor on the 17th because of a sore throat. You had your appendix removed when you were a grade-schooler.
Now, in the 21st century, information is increasingly used to drive business value.… Read more
Gail Shaw, who is a SQL MVP from South Africa, has an excellent blog post about this subject.
The executive summary is that having lots of conditional logic in a stored procedure tends to confuse the SQL query optimizer and it often causes problems with parameter sniffing. Parameter sniffing is…
Time: 11:30 AM
Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and… Read more