Microsoft SQL Server Resources

Microsoft SQL Server news and support resources, featuring the hottest solutions, technologies and vendors in the Microsoft SQL Server world. Use the powerful checkbox-driven menu to fine-tune the results to exactly what you are looking for in seconds!

Home Tag "Microsoft SQL Server"

Improving SQL Server Performance by 20X

Hyperconverged infrastructure is often used for applications including VDI and lightly loaded remote sites. So how does an organization that is looking to improve the performance of a mission-critical application such as Microsoft SQL Server end up with hyperconverged infrastructure? At this year’s Flash Memory Summit 2017, I presented a session where attendees could learn […]

File inclusions and exclusions in Veeam Backup & Replication

A few years ago, the file exclusion engine was introduced to Veeam Backup & Replication. This was primarily meant to handle situations such as a large set file data that you didn’t need in an image-based backup. One example I had users liked was a SQL Server (especially before Veeam Explorer for Microsoft SQL Server) […]

Microsoft Azure AD authentication extensions for Azure SQL DB and SQL DW tools

With the latest SQL server tools release we extended the Azure AD authentication support for SQL DB and DW tools for token-based authentication (Universal authentication) with MFA support. The following SQL Server tools have been extended adding new functionality: SSMS 17.2 supports the following functionalities: Multiple-user Azure AD authentication for Universal authentication with multi-factor support […]

Microsoft SQL Server 2017 Release Candidate 2 (RC2) is now available

Microsoft is pleased to announce availability of SQL Server 2017 Release Candidate 2 (RC2), which is now available for download. The release candidate represents an important milestone for SQL Server.  Development of the new version of SQL Server along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux, […]

Microsoft SQL Server 2016, Minimal logging and Impact of the Batchsize in bulk load operations

One of the design goals of SQL Server 2016 was to improve performance and scalability of the engine out of the box to make it run faster without the need of any knobs or trace flags for customers. As a part of these improvements, one of the enhancements made in the SQL Server engine code […]

Enabling IoT Scale with No Code Changes

ScaleArc customer Sixgill faces a tough data challenge – how do you scale your infrastructure to handle millions of new inputs, driven by location-based marketing at global events like the Rugby World Cup, without having to build and code for major fluctuations in infrastructure? Sixgill’s answer is to pair ScaleArc with AWS. That combination gives […]

Microsoft Azure Stack – Secure by Design

Previously I have blogged about the underlying architecture and features which is going to be part of Azure Stack → Microsoft recently announced the launch of Azure Stack as well → Responsibility model in Cloud Now I want to focus a bit on one aspect that was not included in the previous blogpost, […]

Microsoft SQL High CPU troubleshooting checklist

In this blog, I am covering the scenario of an approach to troubleshoot “SQL Server consuming High CPU” and few checklist points which will help in isolating/troubleshooting. Below screenshot summarizes an approach to isolate SQL high CPU issues: CHECKLIST POINTS: 1. From Windows task manager check the overall CPU utilization. Collect the details of number of […]

How to simplify your SQL tasks with SQLDocKit – On-Demand Webinar

Whether you’re a DBA, consultant, or your organization’s IT person responsible for managing SQL Servers, SQLDocKit can help you with your daily time-consuming administrative tasks: Get complete insight into your SQL environment and generate documentation Audit SQL Server configuration and prevent common problems from occurring Track changes and detect differences in your SQL environment Manage […]

AWS Hands on Lab Video: Introduction to Microsoft SQL Server in AWS

Amazon Web Services
Organizations are quickly moving database workloads like SQL Server to the cloud, but with so many options, the best approach isn’t always obvious. You exercise full control of your SQL Server workloads by running them on Amazon EC2 instances, or leverage Amazon RDS for a fully managed database experience. This session will cover best practices […]

Microsoft: Artificial Intelligence tunes Azure SQL Databases

Automatic tuning To stay competitive, today’s businesses need to make sure that they focus on their core competencies that directly deliver customer value while relying on their cloud provider to offer an affordable, reliable, and easy to use computing infrastructure that scales with their needs. In the world of cloud services, where many aspects of […]

Microsoft: Tableau and Azure SQL DB, a match made in the cloud

In recent years, Microsoft SQL and Tableau Engineering teams have been working closely together to provide a superior user experience with the two platforms. Today we are sharing some advice on how to optimize the connectivity between Azure SQL DB and Tableau. Our teams previously teamed up for the SQL Server 2016 launch and for […]

Microsoft Public Preview of compatibility Level 140 for Azure SQL Databases

We are announcing the official public preview of compatibility level 140 in Azure SQL Database. Compatibility level 140 enables the following query optimizer changes: A trivial plan referencing Columnstore indexes will be discarded in favor of a plan that is eligible for batch mode execution. The sp_execute_external_script UDX operator is eligible for batch mode execution. […]

Microsoft: What’s new in SQL Server 2017 RC1 for Analysis Services

The RC1 public preview of SQL Server 2017 is available here! It includes Dynamic Management View improvements for tabular models with compatibility level 1200 and 1400. DMVs are useful in numerous scenarios including the following. Exposing information about server operations and health. Documentation of tabular models. Numerous client tools use DMVs for a variety of […]

Visit our Sponsors!