Sql samples, sql tips: Articles

Showing posts with label Articles. Show all posts

Thursday, March 21, 2013

[Articles] Zettabytes and Beyond

Posted: 20 Mar 2013 11:00 PM PDT

The growth of data, and the sheer scale of data we store and manage is stunning. Steve Jones looks at the rates of growth these days.

Wednesday, March 20, 2013

[Articles] Stop, Smell, Smile

Stop, Smell, Smile

Posted: 19 Mar 2013 11:00 PM PDT

On this quiet Friday, Steve Jones skips a poll and talks about life. This editorial was originally published on Jun 6, 2008. It is being republished as Steve is on vacation.

Tuesday, March 19, 2013

[Articles] Serious Storage

Serious Storage

Posted: 18 Mar 2013 11:00 PM PDT

Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.

Monday, March 18, 2013

[Articles] The Backup Process

The Backup Process

Posted: 17 Mar 2013 11:00 PM PDT

Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.

Friday, March 15, 2013

[Articles] Inconsistency

Inconsistency

Posted: 14 Mar 2013 11:00 PM PDT

This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.

Thursday, March 14, 2013

[Articles] The Gambler

The Gambler

Posted: 13 Mar 2013 11:00 PM PDT

If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.

Wednesday, March 13, 2013

[Articles] Resetting DMVs

Resetting DMVs

Posted: 12 Mar 2013 11:00 PM PDT

Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.

Tuesday, March 12, 2013

[Articles] Self Describing Databases

Self Describing Databases

Posted: 11 Mar 2013 11:00 PM PDT

Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.

Monday, March 11, 2013

[Articles] Who Built This Thing?

Who Built This Thing?

Posted: 10 Mar 2013 11:00 PM PDT

Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest. This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation.

'Six Scary SQL Surprises'
Brent Ozar joins the DBA Team, for Lesson 3 of their 'Top 5 Hard-earned Lessons'. Gain valuable tips from the pros - Read now

Wednesday, March 6, 2013

[Articles] Two Plugs Away

Two Plugs Away

Posted: 05 Mar 2013 11:00 PM PST

The culture and practices at Valve are interesting to Steve Jones, but the desks really caught his eye.

Tuesday, March 5, 2013

[Articles] Data We Don't Want

Data We Don't Want

Posted: 04 Mar 2013 11:00 PM PST

There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.

Monday, March 4, 2013

[Articles] Does Connect Work?

Does Connect Work?

Posted: 03 Mar 2013 11:00 PM PST

The Connect system at Microsoft allows users to submit bugs and suggestions for products. Does this work? Steve Jones isn't so sure.

Friday, March 1, 2013

[Articles] Why SQL Server?

Why SQL Server?

Posted: 28 Feb 2013 11:00 PM PST

This Friday Steve Jones asks you how you got started working with SQL Server in your career? Let us know how you got started and why you stuck with it.

Thursday, February 28, 2013

[Articles] More Evolution, More Complexity

More Evolution, More Complexity

Posted: 27 Feb 2013 11:00 PM PST

As SQL Server advances and evolves, Steve Jones thinks it gets more complex, not necessarily easier to administer.

Wednesday, February 27, 2013

[Articles] The Microsoft Sideshow

The Microsoft Sideshow

Posted: 26 Feb 2013 11:00 PM PST

Microsoft hasn't performed well on the stock market across the last decade, but the company has changed. There are cries that the business has been mismanaged and today Steve Jones has a few comments.