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 […]
Author: Ben Taylor
FileStream: Experiences and Feedback Request
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 […]
Management Studio – What Would YOU Like to See?
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 with SQL Server
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 […]
Tough Times, More Expectations and More Responsibility
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 […]
Buck Woody of Microsoft on SSWUGtv
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, […]
Upgrade Feedback – Timeframes, Experiences
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 […]
A Procedure that finds all the Non-Used Indexes in a database
New Video Interview Posted to 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, SQL Server 2008 and such. [Watch The Show] Featured Article(s) A Procedure that finds all the Non-Used Indexes in a database The following […]
Mini Community Survey – Need Your Input
30 Sessions, 10 Speakers… …and that’s just the SQL Server sessions! We have some great things lined up to get you up to speed with SQL Server. Things are tough right now in so many companies. This is a great way to do all you can for your company – be efficient and rock-solid in your work, be up to […]
Troubleshooting SQL Server 2005 Analysis Services problems (Part 1)
Featured Article(s) Troubleshooting SQL Server 2005 Analysis Services problems (Part 1) 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. Interesting Trend… Injection Forcing Looks at Other Issues I’ve been seeing an intriguing trend of late – that of […]