Archives: February 2010
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew.
The database that the test was being run on was 360GB in size. The backup initially created… Read more
In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude, Your Fly Is Open”, a lighthearted look at when and how to point out the mistakes of others. You can find it here: http://www.sqlservercentral.com/articles/Editorial/69482/. Read more
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with various teams it was decided that the best way to achieve this whilst minimising disruption was to build a fresh server with a new name and a fresh SQL Server… Read more
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and I’m doing two presentations this time, and as usually SQLShare is sponsoring the speaker event on Friday night. It’s a huge event, typically about 600 attendees, and well worth… Read more
Hey gang ! I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis Services Cube to and I’m going to show you how we can make it useful for reporting in short amount of time. We currently have over 800 folks for…
Hey gang !
I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis Services Cube to and I’m going to show you how we can make it useful for reporting in short amount of time. We currently have over 800 folks for…Read more
“It’s easier to be smart than good.”
I heard that quote in a recent sermon at church and it is one I can very much relate to in more than one area of my life. In context the pastor was discussing the difference between knowing what the Bible says (being… Read more
SQL Server Training is out there in all sorts of formats, price points and quality. It's time to look at the quality part.
About a week ago I wrote Part 1, and got some interesting feedback (which I appreciate). Today I want to try to think about some of those comments and try to evolve the idea some. I want to defend my ideas a little, but not sink into defensiveness. I… Read more
I used to subscribe to Bruce’s monthly Cryp-o-gram and enjoyed it. He’s moved to a blog format, and I think that the content suffers a bit as he pushes things out quicker, but he’s still a great read.
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It was a painful experience, for my son as well as myself – but for different reasons. He was playing on the monkey bars, lost his grip and fell. A natural… Read more
I recently had a SQL Server DBA write to me that they were going to be laid off, and they asked me if I had any special insight into what are the best websites to look for SQL Server-related jobs. I haven’t looked for a SQL Server job in a… Read more
If you’ve ever dealt with a manager who questioned your every move, hijacked… Read more
I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job).
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads presentation at the Rocky Mountain Tech Trifecta event… Read more
Mr. Exceptional DBA is coming to our SQL Lunch. Patrick and I are excited to welcome Brad MCGehee to SQLLunch.com. "No Fluff Just Stuff " for a presentation on being an exceptional DBA. Brad is always a crowd pleaser so make sure you get on and check it out! Read more
I’m presenting tomorrow on Zero to Cube in 60 minutes. This is an all Demo Session for work with cubes and putting data in a form that can be analyzed and reported on quickly and efficiently through SQL Server Analysis Services. Come check it out at http://pragmaticworks.com/resources/webinars/February2010Webinar.aspx. Brian Knight… Read more
Hey Guys and Gals ! If you missed the webinars today, you missed a great show! Brian took us through the fundamentals of SSIS and getting started with this exciting product. SSIS is such a powerful tool, not just for ETL and data warehousing, but for environment management, workflow processing…
Hey Guys and Gals ! If you missed the webinars today, you missed a great show! Brian took us through the fundamentals of SSIS and getting started with this exciting product. SSIS is such a powerful tool, not just for ETL and data warehousing, but for environment management, workflow processing…Read more
Any DBA who really understands databases and SQL standards can make out with other RDBMSs quite well, and if they have not tried yet, I recommend it for the reasons I shall discuss below.
Specialists maintain, with reason, that you cannot be a Master/Mistress of multiple database management systems. Read more
There are a few ways to get data from a client to your system; FTP or email. Internally we tend to use email for two reasons: everyone has it and it provides an audit trail (I know who sent what and when). The corporate email standard is MS Outlook, which… Read more
Notice I didn't title this "Plan to Fail." We should never plan to fail. That's sabotage. And that ain't right, as we say in the South.
However, when we do our planning, it is an unrealistic expectation for everything to work every time, especially when it comes to IT. Our… Read more
0 comments, 704 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 February 2010
If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL Server MVP, will be presenting an Introduction to Graphical Execution Plans. Brad has over 15 years of SQL Server Experience and over 6 years of training.