Features
|
459 results found for Features, displaying items 1 - 20
|
Create a Job-Scheduling Advisor
Use this Gantt-chart–style overlay report, based on SQL Server Reporting Services 2008 and an enhancement to the Data Repository solution, to find the best times to run SQL Server Agent jobs.
SQL Server Magazine
—
Rodney Landrum
Tracking the Use of Deprecated SQL Server Features
SQL Server 2008 provides performance counters and trace events that you can use to track which deprecated features are being used in your environment.
SQL Server Magazine
—
Itzik Ben-Gan
Deprecated T-SQL Features
Find out which features are missing or are deprecated in SQL Server 2008, as well as which features SQL Server won’t support in a future version.
SQL Server Magazine
—
Itzik Ben-Gan
SQL Server 2008 Change Data Capture
The new, asynchronous CDC feature built into the SQL Server 2008 relational database engine replaces the need to create custom CDC solutions and provides better performance.
SQL Server Magazine
—
Derek Comingore
Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth
See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.
SQL Server Magazine
—
Tyler Chessman
JavaScript Development
Learn about two solutions that make writing JavaScript easier
SQL Server Magazine
—
Tyler Chessman
Using the MapPoint Web Service to Fix a Bug in AdventureWorks2008
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values
SQL Server Magazine
—
Tyler Chessman
Integrate MySQL and SQL Server
Need to retrieve MySQL data and insert it into a SQL Server database? SQL Server Integration Services and MySQL connectors let you do so fairly easily.
SQL Server Magazine
—
Robert Sheldon
Calculate Percentiles
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
SQL Server Magazine
—
Itzik Ben-Gan
Efficient Data Binding with Windows Presentation Foundation and Visual Studio 2008
A free tool helps you use Visual Studio 2008 to automate wiring your SQL Server data with a Windows Presentation Foundation (WPF) front end.
SQL Server Magazine
—
Ken Spencer
Automating Development Can Lead to Project Success
To turn around a failing project try building more automation into the development process
SQL Server Magazine
—
Ken Spencer
Partitioning a Table that Contains Future Dates
If you have a large table with future dates in it, you can use the method described here to partition it.
SQL Server Magazine
—
Gary Zaika
Sharpen Your SQL Server Skills
Pick up 7 basic query analysis rules from Dave.
SQL Server Magazine
—
Pinalkumar Dave
T-SQL 101: Built-In Functions
T-SQL offers three types of built-in functions, including scalar functions. Scalar functions let you perform a wide variety of operations, such as retrieving dates and replacing strings, with only a few lines of code.
SQL Server Magazine
—
Bill McEvoy
Automate SQL Server Error Log Checking
Use this custom solution to check error logs in a mixed SQL Server 2005 and SQL Server 2000 environment.
SQL Server Magazine
—
Richard Ding
SSIS Logging and Data Auditing
Use Business Intelligence Development Studio (BIDS) to customize package logging.
SQL Server Magazine
—
Tyler Chessman
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
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
|
|
Register
