New SQL Server Show Available We’ve just posted the latest SelectViews show to the site. Learn about best practices from the field in this interview show with both the Avepoint and SQL Sentry folks. [Watch Here] Featured Article(s) Rebuild or Reorganize or do nothing to indexes SP The following stored procedure makes use of the index fragmentation information that resides […]

More Management Studio Wishlist Items [Send In Your Request(s) Here] David: "How about something simple that used to be in Enterprise Manager for SQL Server 2000, viz. "Export list"? If I wanted a file with a list of databases in an instance, or tables in a database, or linked servers, or stored procedures, or SQL Server Agent jobs, or Logins, […]

Check out the latest video programs on SSWUG [Watch Here] Rushed? Work Less. Deliver More. Give business users the ability to view, update and interact with reports – anywhere. You’ll not only have happier end users, but you’ll be happier too. Fewer reports to create. And the ability to schedule secure reports for automatic delivery day or night. We’re talking […]

Sometimes Gauging Performance Can Kill It But not with the right tools to dig into your systems. It’s amazing if you consider that a common database server will have 4,000 unique application SQL statements that can run 10+ million times during the business day. With Sql Power Tools, you can find out what’s running, what’s running slower than it has […]

Featured Article(s) Corporate Computing Models All businesses small and large, must manage the company data in a fashion that allows the business to run smoothly. Some business might use filling cabinets to manage their data, but most companies choose to use computerized database management systems that efficiently store, retrieve and manage large amounts of data. If your company works with […]

Have You Registered for SQL Connections Yet? It’s the premier in-person SQL Server event – coming in November in Las Vegas. Make sure you get registered ASAP and save your spot! Every attendee even receives a copy of SQL Server 2008 with a CAL. Can’t go wrong! [Get more information here] Featured Article(s) Creating a Random Test Dataset This article […]

Making a Difference Many people wrote in asking about roles and responsibilities ("do I need to do analyst work to be an asset for the company??") and how this plays into the editorial from yesterday. Well, I don’t think we should revisit the job title and responsibilities thing right now (we just completed a really good discussion about that), but […]

Featured Article(s) Troubleshooting SQL Server 2005 Analysis Services problems (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 Analysis Services. He also tells how you can resolve these problems. Tough Times, More Expectations and More Responsibility It’s no secret that the markets are in a bit of turmoil […]

Featured Article(s) Oracle 2-Day DBA in x Days Post 16; Managing Tablespaces Ok, you’ve created a tablespace but how to manage them are completely different Video Interview on SSWUGtv (Special Edition SelectViews Show) Check out our latest video, an interview with Microsoft’s Buck Woody. It’s an informal interview, with lots of great information about SQL Server, the world of databases, […]

Featured Article(s) Things Your Mother Never Mentioned About Setting Up an Oracle Database – Steps 6 and 7 This series article looks at setting up the secondary backups of an Oracle database. The secondary backup is an export of the database into a compressed file along with the DDL and DCL needed to recreate the schemas on another instance. Video […]