Category «SQL Servers»

Data Virtualization in SQL Server 2019

SQL Server 2019 CTP 2.2 has lots of enhancement in particular Data Warehouse(DW) and Big Data management. This post is not a “what’s new in…” post so after some brief explanations we’re going to create “virtual tables” in SQL Server that represent MongoDB table and will be able to query from SQL Server to data …

SQL Server 2016 Table Partitioning

SQL Server 2016 Standart Edition supports table partitioning. Yeah I was amazed and pleased like everybody this feature come in Standart edition. It’s available after you install SQL Server 2016 SP1 package. Table partitioning is frankly not a complete solution to get more query performance in SQL Server but it’s almost indispensable helper if considering …