Stairway 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 onContinua a leggere “Stairway to SQL Server on Linux”

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)Continua a leggere “A SQL Server hardware nugget a day”

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 DayContinua a leggere “A DMV a day”

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 SnippetsContinua a leggere “31 days with SQL Server Management Studio”

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)Continua a leggere “A SQL Server DBA myth a day”