Watch the Latest SQL Server Show
Watch SelectViews here – you could even win $200 just for providing feedback! I’d love to hear what you think of some proposed new sections on the show. Plus, find out about data relevance, moving data from Access to SQL Server in our MiniCast and much, much more. I even have a new somtimes-segment, "Book Looks" that takes a look at a Wrox book you may be interested in.
Featured Article(s)
Oracle Security Simple Operating System External Authentication
Learn what Operating System External Authentication is about and how it can aid in locking down your Oracle database.
What If You COULD Have a DBA in a Box?
SQL Server, Oracle and even MySQL from one tool. You can quickly build and test stored procedures in seconds in the SQL Notepad. Easily build and manage data/schema between source and multiple target systems. Create insert, delete, update scripts for multiple tables in a few clicks! Instantly view parent-child, child-parent relationships. Create a working 5 table join in 6 clicks. Mount your own scripts/code directly into our SQL IDE. Execute any SELECT statement sending output directly to Excel. SQL Object browser puts everything a few clicks away. No kidding. View interactive demos – See for yourself. Check out dbOrchestra here.
Webcast: Moving from SQL Server 2000 to SQL Server 2005 Security
We’ll look into the differences between the approaches to security, how they apply to your database, the information you’re managing and tips along the way. There are some strong abilities in SQL Server 2005 and this show will look to explain the differences from the perspective of moving from SQL Server 2000. We’ll compare and contrast and make sense of the updates so you’re ready to move forward.
> Register Now
> October 4, 2007, 12:00pm Noon Pacific (we’ll send you a reminder after you register)
Maintenance Plans – Do You Use Them?
What’s standard on your system? I’m quickly (and not surprisingly) finding out that there are really no standard routines that are being run. Frankly, not even much overlap between emails (which IS surprising). Here’s a note from Josh talking about some of the management and staff wrangling that can go on:
"I read this morning’s editorial, and it really struck a chord with me. In the past 5 years, I’ve worked in shops ranging in size from 60 employees to 28,000 employees (in the latter, a huge portion were development staff). In almost every case, developers were annoyed whenever a DBA was involved, whether it was during design and development or daily production issues.
Oddly enough, the two smallest shops I’ve worked in both preferred to have a DBA working inside the database as well as watching server performance, making sure backups are reliable, checking integrity, etc. In the larger shops, application developers saw the DBA as a bottle neck or a “show stopper”, and felt that they shouldn’t have to deal with the DBA questioning design (as well as maintenance) decisions. Obviously, as a DBA, I prefer the shops that want me involved.
I want to spend time sitting in a chair next to a developer and talking through their code and helping them make good choices about their use of SQL Server. I also want to be able to take the proactive measures, such as integrity checks, without having to explain repeatedly why we need to execute these processes (I don’t mind explaining it once or twice; but every month?).
It’s curious that larger organizations let the “us versus them” mentality persist amongst their IT organizations; DBA, Security, App Development, Infrastructure, etc. All of these teams are supposed to work together, but often times they resent having to work with other teams. With application developers and DBAs, it is even more important that the two teams function together, otherwise you end up with poor design, little to no maintenance, and a disaster waiting to happen. "
Featured White Paper(s)
File Fragmentation, SANs, NAS and RAID
Does fragmentation affect SANs, NAS, and RAID? Many people think it doesn’t-but that perception is incorrect. Disk arrays imp… (read more)
Finding and Fixing Bad SQL in Microsoft SQL Server 2000
This article will teach you the basic techniques used to find and fix poorly performing SQL statements (usually SELECT statem… (read more)
Metadata-Driven Data Integration – Ensuring Enterprise-Wide Visibility and Transparency with Metadata Management
More than ever, leading organizations are managing metadata as part of the data integration lifecycle. Unlike a standalone m… (read more)
Top Ten Steps to Secure Your SQL Server
In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. … (read more)