www.pheedcontent.com | 5/20/10 4:54 PM
SqlServer News
| Microsoft SQL Server 2008 R2 spotlight Microsoft's latest database server release comes with a host of new
features, including several BI enhancements for the enterprise. www.pheedcontent.com | 5/20/10 4:54 PM Microsoft SQL Server 2008 R2 spotlight Microsoft's latest database server release comes with a host of new
features, including several BI enhancements for the enterprise. www.pheedcontent.com | 5/20/10 4:54 PM Seizing stats and grouped data with T-SQL aggregate functions The power of aggregate functions goes well beyond the basics. This tip
demonstrates how to work with grouped data, verify checksums, and
retrieve detailed statistics. Pros and cons of the DACPAC with SQL Server 2008 R2 Data-tier applications are among SQL Server 2008 R2âs most
talked-about new features, though version-one limitations could minimize
their impact in the short term. Supporting packaged SQL Server apps: What you can get away with Before making changes in SQL Server, you have to consider how they might
affect other applications. The challenge is knowing what you can and
canât do. Microsoft brings PHP integration to SQL Server Reporting Services PHP isnât just a Linux language anymore. With the help of a new
SDK, developers can incorporate the scripting language with SQL Server
reports. Microsoft changes virtualization licensing for SQL Server 2008 R2 The company has put the kibosh on unlimited virtualization rights with
SQL Server 2008 R2 Enterprise Edition. Shining the light on PowerPivot for SQL Server 2008 R2 With the promise of providing simple, self-service BI analysis for
users, the time has come to put Microsoftâs new PowerPivot
technology through its paces. Frequently Asked Questions: SQL Server 2008 R2 Not sure what to make of R2? Here youâll find answers to some of
the most common questions involving the latest database server release
from Microsoft. Where business intelligence project planning goes wrong Maintaining a successful BI strategy isnât always smooth
sailing. The best way to avoid big mistakes is to know where others have
gone wrong. T-SQL string functions: The ins and outs for SQL Server String functions offer flexibility to your T-SQL statements â
once you understand how they work. As you might expect, the best place
to start is with the functions themselves. Using T-SQL string functions to convert and report on data Thereâs plenty more to learn about string functions beyond the
basics. Here youâll find details on more advanced practices,
like performing a SOUNDEX analysis. T-SQL string functions: The ins and outs for SQL Server String functions offer flexibility to your T-SQL statements â
once you understand how they work. As you might expect, the best place
to start is with the functions themselves. Using T-SQL string functions to convert and report on data Thereâs plenty more to learn about string functions beyond the
basics. Here youâll find details on more advanced practices,
like performing a SOUNDEX analysis. Top hacker tricks to exploit SQL Server systems Stay one step ahead of attackers by testing your SQL Server systems
against some of the most common hacking techniques. Microsoft, beta testers tout SQL Server 2008 R2 PowerPivot The companyâs new database release aims to free up information
for non-DBAs while also enforcing compliance. Microsoft, beta testers tout SQL Server 2008 R2 PowerPivot The companyâs new database release aims to free up information
for non-DBAs while also enforcing compliance. Loading data into a Master Data Services repository Configuration is an important first step for setting up Master Data
Services. But what about loading the data? Here is the step-by-step
process for R2. Loading data into a Master Data Services repository Configuration is an important first step for setting up Master Data
Services. But what about loading the data? Here is the step-by-step
process for R2. Quick tips for monitoring SQL Server performance issues When it comes to performance, the most basic techniques can make all the
difference. Learn which PerfMon counters to be on the lookout for when
tuning your SQL Server environment. New tool puts Oracle in the hands of SQL Server developers Microsoft and Quest have banded together to help put development for SQL
Server and Oracle databases under the same umbrella. New tool puts Oracle in the hands of SQL Server developers Microsoft and Quest have banded together to help put development for SQL
Server and Oracle databases under the same umbrella. www.pheedcontent.com | 4/8/10 8:59 PM Microsoft releases final Parallel Data Warehouse preview Microsoft has shipped the final technology preview of its new scale-out
data warehousing software. The actual launch, however, has been pushed
out. Master Data Services could spur SQL Server 2008 R2 migrations Microsoft's new master data management technology could be a major
factor for those pondering an upgrade to SQL Server 2008 R2. Master Data Services could spur SQL Server 2008 R2 migrations Microsoft's new master data management technology could be a major
factor for those pondering an upgrade to SQL Server 2008 R2. www.pheedcontent.com | 4/6/10 7:32 PM Master Data Services could spur SQL Server 2008 R2 migrations Microsoft's new master data management technology could be a major
factor for those pondering an upgrade to SQL Server 2008 R2. Top tips for SQL Server database failover success Utilizing log shipping or database mirroring for high availability is
only half the battle. There are still plenty of steps to take once your
standby server is online. www.pheedcontent.com | 4/5/10 6:29 PM Top tips for SQL Server database failover success Utilizing log shipping or database mirroring for high availability is
only half the battle. There are still plenty of steps to take once your
standby server is online. Microsoft releases final Parallel Data Warehouse preview Microsoft has shipped the final technology preview of its new scale-out
data warehousing software. The actual launch, however, has been pushed
out. www.pheedcontent.com | 4/2/10 11:55 PM Microsoft releases final Parallel Data Warehouse preview Microsoft has shipped the final technology preview of its new scale-out
data warehousing software. The actual launch, however, has been pushed
out. www.pheedcontent.com | 4/2/10 11:55 PM Microsoft releases final Parallel Data Warehouse preview Microsoft has shipped the final technology preview of its new scale-out
data warehousing software. The actual launch, however, has been pushed
out. Microsoft releases final Parallel Data Warehouse preview Microsoft has shipped the final technology preview of its new scale-out
data warehousing software. The actual launch, however, has been pushed
out. Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. www.pheedcontent.com | 3/31/10 7:40 PM Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. www.pheedcontent.com | 3/31/10 7:40 PM Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. Why BI? Business intelligence concepts defined Don't let the value of BI get lost in technical jargon. This tip
explains the purpose and components of a business intelligence system --
in plain English. Getting started with Master Data Services in SQL Server 2008 R2 MDS in SQL Server 2008 R2 has gotten a lot of attention, but how well
does it really work? It could all depend on how it's configured. Getting started with Master Data Services in SQL Server 2008 R2 MDS in SQL Server 2008 R2 has gotten a lot of attention, but how well
does it really work? It could all depend on how it's configured. www.pheedcontent.com | 3/29/10 9:51 PM Data collection the automated way in SQL Server 2008 SQL Server 2008's data collector feature automates the collection of
critical performance data, which DBAs can then analyze using brand new
SSMS reports. Data collection the automated way in SQL Server 2008 SQL Server 2008's data collector feature automates the collection of
critical performance data, which DBAs can then analyze using brand new
SSMS reports. www.pheedcontent.com | 3/25/10 3:32 PM Data collection the automated way in SQL Server 2008 SQL Server 2008's data collector feature automates the collection of
critical performance data, which DBAs can then analyze using brand new
SSMS reports. Open source tool simplifies database synchronization for SQL Server A free tool for Microsoft SQL Server could help take the time out of
syncing up public and development databases. Open source tool simplifies database synchronization for SQL Server A free tool for Microsoft SQL Server could help take the time out of
syncing up public and development databases. Open source tool simplifies database synchronization for SQL Server A free tool for Microsoft SQL Server could help take the time out of
syncing up public and development databases.
searchsqlserver.techtarget.com |
3/23/10 5:14 PM
|