Archives: January 2013
Are you a Technical Expert or a Manager? You certainly cannot be both.
At least that’s the consensus that I frequently encounter. A belief that you can only be one or the other but definitely not both.
This is outdated thinking. It sounds to… Read more
1) Open Installation Wizard
2) Select Feature You want to install
3) Provide installation configuration
4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the… Read more
4 comments, 959 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 January 2013
I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users.
It’s not a weird edge case, but it’s just not one I’ve normally… Read more
here is the script.
Before we start on the main part of the interview, tell us all a little about yourself.
I’m married to Jonathan Allen… Read more
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.
Last week’s top 10 “Reading” Links
Last month I mentioned that I’d like to start including Oracle stuff on this blog. I’m getting back into that world again as part of the new job, and this blog has always been, first and foremost, a way for me to document and share what I’m learning. Now I… Read more
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it. It takes practice and more practice, listening deeply to what the other side says and doesn’t say, and looking inward to separate pride from what matters. That led, for me,… Read more
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins, msdb is jobs and backups, tempdb is for temp tables and sorting. Obviously there is a lot more to each of these, but that is the absolute basics, and… Read more
There are many factors that need to be taken into consideration and it would be nice to do a…
Friends, As covered in one of my previous blog:
We were discussing about ifilters , so How to get these ifilters and what are the various steps need to be taken in the configuration of ifilters? I will work with… Read more
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's time to expand to the unlikely ones. This is true even if the evidence would seem to rule out a possibility or if what you have for facts seem to… Read more
1 comments, 1,033 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 January 2013
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the Leaves function in MDX). I documented the implementation in a few blog posts:
I have now also implemented currency… Read more
The DBCC Commands are used in Maintenance, Informational use, Validation on a database, index, or file group. Theses commands are helpful to check physical and logical consistency of database. Some DBCC statements fix errors automatically. Here I am showing…
The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single publisher replicating to one or more subscribers. Another replication model, which is sometimes overlooked, is the Central Subscriber model, which is comprised of multiple publishers replicating to one subscriber using… Read more
I was catching up on reading today and saw that Instructables had a how-to on “tattooing” a banana, also called banana oxidation art. I had bananas available, so I printed SQLSaturday on some paper, taped it to the banana, and starting punching holes with a straight pin. It… Read more
3 comments, 911 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 27 January 2013