Archives: July 2011
Someone recently asked me if I would work for a company if I didn’t believe in their products or services (to the point that I would consider them the best). It’s an interesting question because it reflects the trade offs many of us make when selecting jobs, and there is… Read more
This is part of a series of tips on how bad/rogue admins can get access to the data in your SQL Servers.
We all know we shouldn't do it: don't put production data in non-production. The main reason is because we don't treat non-production like production. If we did, we'd… Read more
4 comments, 697 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 July 2011
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to fetch the first matching value from the other DataSet. Now, what if we want all the matching values from the other DataSet. Here, the LookupSet() function comes handy.… Read more
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the tables in case I need to re-create them. This is usually the case in a development environment when I’m building a database. So in Object Explorer I click on the… Read more
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak at. So far I have spoken in Tampa FL, Columbia SC, Jacksonville FL and Pensacola FL. I still get nervous getting up in front of some many people to speak,… Read more
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works consultants walking you through how to develop a full business… Read more
Every year Redgate has a competition to find the most exceptional DBA of the year. This year too they are conducting. One of the prize for the winner is a fully paid Sql pass summit. The best thing about this is that it is the community that votes for the… Read more
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a great market being we are Atlanta GA. Locating a venue to hold the event presented a few challenges but again we are a large area so there are several venue… Read more
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses when someone asked ‘How do you search for a wild card character when using a LIKE based WHERE clause fro string comparisons. I must have looked stumped for a minute… Read more
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of days ago, I thought I would run CrystalDiskMark on a couple of different models in that line, along with a couple of other drives I had easy access to.… Read more
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development. This is my second book.
While this is a book review, the first thin you need to know is that the Strengths Finder 2.0 book is actually just a written,… Read more
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP Linchi Shea will give a presentation and practical application on SQL Server 2008's Audit Feature. Come to take a close look at the SQL Server 2008 server audit feature!
Don't be misled… Read more
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is also another method which is not exact but is way faster especially when you are expecting zillion of rows to be counted. This method is based on fact that SQL… Read more
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even the loss of a key person or a parallel business crisis. For smaller projects it’s just x percent of slack time that can be used as needed. You do what… Read more
A few days ago I had an interesting conversation on Twitter about my upcoming speaking engagements. I really realized at this time that I have a lot of different SQL Server conferences in my pipeline where I'm speaking over the next months. Here are the conferences where you can meet… Read more
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While seeing lots of blog post on pre/post SQLSaturday events, I am bit curious to know is there any active SQL Server user group in Chennai so that I can be part of it. Read more
Recently I had to create a simple query to lookup a single row in a table containing ranges that do not overlap. Consider this table design and example data:
CREATE TABLE MyRanges ( id INT IDENTITY(1,1) PRIMARY KEY, RangeFrom INT NOT NULL, RangeTo INT…
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are the specifications of the four models that the story describes:
Opteron 6220 8 cores, 3.0GHz base clock speed, Turbo CORE to 3.5GHz
Opteron 6234 12 cores, 2.4GHz base clock speed,…
I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that they needed a speaker and would love to have me talk about SSRS. Since I have given SSRS presentations for the past two years, I should be able to whip… Read more
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using Posh. It started out just moving folders based on the folder name that included the date in format MMDDYY. Next was having to stop services before moving the folders. After… Read more