|
SQLUG.BE Resource Page
SQLShare has a video channel dedicated to SQL Server and the technologies that surround it. You'll find videos about SSIS, Replication, Performance and more. http://www.sqlshare.com
It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL Server database software. The reasons can range from a poorly designed database to a system that is improperly configured for the workload. As an administrator, you want to proactively prevent or minimize problems; if they occur...
This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM...
Download the SSIS Connectors for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2008.
This white paper describes a series of test configurations we ran, which represented a variety of possible scenarios involving SQL Server running in Hyper-V. The paper discusses our results and observations, and it also presents our recommendations. Our test results showed that SQL Server 2008 on Hyper-V provides stable performance...
The goal here is simple: to provide free videos and forums about the Microsoft BI stack. This includes SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, PerformancePoint Server, ProClarity, SharePoint, and Excel. While the videos and forum participation are free, you'll need to create an...
Great Microsoft Learning Offers Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning...
posted by on to ()
Deployment articles Reusing Connections with Data Sources and Configurations , by SQL Server MVP Matthew Roche Understanding Integration Services Package Configurations , by SQL Server MVP Rafael Salas Best Practices for Integration Services Configurations , by SQL Server MVP Jamie Thomson Defining a Configuration Approach for Integration...
The SQL Server Premier Field Engineers in Microsoft UK published a nice set scripts on their blogs. Check it out here and here .
Author: Gilles Duchêne The result of a view cannot be sorted. For a lot of developers, this feels like a shortcoming in the SQL language. Instead of applying the correct syntax: Creating & using the view: CREATE VIEW view AS SELECT fields FROM table SELECT fields FROM view ORDER BY fields A lot of people like to write: CREATE...
Summary: There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices...
A great whitepaper on the new stuff in T-SQL written by Itzik Ben-Gan. http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx
In this one-day seminar, Rafal Lukawiecki aims to show IT Professionals how data mining can be used in IT infrastructure to support real business scenarios demystifying the perception that Data Mining is complex, untested or only for specialists. This has become possible since Microsoft has taken the technology to new levels making...
Test drive Microsoft SQL Server 2008 in a virtual labs . MSDN Virtual Lab: Using Table Valued Parameters in SQL Server 2008 MSDN Virtual Lab: Using the new SQL Server 2008 Spatial Capabilities: GEOGRAPHY MSDN Express Virtual Lab: Building Occasionally Connected Systems MSDN Express Virtual Lab: Dimension Designer and Best Practice...
A Visual Studio.Net add-ins with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio. (BIDS) Features Analysis Services Aggregation Manager Calculation Helpers Column Usage Reports Delete Unused Aggregations Deploy Aggregation Designs Deploy MDX Script Dimension Health Check Dimension Optimization...
|