Pubblicato il

Presentato il nuovo servizio Azure Synapse Link (in preview)

Tra le novità di questa edizione di Build, la presentazione del servizio Azure Synapse Link, che consente l’interrogazione diretta dei dati memorizzati in CosmosDB da Azure Synapse.

Questo significa che possiamo eliminare il flusso di importazione dei dati da CosmosDB verso Synapse, risparmiando tempo e spazio occupato, interrogando direttamente i dati alla fonte, restando sempre in Azure.

Animation showing that with Azure Synapse Link, complex ETL processes are no longer needed. Azure Synapse Link establishes a link between operational data stored in Azure Cosmos DB and Azure Synapse Analytics, providing clarity in an instant.

Se vi interessa l’argomento, in questo video di Microsoft Mechanics Ranghu Ramakrishnan presenta le principali caratteristiche ed utilizzi di questo servizio:

Pubblicato il

Azure Data Studio: release di Aprile 2020

E’ disponibile la nuova versione di Aprile 2020 del tool Azure Data Studio. Clicca qui per il download.

Una nota: dopo aver scaricato ed installato questa versione, occorre rispondere Si per abilitare le funzionalità in anteprima.

Tra le novità di questa release:

  • Aggiunta una nuova Welcome page
  • Aggiunta una nuova toolbar per la modifica dei markdown
  • Supporto per l’estensione KQL magic nei notebooks
  • Salvataggio dei grafici nei notebooks SQL
  • Miglioramenti grafici alle dashboard
  • Supporto alle query su campi criptati con Always Encrypted

L’articolo completo lo trovate qui.

Pubblicato il

Stairways to SQL Server on Linux

Beh, visto che l’argomento mancava, mi sono chiesto se potessi scrivere qualcosa riguardo a SQL Server per Linux, che come ormai noto anche ai sassi, dalla versione 2017 può essere installato su Windows, Linux e containers (Docker, Azure Container Instance, Azure Kubernetes Services, etc).

Qui, trovate l’indice completo della serie “Stairway to SQL Server on Linux”:

Level 1 – Installing Ubuntu
Level 2 – Installing database server
Level 3 – Adding disks
Level 4 – Using Client Tools
Level 5 – SQL Server Agent

Enjoy SQL Server (on Linux) !

AGGIORNAMENTO: per chi volesse installare SQL Server 2017 su Ubuntu 18.04, è disponibile la guida del Tiger Team di SQL Server su come farlo, sfruttando la Cumulative Update 10 di SQL Server 2017 che elimina le dipendenze dai vecchi package di Ubuntu e li sostituisce con quelli della versione 18.04.

Pubblicato il

SQL Server DBA tips

by Ted Krueger

SQL Server DBA Tip 1 – Server Configuration – MAX Memory
SQL Server DBA Tip 2 – Server Configuration – Data/Log Files
SQL Server DBA Tip 3 – Server Configuration – Model Database
SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit
SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS)
SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication
SQL Server DBA Tip 7 – Server Security and grouping – Schema Control
SQL Server DBA Tip 8 – Server Monitoring – Baseline
SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace
SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor
SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory
SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV
SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions
SQL Server DBA Tip 14 – SQL Server General – Updating Production Data
SQL Server DBA Tip 15 – SQL Server Agent – Job ownership
SQL Server DBA Tip 16 – Working with Files and Folders

Pubblicato il

A DMV a day

by Glen Berry

Day 1 sys.dm_os_buffer_descriptors
Day 2 sys.dm_exec_sessions
Day 3 sys.dm_os_sys_info
Day 4 sys.dm_os_sys_memory
Day 5 sys.dm_db_mirroring_auto_page_repair
Day 6 sys.dm_db_index_usage_stats
Day 7 sys.dm_db_missing_index_group_stats
Day 8 sys.dm_fts_active_catalogs
Day 9 sys.dm_os_schedulers
Day 10 sys.dm_exec_procedure_stats
Day 11 sys.dm_db_index_usage_stats
Day 12 sys.dm_db_partition_stats
Day 13 sys.dm_io_virtual_file_stats
Day 14 sys.dm_os_wait_stats
Day 15 sys.dm_os_performance_counters
Day 16 sys.dm_exec_cached_plans
Day 17 sys.dm_db_index_usage_stats
Day 18 sys.dm_clr_tasks
Day 19 sys.dm_os_wait_stats
Day 20 sys.dm_exec_cached_plans
Day 21 sys.dm_os_ring_buffers
Day 22 sys.dm_exec_query_memory_grants
Day 23 sys.dm_os_process_memory
Day 24 sys.dm_exec_requests
Day 25 sys.dm_os_memory_cache_counters
Day 26 sys.dm_exec_procedure_stats
Day 27 sys.dm_tran_locks
Day 28 sys.dm_io_pending_io_requests
Day 29 sys.dm_exec_connections
Day 30 sys.dm_os_buffer_descriptors

Pubblicato il

A SQL Server hardware nugget a day

by Glen Berry

Day 1  (Westmere-EP)
Day 2 (Westmere-EX)
Day 3 (AMD Opteron 6100)
Day 4 (AMD Bulldozer)
Day 5 (Hardware ID – DMVs)
Day 6 (Hardware ID – Built-in)
Day 7 (CPU-Z)
Day 8 (Recommended Intel Processors)
Day 9 (Recommended AMD Processors)
Day 10 (Old Intel Processor Numbering)
Day 11 (New Intel Processor Numbering)
Day 12 (AMD Processor Numbering)
Day 13 (Intel Turbo Boost)
Day 14 (Intel Tick Tock Release Strategy)
Day 15 (Power Plans and CPU performance)
Day 16 (SQL Server 2008 R2 and Hardware)
Day 17 (Geekbench)
Day 18 (AMD Turbo CORE)
Day 19 (RAID Controllers)
Day 20 (Building a Desktop Test System)
Day 21 (Processor Cache Size)
Day 22 (32-bit vs. 64-bit)
Day 23 (Two Socket vs. Four Socket)
Day 24 (TPC-E Benchmark)
Day 25 (DB Server Processor Selection)
Day 26 (Laptop Processor Selection)
Day 27 (Crystal DiskMark)
Day 28 (Intel Chipsets and SSDs)
Day 29 (Hardware Resiliency)
Day 30 (RAID Level Primer)

Glenn ha pubblicato anche il libro SQL Server Hardware, che potete scaricare gratuitamente in format pdf dall’ottima libreria di Red-Gate !

Pubblicato il

An XEvent a day

di Jonathan Kehayias

(1 of 31) – An Overview of Extended Events
(2 of 31) – Querying the Extended Events Metadata
(3 of 31) – Managing Event Sessions
(4 of 31) – Querying the Session Definition and Active Session DMV’s
(5 of 31) – Targets Week – ring_buffer
(6 of 31) – Targets Week – asynchronous_file_target
(7 of 31) – Targets Week – bucketizers
(8 of 31) – Targets Week – synchronous_event_counter
(9 of 31) – Targets Week – pair_matching
(10 of 31) – Targets Week – etw_classic_sync_target
(11 of 31) – Targets Week – Using multiple targets to simplify analysis
(12 of 31) – Using the Extended Events SSMS Addin
(13 of 31) – The system_health Session
(14 of 31) – A Closer Look at Predicates
(15 of 31) – Tracking Ghost Cleanup
(16 of 31) – How Many Checkpoints are Issued During a Full Backup?
(17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)
(18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)
(19 of 31) – Using Customizable Fields
(20 of 31) – Mapping Extended Events to SQL Trace
(21 of 31) – The Future – Tracking Blocking in Denali
(22 of 31) – The Future – fn_dblog() No More? Tracking Transaction Log Activity in Denali
(23 of 31) – How it Works – Multiple Transaction Log Files
(24 of 31) – What is the package0.callstack Action?
(25 of 31) – The Twelve Days of Christmas
(26 of 31) – Configuring Session Options
(27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1
(28 of 31) – Tracking Page Compression Operations
(29 of 31) – The Future – Looking at Database Startup in Denali
(30 of 31) – Tracking Session and Statement Level Waits
(31 of 31) – Event Session DDL Events

Pubblicato il

31 days with SQL Server Management Studio

Una interessante panoramica sulle funzionalità del SQL Server Management Studio scritta da Russ Thomas.

Day 1:    Knowing Options Leads to Shortcuts
Day 2:    Query Like a Pro
Day 3:    Query Like a Boss
Day 4:    Query Like a God
Day 5:    Generating Scripts (pre-written code 1)
Day 6:    Leveraging Templates (pre-written code 2)
Day 7:    Leveraging Snippets (pre-written code 3)
Day 8:    Debugging T-SQL with SSMS
Day 9:    Team Debugging with SSMS
Day 10:  Remote Debugging with SSMS
Day 11:  Working With Designers
Day 12:  Modifying Toolbars
Day 13:  Customizing Connections
Day 14:  Registered Servers / Server Groups
Day 15:  Central Management Server
Day 16:  Monitoring with SSMS
Day 17:  SSMS and SQL Utility
Day 18:  SSMS and MDW
Day 19:  SSMS and Extended Events
Day 20:  SSMS Solutions, Projects, Source Control
Day 21:  SSMS and DacPac
Day 22:  SSMS and ETL (import / export wizard)
Day 23:  Get Fancy with Results
Day 24:  SSMS in SQLCMD Mode
Day 25:  Database Diagraming
Day 26:  Maintenance Plans
Day 27:  Building a Custom Add-In / Extension
Day 28:  Deploying the Add-In
Day 29:  Identifying Options & Debugging Add-In
Day 30:  Moving from Add-In to VSPackage
Day 31:  Wrap Up / Review / Stuff I Didn’t Cover

Pubblicato il

A SQL Server DBA myth a day

di Paul Randal

(1/30) in-flight transactions continue after a failover
(2/30) DBCC CHECKDB causes blocking
(3/30) instant file initialization can be controlled from within SQL Server
(4/30) DDL triggers are INSTEAD OF triggers
(5/30) AWE must be enabled on 64-bit servers
(6/30) three null bitmap myths
(7/30) multiple mirrors and log shipping load delays
(8/30) unicorns, rainbows, and online index operations
(9/30) data file shrink does not affect performance
(10/30) database mirroring detects failures immediately
(11/30) database mirroring failover is instantaneous
(12/30) tempdb should always have one data file per processor core
(13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)
(14/30) clearing the log zeroes out log records
(15/30) checkpoint only writes pages from committed transactions
(16/30) corruptions and repairs
(17/30) page checksums
(18/30) FILESTREAM storage, garbage collection, and more
(19/30) TRUNCATE TABLE is non-logged
(20/30) restarting a log backup chain requires a full database backup
(21/30) corruption can be fixed by restarting SQL Server
(22/30) resource governor allows IO governing
(23/30) lock escalation
(24/30) twenty six restore myths
(25/30) fill factor
(26/30) nested transactions are real
(27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB
(28/30) BULK_LOGGED recovery model
(29/30) fixing heap fragmentation
(30/30) backup myths