search

searching on site content

1 2 3 4 5 6 

Book - 01 Jan 2000

Backup and Restore of SQL Server Databases

This book describes the benefits of backing up SQL Server databases, basic backup and restore terms, and introduces backup and restore strategies for SQL Server and security considerations for SQL Server backup and restore.

EPUB | MOBI | PDF | Source content


Book - 01 Jan 2000

Monitor and Tune for Performance

The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Ongoing evaluation of the database performance helps you minimize response times and maximize throughput, yielding optimal performance.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

SQL Server Distributed Replay

The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

SQL Server 2012 Tutorials: Analysis Services - Data Mining

Microsoft SQL Server Analysis Services makes it easy to create sophisticated data mining solutions. The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services, so that you can perform advanced analysis to solve business problems that are beyond the reach of traditional business intelligence methods.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling

This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling

This tutorial provides lessons on how to create a SQL Server 2012 Analysis Services tabular model running in In-Memory mode by using SQL Server Data Tools (SSDT).

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

SQL Server 2012 Tutorials: Reporting Services

This book contains tutorials for SQL Server 2012 Reporting Services: Create a Data-Driven Subscription, Create a Basic Table Report,  Create a Sample Report in Power View, and Optimize a Sample PowerPivot Model for Power View Reports.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

Master Data Services Capacity Guidelines

This document provides capacity planning guidelines for Microsoft SQL Server 2012 Master Data Services (MDS).

EPUB  | MOBI  | PDF  | Source content


Book - 01 Jan 2000

SQL Server 2012 Upgrade Technical Guide

This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012.

EPUB | MOBI  | PDF 


Book - 01 Jan 2000

Data Analysis Expressions (DAX) Reference

The Data Analysis Expressions (DAX) language is a library of functions and operators that can be combined to build formulas and expressions.

EPUB | MOBI| PDF | Source content


Book - 01 Jan 2000

Data Quality Services

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data.

EPUB | MOBI  | PDF  | Source content


Book - 01 Jan 2000

Master Data Services

Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation and restructuring of internal business processes along with the implementation of MDM technology. The result of a successful MDM solution is reliable, centralized data that can be analyzed, resulting in better business decisions.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

QuickStart: Learn DAX Basics in 30 Minutes

This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems.

EPUB | MOBI  | PDF  | Source content 


Book - 01 Jan 2000

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.

A key goal of this paper is to establish a common context for related discussions between business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators.

EPUB | MOBI  | PDF  | DOC | Source content  


Book - 01 Jan 2000

Transact-SQL Data Manipulation Language (DML) Reference

Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database.

EPUB  | MOBI | PDF  | Source content 


Book - 01 Jan 2000

Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide

Download this book to learn about Analysis Services Multidimensional performance tuning from an operational and development perspective. This book consolidates the previously published SQL Server 2008 R2 Analysis Services Operations Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single publication that you can view on portable devices.

EPUB | MOBI  | PDF  | Source content 1  | Source content 2 


SQL Server News - 07 Oct 2017

Released: Public Preview for SQL Server 2017+ and Replication Management Pack (RC)

We are happy to announce SQL Server 2017+ Management Pack Release Candidate with new features is ready (6.7.65.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).


Book - 01 Jan 2000

Multidimensional Expressions (MDX) Reference

Multidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in Microsoft Analysis Services. MDX is based on the XML for Analysis (XMLA) specification, with specific extensions for SQL Server Analysis Services. MDX utilizes expressions composed of identifiers, values, statements, functions, and operators that Analysis Services can evaluate to retrieve an object (for example a set or a member), or a scalar value (for example, a string or a number).


EPUB | MOBI  | PDF  | Source content 


SQL Server News - 09 Nov 2019

Big news for SQL Server 2019 Standard Edition supported features

SQL Server 2019 Standard Edition now has additional new capabilities.


Article - 08 Nov 2019

How to interpreting the results of DMV sys.dm_os_performance_counters

Η καθημερινότητα ενός DBA μόνο απλή δεν είναι, αν και πολλοί πιστεύουν αυτό. Καθημερινά πρέπει να φροντίζει ώστε τα instance/databases του να είναι σε εύρυθμη λειτουργία.


SQL Server News - 24 Sep 2019

SQL Server Management Studio 18.3 is now generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.3. For this update, while we added some features, our focus was primarily on fundamentals such as stability, reliability, and performance.


SQL Server News - 24 Sep 2019

Hot Patching SQL Server Engine in Azure SQL Database

Azure SQL Database is evergreen, meaning that it always has the latest version of the SQL engine, but maintaining this evergreen state requires periodic updates to the service that can take the database offline for a second.


SQL Server News - 10 Sep 2019

The September release of Azure Data Studio is now available

Today were announcing the September release of Azure Data Studio is now available.


Article - 08 Sep 2019

How to not make a disaster view

Όλοι γνωρίζουμε ότι ένα view είναι ένα stored query expression το οποίο ορίζει τι θα επιστρέφει το συγκεκριμένο view. Με απλά λόγια είναι ένα SELECT statement. Όμως τις φτιάχνουμε σωστά ώστε να δουλεύουν και σωστά;


SQL Server News - 04 Sep 2019

SQL Server 2019: Not your Grandpa's SQL Server

If you have been keeping up with what's new in the land of SQL Server, you probably know we have been working on a new release called SQL Server 2019. - Article by Bob Ward - Principal Architect at Microsoft


SQL Server News - 30 Aug 2019

Azure Feature Pack 1.14.0 released with Azure Data Lake Storage Gen2 Support

Azure Feature Pack 1.14.0 is here, which enables you to connect to Azure Data Lake Storage Gen2 (ADLS Gen2).


SQL Server News - 29 Aug 2019

SQL Server 2019 release candidate refresh with Big Data Clusters

In continuation with our announcement of SQL Server 2019 release candidate last week, we’re announcing that the release candidate refresh for SQL Server 2019 is now available to download. The release candidate now includes bits for Big Data Clusters in SQL Server 2019 in this refresh.


SQL Server News - 29 Aug 2019

SQL Server 2019 release candidate refresh with Big Data Clusters

In continuation with our announcement of SQL Server 2019 release candidate last week, we’re announcing that the release candidate refresh for SQL Server 2019 is now available to download. The release candidate now includes bits for Big Data Clusters in SQL Server 2019 in this refresh.


Article - 28 Aug 2019

Azure Data Studio – My Experience

Όταν ασχολείσαι με το SQL Server 24 χρόνια έχεις μάθει να κάνεις πράγματα από συνήθεια. Αυτή η συνήθεια δεν είναι κακή αρκεί να έχεις τα αυτιά και τα μάτια σου ανοικτά στο μέλλον.


Article - 21 Aug 2019

Database Mail Administration Summary

Το DBMail είναι κάτι που χρόνια έχουμε στον SQL Server και βασικό σκοπό έχει να στέλνει notifications είτε από alerts είτε από jobs. Φυσικά μπορείς να κάνεις και άλλα πράγματα αλλά δεν είναι σε καμία περίπτωση αντικαταστάτης ενός mail server.


SQL Server News - 16 Aug 2019

Behind the Scenes on OPTIMIZE_FOR_SEQUENTIAL_KEY

Article by Pam Lahoud Microsoft


SQL Server News - 15 Aug 2019

The August release of Azure Data Studio is now available

Today we’re announcing the August release of Azure Data Studio is now available.


SQL Server News - 11 Jun 2019

Announcing preview of Azure Data Share

Azure Data Share maximizes access to simple and safe data sharing for organizations in many industries. For example, retailers can leverage Azure Data Share to easily share sales inventory and demographic data for demand forecasting and price optimization with their suppliers.


Article - 22 May 2019

Discover Orphaned Domain Logins using sp_validatelogins

Ένα περιβάλλον παραγωγής δεν είναι ποτέ το ίδιο κατά την διάρκεια λειτουργίας του και αυτό είναι φυσιολογικό καθώς οι ανάγκες οδηγούν στις μεταβολές του. Ένα σημείο που αλλάζει συχνά είναι η δικαιοδοσία των χρηστών.


Article - 12 Apr 2019

The sys.dm_exec_query_stats DMV

Ένα από τα πράγματα που κάνω στην δουλειά μου είναι πηγαίνω σε πελάτες και να τους βοηθάω να λύσουν τα προβλήματα τους. Αυτό σημαίνει ότι έρχομαι αντιμέτωπος με instances που δεν γνωρίζω και πρέπει να μάθω για αυτά. Έτσι εκτελώ αρκετά scripts που έχω γράψει για να συλλέξω τις πληροφορίες που θέλω.


SQL Server News - 28 Mar 2019

SQL Server Management Studio 18.0 Release Candidate 1 is now available

As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on what’s included, please see the Release Notes.


SQL Server News - 27 Mar 2019

SQL Server 2019 community technology preview 2.4 is now available

Continuing with our monthly release cadence, we’re excited to announce the release of SQL Server 2019 community technology Preview 2.4.


SQL Server News - 26 Mar 2019

What’s new for SQL Server 2019 Analysis Services CTP 2.4

We are excited to announce the public CTP 2.4 of SQL Server 2019 Analysis Services. This public preview includes the following enhancements for Analysis Services tabular models.


SQL Server News - 23 Jan 2019

Cumulative Update #5 for SQL Server 2016 SP2

The 5th cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site.


SQL Server News - 10 Jan 2019

The January release of Azure Data Studio

The January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available.


Article - 09 Jan 2019

Cosmos DB Querying and Manipulate data

Σε κάθε database το βασικό και πρακτικό ερώτημα είναι το πως διαβάζω και επεξεργάζομαι δεδομένα και αυτά παρουσιάζονται στο άρθρο αυτό.


Article - 04 Jan 2019

Cosmos DB Design considerations

Κάθε database system έχει τις ιδιαιτερότητες του και καλό είναι να γνωρίζουμε όσα περισσότερα για αυτές καθώς έτσι θα είμαστε σε θέση να σχεδιάζουμε καλύτερες λύσεις.


SQL Server News - 18 Dec 2018

Confidential computing using Always Encrypted with secure enclaves in SQL Server 2019 preview

Always Encrypted with secure enclaves allows rich computations on encrypted data, boosts performance when encrypting


Article - 15 Dec 2018

SPIDs with negative number (-2,-3,-4)

Μπορεί να είναι σπάνιο αλλά κάποια στιγμή μπορεί να το βρείτε μπροστά σας και καλό είναι να ξέρετε τι είναι το κάθε αρνητικό SPID.


SQL Server News - 11 Dec 2018

Announcing SQL Server 2019 CTP 2.2

Microsoft is now pleased to announce SQL Server 2019 community technology preview 2.2, the third in a monthly cadence of preview releases.


SQL Server News - 22 Nov 2018

SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1.


Article - 04 Nov 2018

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

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


Article - 25 Oct 2018

Scripting Full Text Search Indexes

Σε αυτό το επεισόδιο ασχολούμαστε στο πως μπορούμε να δημιουργήσουμε τα create scripts για τουs full text indexes και μόνο.


Article - 09 Oct 2018

How to make SSMS tabs more readable

Σε αυτό το επεισόδιο θα σας παρουσιάζω ένα tip που ίσως σας βοηθήσει στην καθημερινότητα σας με την χρήση του SSMS.


Article - 06 Oct 2018

How database files are growing?

Σε αυτό το επεισόδιο SQL Server in Greek θα θούμε πως μπορούμε να κατανοήσουμε το τρόπο με τον οποίο μεγαλώνουν τα αρχεία τις κάθε database.


1 2 3 4 5 6 
Follow us in
PASS chapter logo

The Official PASS Local Group for Greece

sql school greece logo
© 2010-2019 All rights reserved