SQL Resources

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

Home Tag "SQL"

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) […]

User Environment Management Feature Release 2 Highlights

Last week heralded the release of Ivanti User Workspace Manager 10.1 Feature Release 2 (FR2) – formerly known as AppSense DesktopNow Plus – including updates to Environment Manager (EM), Management Center (MC), Application Control (AC) and Performance Manager (PM). Let’s take a quick look at some of the highlights of this release… GeoSync [Ivanti Environment […]

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 […]

Citrix Monitoring at a 50,000ft View – Down to the End-User Level

Goliath Technologies
We at Goliath Technologies have designed a new tool within our Goliath Performance Monitor, intended to provide Citrix IT professionals the ability to see their entire Citrix infrastructures (and its surrounding elements such as SQL databases, domain controllers, hypervisors, and more) from a 50,000ft view, with drill-down capabilities down to the end-user level. More Info: […]

Dell EMC Unity 4.2 Release

Dell EMC™ has just released a new Dell EMC Unity All-Flash portfolio: the 350F, 450F, 550F, and 650F. These new all-flash arrays are based on the latest Intel® Broadwell chip. Additionally, they are loaded up with twice the memory and up to 40 percent more processor cores than previous Dell EMC Unity models. What does […]

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, […]

AWS KC Videos: How do I migrate to Amazon RDS for MySQL using AWS DMS?

Amazon Web Services
Find more details in the AWS Knowledge Center: https://aws.amazon.com/premiumsupport/knowledge-center/migrate-mysql-rds-dms/ Viqash, an AWS Cloud Support Engineer, shows you how to migrate to Amazon RDS for MySQL using AWS DMS. This video is from the fine folks at Amazon Web Services (AWS).

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 → http://msandbu.org/what-is-azure-stack-and-want-is-the-architecture/ Microsoft recently announced the launch of Azure Stack as well → https://azure.microsoft.com/en-us/blog/microsoft-azure-stack-is-ready-to-order-now/ 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 […]

Visit our Sponsors!