Featured Script

The Voice of the DBA

The Gadget Itch

Many of the people that work in technology are interested in gadgets and hardware as much as software. Not all of us, but many of us have had side projects where we've melded hardware and software together. For those of us that are older, and started working with computers decades ago, that might have been the only way that we could get a computer system to work.

I'm glad that I still find people interested in hardware. My son recently built his own gaming computer from parts, and I'm hoping to distract him from some games and get him to help me build some robots with a Raspberry Pi computer and BrickPi add-on board. However it's not just kids as I've seen a number of people at Red Gate working with hardware to build a variety of interesting projects.

This week I'm wondering if any of you are interested in creating your own devices. If you had the chance to build a device or gadget for work, what would it be? A panic button when there's a problem that you can press and instantly set of Star Trek "red alert" sirens? A status display based on your continuous integration builds? The question this week is:

Whether you've started actually assembling things or you're just dreaming of something, or perhaps even just seen something that's intrigued you, let us know. I actually think this might be a fun competition of some sort for an event, perhaps a hacking competition across a couple hours at a SQL Saturday or conference.

You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help. More »

The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question
(by Steve Jones):

In a hash match join, which input is the one used to build the hash table?

Answer: The first input

Explanation:

In a hash match join, the first input is used to build the hash table and the second input is used to probe the hash table. Size does not matter for this operator.

Reset sp_prepexec
- Can we reset sp_prepexec and sp_execute
When i am running the sp_prepexec the id is generated say it is 22 then...

166 days to create index
- I have a table containing 2,163,568,622 rows hosted on SQL server Standard 2008.
Attempted to create a new index:
--------------------------------------------------------------------------------------------------------------------------------------------------
Using TEMPDB = ON...

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.