Featured Article(s)
Find all tables and schemas without a primary key constraint
The following procedure generates a list of all tables in all schemas and in all server’s user databases that a PK constraint is NOT defined on them.
Read: Integration Studio Review
Friday we published a review of Relational Solutions BlueSky Integration Studio – if you’re building SSIS projects, you definately should check this out. I was really floored by the cool things this does, from changing data sources to documenting your packages automatically to, well, lots more. Check out the review here.
Idera Updates Compliance Manager
Idera has released a big update for their SQL Compliance Manager product. You should take a look – it’s not an "I only care about this if I have to worry about compliance things" type product. CM will apply your best practices to your servers, letting you know where you have issues with security and so much more. Take a look here, and you’ll see – it can really help show you how your systems are running and where to look to get them up to snuff in terms of sticking to your rules. Get more information here.
Latest Shows to Watch
Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision.
Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day
Watch: SQLonCall: How to Hire a DBA – How to review resumes, what to look for, what to avoid.
Note: we’ll be off this week unless we’re able to post during the week – we’re at DevConnections interviewing and planning those next shows.
SQL Server Crystal Ball: Knowing What to Watch As Your SQL Server System Grows
We’ll look into pulling baseline information, things you can do to chart and forecast growth on your system and the basic options you have to grow you system out and up. Find out how to use Performance Monitor tools and learn about what different scaling techniques can bring to the table.
> Register Now
> Live date: 11/13/2007
Creating, Managing and Reviewing Jobs with SQL Server 2005
We’ll show how to create a job, work through the different options,including notifications, variable job steps, scheduling and more. The goal of this session is to have you up and running, understanding how the options work for setting up and managing jobs in your system.
> Register Now
> Live date: 11/14/2007
Troubleshooting and Maintaining SQL Server 2005
Find out about how to dig into your system and pull information you need to know to understand what’s happening. We’ll look into performance monitor counters to keep track of, where logs are that you should be aware of and more. The goal of this session is to have you feeling comfortable with performance profiling and investigation approaches for your system.
> Register Now
> Live date: 11/20/2007
Featured White Paper(s)
Maximizing SharePoint: Understanding Replication Options
Slow or unavailable bandwidth connections? An understanding of replication technology can prevent SharePoint infrastructure c… (read more)
GridApp Clarity™ SQL Server
The relational database product landscape, formerly a monolithic list of a few 800-pound gorillas, now spans a broad range of… (read more)
Enterprise Strategies to Improve Application Testing – Optimized Test Environments Speed the Deployment of Reliable Applications
Today’s applications drive revenue and satisfy sophisticated marketplace initiatives. These customer-facing and mission-criti… (read more)
Business Rule Mining: Get a Detailed Analysis of your COBOL Applications
LogicMiner can help your organization reduce maintenance costs and prepare for ongoing modernization of legacy applications. … (read more)