Recently added articles from SQL Server Magazine:
Plugging the G*A*P*S in SQL Server JOB TRACKING
Sep 01, 2008; Bahat, Omri ... Track down and solve job-scheduling problems using two helpful scripts SQL Server jobs are useful for automating and scheduling the execution of database programs. The SQL Server Agent service is responsible for tracking job schedules and launching SQL Server jobs on time. Yet sometimes ...
Database Encryption Solutions
Sep 01, 2008; Marwitz, Caroline ... Protect your databases-and your company-from attacks or leaks Given recent well-publicized data leaks and beefedup security regulations that require companies to publicly disclose when unencrypted data has been exposed, all companies not using database encryption should be asking ...
Implementing Microsoft's BI Platform
Sep 01, 2008; Bearly, Megan ... In the past few years, Microsoft has released several business intelligence (BI) products, such as SQL Server 2005, the Microsoft Office 2007 suite, Microsoft Office Share-Point Server (MOSS) 2007, and Microsoft Office PerformancePoint Server 2007. However, it wasn't until recently that ...
Discover the Benefits of FILTERED INDEXES & STATISTICS
Sep 01, 2008; Ben-Gan, Itzik ... Enhance your queries and obtain more useful data (ProQuest: ... denotes formulae omitted.) SQL Server 2008 introduces a very cool new feature-filtered indexes and statistics. This new feature lets you improve the performance of your queries without wasting disk space; offers more ...
Drowning in Data
Sep 01, 2008; Bearly, Megan ... In a recent Business Performance Management (BPM) Forum survey sponsored by network storage provider BlueArc and titled "Uptime @ Crunch Time-Valuing the Need for Data Speed at Critical Business Inflections," more than 80 percent of respondents said that storage performance and data access are ...
Demystifying SQL Server Virtualization
Sep 01, 2008; Otey, Michael ... Because SQL Server can be I/O intensive, it hasn't been at the top of the list of server types you'd want to virtualize. However, with the recent release of Microsoft's Hyper-V and VMware's new ESX Server 3.5, SQL Server virtualization is becoming increasingly interesting. Performance for many ...
DTS xChange
Sep 01, 2008; Green, John ... This tool provides a real shortcut for your DTS migration package Pragmatic Works' DTS xChange converts DTS packages to native SQL Server Integration Services (SSIS) packages for use with SQL Server 2008 and SQL Server 2005. DTS xChange takes a three-phase approach to DTS-conversion ...
Microsoft to Purchase Zoomix
Sep 01, 2008; Molnar, Sheila ... www.sqlmag.com/go/industrybytes Microsoft announced that it has inked an agreement to purchase Zoomix, a Jerusalem-based company that creates software to automate the delivery of correct, complete, and synchronized enterprise data within the business workflow. When the acquisition is ...
T-SQL 101: VIEWS
Sep 01, 2008; McEvoy, Bill ... In Lesson 7, learn how and when to use views (ProQuest: ... denotes formulae omitted.) Up until this point, I've covered how to manipulate data stored in physical tables. Now I'll introduce you to querying data represented by virtual tables. These virtual tables are SQL ...
Questions & Answers
Sep 01, 2008; McEvoy, Bill; Vaughn, William ... (ProQuest: ... denotes formula omitted.) Get help from the pros Q: I use a disconnected architecture in which sales agents take their systems to the field and add new customers. How can I create unique primary keys that are easy for customers to use? We have a few thousand ...
T-SQL Enhancements in SQL Server 2008, Part 2
Sep 01, 2008; Otey, Michael ... (ProQuest: ... denotes formula omitted.) SQL Server 2008 offers so many important T-SQL enhancements, I ran out of space last month describing them (see "T-SQL Enhancements in SQL Server 2008," InstantDoc ID 99416). Now let's look at more T-SQL enhancements you might find ...
NEW PRODUCTS
Sep 01, 2008; Anonymous ... PERFORMANCE MONITORING Optimize SQL Server Performance SQL Sentry has announced the availability of its new performance monitoring and optimization tool, SQL Sentry Performance Advisor. Performance Advisor features include a performance dashboard, real-time and historical ...
YOUR SAVVY ASSISTANT: The Missing Link to IT Resources
Sep 01, 2008; Humphries, Christan ... Sometimes, you just can't say it better than somebody else already has. In a September 2007 Letter to the Editor (InstantDoc ID 96635), Roger Reid wrote "a SQL Server admin supporting SharePoint needs to know a fair amount about SharePoint." To learn more about Microsoft Office SharePoint Server ...
Data Warehouse Workloads and Use Cases
Sep 01, 2008; Poolet, Michelle A ... Determining how your data warehouse is used Data warehouses are evolving from the traditional information archive that supports business intelligence (BI) users and reporting tools, becoming instead true analytical repositories that support mission-critical functions of the enterprise ....
Get Rid of Gaps in Numerical Sequences
Sep 01, 2008; Byrd, Roy ... It's common for a table to contain an integer column that's used as the table's primary key or part of the primary key. An integer column can be a simple sequence of numbers (e.g., 1, 2, 3, ?) or a more complex sequence that includes numbers representing specific information such as a year ...
Desperately Seeking SAMPLES
Sep 01, 2008; Poolet, Michelle A ... Sample databases educate with realistic, useful illustrations of business scenarios Any programmer will tell you: There's nothing like a sample bit of code to illustrate how something is done. Sample code helps jumpstart the learning and development process. Learning from examples is a ...