Microsoft SQL Server 2008 Reporting Services Report Builder 2.0

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 delivers an intuitive,

Office-like report authoring environment enabling business and power users to leverage their experience with Microsoft Office 2007 products.

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including:

* Flexible report layout caabilities of SQL Server 2008 Report Definition Language
* Data Visualizations including charts and gauges
* Richly formatted textboxes
* Export to Microsoft Office Word format

Features specific to Report Builder 2.0 are focused on simplifying the process of creating and editing reports and queries and include the following:

* Easy to use wizards for creating table, matrix and chart data regions
* Support for directly opening and editing reports stored on the report server
* Support for using server resources such as shared data sources
* Query designers for multiple data sources including a Microsoft SQL Server-specific query designer

http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

Microsoft SQL Server 2008 Books Online (May 2009)

שלום רב,

מייקרוסופט שיחררה עדכון ל- Books Online לפלטפורמת sql server 2008.

להלן פרטים אודות העדכון:

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.

Books Online includes the following types of information:

* Setup and upgrade instructions.

* Information about new features and backward compatibility.
* Conceptual descriptions of the technologies and features in SQL Server 2008.
* Procedural topics describing how to use the various features in SQL Server 2008.
* Tutorials that guide you through common tasks.
* Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server 2008.
* Descriptions of the sample databases and applications that are available with SQL Server 200.

You can download the sample databases from the SQL Server Community Projects and Samples page on CodePlex.

לפרטים נוספים:

http://www.microsoft.com/downloads/details.aspx?FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97&displaylang=en

sp_clean_db_free_space - Clean Up Your SQL Server Databases

שלום רב,

כידוע service pack 3 של פלטפורמת sql server 2005 תיקן באגים רבים (http://support.microsoft.com/?kbid=955706).

אחד מהבאגים החשובים הינו - שימוש חוזר בעמודי זיכרון .
ע"פ עלון אבטחה של מיקרוסופט מס' MS08-0 , קיימת פגיעות של גילוי מידע באופן שבו SQL Server מנהל את השימוש החוזר בעמודי זיכרון. תוקף בעל גישה של מפעיל מסד נתונים שמצליח לנצל פגיעות זו עלול לגשת לנתוני לקוחות שאלמלא כן אסור היה לו לצפות בהם.

לפרטים נוספים:
להלן קישור לעלון האבטחה: https://www.microsoft.com.nsatc.net/israel/technet/security/Bulletin/MS08-040.mspx

מאמר של Kalen Delaney בנושא:
http://www.sqlmag.com/Articles/ArticleID/101551/101551.html?Ad=1

בהצלחה.

SQL Server 2008 R2

SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 by providing a wealth of new features and capabilities that can benefit your entire organization.

This release will further improve IT Efficiency with new and enhanced management capabilities and empower business users to access, integrate, analyze and share information using business intelligence tools they already know.

http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx

Change Manager 5.1 BETA Sign up

Next week Change Manager 5.1's BETA release will be available but to get your hands on it you need to join Embarcadero's BETA site and sign up:

http://beta.embarcadero.com

If you don't have an account, select "Click Here To Join" and create one. Once in the BETA site, you'll see Change Manager 5.1 listed right in the centre of the first page under "PROJECT OPPORTUNITIES". You can click to sign up, and when the BETA is ready you'll be notified and can access everything you need to get up and running through the site.

Here's a list of new features in 5.1:

· Automatically resolve schema and data comparison differences after the comparison runs
· Mask data to protect privacy when synchronizing data
· Oracle to SQL Server schema comparison
· Sybase to SQL Server schema comparison
· History of data comparison executions
· Project support so you can group jobs and scripts into projects and connect with various source code control repositories
· Email notification enhancements
· Alerts on the data comparison mapping page when tables and columns aren't fully paired and there's a possibility of issues (such as the target column being shorter than the source)
· Back/Next wizard actions on each job editor with instructions and setup feedback
· Full unicode support for databases around the world (coming in BETA 2)

5.1 has been in the making since January and the team and I are extremely proud of where the product's got to and are excited about where we want to go. Join the BETA and let us know what you think!

Alerts for when Login Failures Strike

When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?

http://www.sqlteam.com/article/alerts-for-when-logins-failures-strike