BLOGS ARTICLES

How to use a SSIS Package as a view in a database

by Antonios Chatzipavlis

Σε αυτό το επισόδειο σας παρουσίαζω το πως μπορείτε ένα SSIS Package να χρησιμοποιείται σαν view μέσα στην database σας.


SQL TRAINING NIGHTS

Statistics and Index Internals

Στην παρουσίαση αυτή εξηγούμε την σημασία των στατιστικών και πως αυτά επιρεάζουν το performance των queries καθώς επίσης και το πως πρέπει να φτιάξω τους κατάλληλους indexes


WEB CASTS

Troubleshooting with the Plan Cache

The plan cache can be a useful source of information when you are troubleshooting query performance problems. This video covers issues you should be aware of when using the plan cache as a troubleshooting tool, in addition to performance problems that may arise in the plan cache itself.



SQL SERVER NEWS
Cumulative Update #11 for SQL Server 2017 RTM

The 11th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

Cumulative Update #3 for SQL Server 2016 SP2

The 3rd cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

Persisting job history in Azure SQL Managed Instance

Azure SQL Managed Instance is a fully managed SQL Server hosted in Azure cloud. Although it supports many SQL Server features, there are some constraints compared to SQL Server that you manage. One of the constraint that might be an issue is the fact that SQL Agent keeps a limited history of job executions that cannot be changed. In this post you will see one way to workaround this.

Cloud Data and AI Services training roundup September 2018

To help you stay up to date on online training opportunities, we’re releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post.

Enter Data feature now available in SQL Server 2016 Report Builder

We recently released a new version of SQL Server 2016 Report Builder that contained a brand new feature – the ability to enter data directly into an RDL report as an embedded dataset. This new feature is similar to the one found in Power BI Desktop. Now, customers can either type the data in directly into a dataset in their report, or paste it in from another program like Microsoft Excel. Once users have created their dataset by entering data, they can use it just like they would any other embedded dataset they’d created. This feature is especially useful for small, static datasets you might need to use in your report like report parameters.

SSMS 17.9 is now available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9!