Featured Article(s)
Everything about Sizes in SQL Server
The articles briefly describes about how to find the sizes of various SQL Server objects and also troubleshoot when there is a problem with the space of the database
Best Practices Tools from Microsoft for SQL Server
Microsoft has the Best Practices Analyzer and the Security Analyzer tools – both free, both available to scan and analyze your systems. These are some of my favorite tools only because you can point them at your systems and get a very fast picture of where things stand, what you need to pay attention to, etc.
I’m constantly surprised, though, about how many people don’t know about these. Have you used them? If so, were they helpful to you? I’ve only run across a number of accounts that have used them regularly. Most that I’ve seen will run them intermittently and get information back, but then acting on it always seems to come with the "yes, but…" clarification of why the best practice isn’t in place. I admit that we’ve been guilty of this as well. Security, access controls, disk configurations – the best practices tool in particular will point out exactly that – best practices. What it doesn’t, and can’t, do is to know what your application and user requirements are. Sometimes it’s just not possible, for example, to have Windows-based security for all access.
Have you used these tools? Did you know they existed? What are your experiences with them? What’s your favorite way of taking stock of your systems?
Drop me a note, let me know how you go about this. Email me here and let me know.
SSWUG.ORG SelectViews SQL Server Show
The show today features RAID and Defrag tips, backup optimization with filegroups, baseline stats and industry news. Also, find out about virtual learning opportunities, the SQL tip, the developer/AJAX thoughts and much more.
[Watch the Show Here]
Webcast: How to Hire a DBA Part 2 of 3
Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part two of this series we will talk about reviewing a resume. Presented by: Chris Shaw
> Register Now
> 7/15/2009 at 12:00pm Noon Pacific
Webcast: DTS Conversion to SSIS – Conversion Best Practices
Join this webcast and Learn how and why to convert DTS to SSIS. See how you can save time and money and easily migrate your DTS packages to SSIS
– Introduction to SSIS and its differences vs. DTS
– Advantages of SSIS over DTS
– Options for converting DTS packages to native SSIS
– Adding value to packages during the conversion process
– Assessing the scope of a DTS conversion project
> Register Now
> 8/5/2009 at 12:00pm Noon Pacific
Featured White Paper(s)
10 Things you can’t do with LiteSpeed
HyperBac’s uniqueness, innovativeness and differentiators vs all other third party compression utilities is described in this… (read more)