SQL Server Partitioning: Managing Large Tables

Table partitioning splits large tables into smaller, manageable pieces while appearing as one table. Essential for billion-row tables. Partition Function Partition Scheme Partitioned Table Benefits Fast archival with partition switching Partition elimination…

Azure in China

Microsoft Azure presence in China is always a question when there is a need for any customer to deploy azure applications specifically for Chinese Regional customers. Recently I had an interaction with…

.NET4 min read

Visual Studio 2015 – ctp6

Microsoft today has released Visual Studio 2015 Community Technology Preview 6 (CTP 6), which includes some new features and improvements, such as new UI debugging tools for XAML, new Control Flow Guard security tool,…

.NET1 min read

Brief on SQLCLR

Brief on SQLCLR SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to…

All1 min read