Recent Articles
|

50 results found, displaying items 1 - 20
|
Q: How do I retrieve values from a table and store the results in a string?
Learn how to retrieve values from a table and store the results.
SQL Server Magazine
—
Bill McEvoy
Q: How can I create unique primary keys that are easy for customers to use?
Learn how to create unique primary keys for customer use.
SQL Server Magazine
—
William Vaughn
Q: How can I extract reports from a data source for field agents to access while on the road?
Learn how to use Visual Studio’s Microsoft ReportViewer to extract reports.
SQL Server Magazine
—
William Vaughn
Q: What's the best way to keep client data on a SQL Server Compact Edition database in sync?
Learn how to use ADO.NET 3.5 Synchronization Services classes to keep data in sync.
SQL Server Magazine
—
William Vaughn
|
[August 28, 2008]
|
|
Use SteadyState to Manage Shared Computers
SteadyState lets you use Windows Disk Protection to roll back system partitions to a known state, configure computer and user restrictions, and schedule software updates.
Windows IT Pro
—
Russell Smith
Discover the Benefits of Filtered Indexes and Statistics
Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.
SQL Server Magazine
—
Itzik Ben-Gan
Plugging the Gaps in SQL Server Job Tracking
Find missing SQL Server jobs and scheduling conflicts by using two scripts that supplement SQL Server Agent job tracking.
SQL Server Magazine
—
Omri Bahat
Desperately Seeking Samples
Educate yourself on the design and operation concepts for databases and data warehouses by taking advantage of Microsoft’s sample databases. Although the business scenarios are fictitious, they translate to real-world uses.
SQL Server Magazine
—
Michelle A. Poolet
Data Warehouse Workloads and Use Cases
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
SQL Server Magazine
—
Michelle A. Poolet
New Products
Check out new and improved SQL Server-related products from SQL Sentry, Quest Software, Sentrigo, and AMB.
SQL Server Magazine
—
Editors
Implementing Microsoft's BI Platform
Premier Bankcard’s BI Director, Ron Van Zanten, shares his experience deploying Microsoft’s SQL Server 2005 BI platform--how long it took to get the data warehouse up and running and the challenges faced during implementation.
SQL Server Magazine
—
Megan Bearly
Database Encryption Solutions
Database encryption can protect your data from internal and external attacks. When choosing a solution, consider who you are protecting data for and who you are protecting it from, along with any compliance regulations.
SQL Server Magazine
—
Caroline Marwitz
T-SQL 101: Views
The virtual nature of a view is its greatest strength and its greatest weakness. Here's what you need to know to create views and use them wisely.
SQL Server Magazine
—
Bill McEvoy
Indexed Views vs. Regular Views
Learn how indexed views differ from regular views.
SQL Server Magazine
—
Bill McEvoy
T-SQL Enhancements in SQL Server 2008, Part 2
SQL Server 2008 powers up T-SQL with new features such as the GROUPING SETS operator and table-valued parameters.
SQL Server Magazine
—
Michael Otey
Get Rid of Gaps in Numerical Sequences
Although companies might want integer sequences in database applications to be gapless, gaps occur frequently. Here's a solution that you can use to eliminate existing and avoid new gaps.
SQL Server Magazine
—
Readers
Demystifying SQL Server Virtualization
Michael Otey dispels some myths surrounding SQL Server virtualization, including the notion that all virtualization platforms are created equal. He explains the high-level differences between the hosted, hypervisor, and virtualized OS platforms.
SQL Server Magazine
—
Michael Otey
Where in the World Are Pubs and Northwind?
SQL Server Magazine
—
Michelle A. Poolet
|
[August 28, 2008]
|
 |
Q. Is SharePoint supported on Hyper-V?
FAQ for Windows
—
John Savill
Internet Explorer 8 Beta 2 Goes Public
Microsoft on Wednesday shipped the Beta 2 version of its upcoming Internet Explorer (IE) 8 Web browser. This version of the product, which will be made available free to Windows XP, Vista, 2003, and 2008 users, adds many functional advances and some new
WinInfo
—
Paul Thurrott
|
|