Editorials

Editorials

SQL Server Security Teamwork

Featured Article(s) SQL Server 2005 Cluster Troubleshooting In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 cluster. He also tells how you can resolve these problems. SQL Server Video Show Available SelectViews #110: Partitioning Large Databases, USB Devices, Performance and Clustered Indexes, Upcoming Events. Also, the Accidental DBA Tip, the […]

Editorials

What Is Your SQL Server Security Plan and Approach?

SQL Server Video Show Available SelectViews #110: Partitioning Large Databases, USB Devices, Performance and Clustered Indexes, Upcoming Events. Also, the Accidental DBA Tip, the 60-Second SQL Server Tip of the Day and a Lot More. [Watch The Show] What is Your Security Plan? How do you work to put new security in place, add new things to your systems and […]

Editorials

Data Storage – Revisited

Featured Article(s) System Life cycle of Computer Based Information System (CBIS) A computer based information system (CBIS) is a set of software packages, which when executed, provides information for decision- making. Designing and developing a CBIS is one of the most important activities in any organization, as it involves people at different levels in the organization, like any living organism, […]

Editorials

Have You Started Business Intelligence-Type Work Yet?

Did You Know? (Coming Sept/Oct – Register Now) – Business Intelligence Virtual Conference – .NET Developer’s Virtual Conference – SharePoint Virtual Conference – SQL Server Virtual Conference New Video Show Posted SelectViews #110: Partitioning Large Databases, USB Devices, Performance and Clustered Indexes, Upcoming Events. Also, the Accidental DBA Tip, the 60-Second SQL Server Tip of the Day and a Lot […]

Editorials

SQL Server 2008 Deployment Initial Feedback

Can’t See the Forest for the Trees? (Performance) It can be tough to know what to watch when you are looking to understand performance on your servers. Counters, activity, CPU – it all adds up. With SQL Sentry’s new performance tool, Performance Advisor, you get the information you need, in a way that makes it easy to understand exactly what’s […]

Editorials

What Are Your SQL Server 2008 Plans?

Featured Article(s) Tips for using SQL Server 2005 backup/restore (Part 2) Here are some helpful tips to perform backup and restore actions in SQL Server 2005. What Are Your SQL Server 2008 Plans? I’ve been hearing a lot from different vendors about their plans for SQL Server 2008, so it got me thinking about what everyone is planning to do. […]

Editorials

Data Security, USB Keys, USB Drives and Backups

Simplify Your Performance Tuning Stop working so hard to tune. Did you know one of the most effective things you can do to maintain and improve performance is to keep your indexes tuned, defragmented and running well? It’s such a basic step that many times it’s overlooked. Idera has their SQL Defrag tool that will completely automate this for you […]

Editorials

USB, Your Data, SQL Server and Security

Featured Article(s) Changing from Non-IDENTITY to IDENTITY and vice versa Changing a column data type from Non-IDENTITY to IDENTITY and vice versa. One 3D Picture Will Tell It All With Sql Power Tools pinpoint performance issues in the entire SQL Server farm in one 3D visualization from any web browser. When poor end-user response time, high CPU usage, blocking, excessive […]

Editorials

SQL Server Security – Reality Check

Featured Article(s) Tips for using SQL Server 2005 backup/restore (Part 1) Here are some helpful tips to perform backup and restore actions in SQL Server 2005. Building Presentations Based On SQL Server Data? Stop doing things the old fashioned way – copy, paste, select chart types, format, adjust that font size, change that color… You can have a fantastic presentation […]