I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but very few for removing or undoing it.  So I thought I would cover a few ways to accomplish this while still preserving the data.

Read more

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

It’s day 23 of my 31 Days of Disaster Recovery series, and today’s blog post is inspired from an email i received in response to day 20′s blog post The Case of the Backups That Wouldn’t Restore. A friend shared a story with me via email about a partial restore…

Read more

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

"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some case.Today when I tested script, I found the index created on the temp table didn't work because of "Auto update statistics" disabled.

here is the script.

USE [master]
GO
ALTER…

Read more

Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be really hectic. I really do appreciate your time!

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

1. The Other Person is Never…

Read more

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

Read more

Friends, As covered in one of my previous blog:

How crawl works in SharePoint ||How indexing work||Basic concept .

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

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:

• Currency Conversion Using Measure Expressions 
• Currency Conversion Using MDX Leaves Function

I have now also implemented currency… Read more

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

The end of the day is quickly approaching as I finish this blog post. This is day 22 in my series 31 Days of Disaster Recovery, and I want to examine which DBCC CHECK commands update the last known good DBCC check that is tracked in the header of the…

Read more

Here’s a quick plug for The Missing Windows 8 Instructional Video. I watched it and learned quite a few things, then forwarded it to my wife to watch and she found it useful as well. I’m torn on this – I’d like to think a good UI is intuitive… Read more

I am pleased to announce that I am speaking at VMware’s Partner Exchange for their CI1464 – Virtualizing Microsoft SQL Server with VMware Boot Camp. I am thrilled to be speaking with Jeff Szastak and David Gallant from VMware. If you are a VMware Partner, attend and receive… Read more