10 Things You Should Know about Microsoft Azure DevOps Server

Azure DevOps Server helps facilitate cross-functional software development and deployment.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Microsoft Bug Bounty Programs Underscore Commitment to Open Source

It’s important for Microsoft to get this right, and it's on the right path with bug bounty programs like the one in place for Azure DevOps Server.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Getting Started with Azure Data Studio and SQL Server 2019 Preview

SQL Server 2019 is in the final rounds of Community Technology Previews, and if I wasn’t excited about it before, I definitely am now.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

How to Prepare for SQL Server 2008 and 2008 R2 End of Support

Microsoft is set to end support for SQL Server 2008 and SQL Server 2008 R2 in July. Are you ready?
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

How to Determine Activity on Each Processor in SQL Server

The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Examining Scalar Function Performance in SQL Server

Each new release of SQL Server brings new DMOs. This article digs into dm_exec_function_stats, which made its debut in Microsoft SQL Server 2016.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

What Microsoft's Open Source PostgreSQL Acquisition Portends for SQL Server

Microsoft's acquisition of Citus Data expands on the Azure commitment to open source and may provide horizontal scaling for SQL Server.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Failover Detection Utility Simplifies Availability Group Failover Analysis

Microsoft's Failover Detection Utility eases failover analysis and provides quick root cause analysis.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Talking T-SQL (among Many Other Enterprise SQL Server Topics)

Microsoft experts discuss the current state of cloud adoption, T-SQL enhancements, the evolution of enterprise SQL Server performance tuning and mentorship.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

4 Online SQL Server Help Resources for DBAs ('Accidental' and Otherwise)

There are several good online SQL Server options DBAs can turn to for advice, support and help.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Are You Making the Right Cloud Storage Decisions for SQL Server tempdb?

Here's why selecting the right storage for SQL Server tempdb is critical, and how to determine what will work.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Azure Data Studio Takes SQL Operations Studio to the Next Level

Microsoft seems to be closing the gap between Azure Data Studio and SQL Server Management Studio, making the former a viable alternative for developers and DBAs alike.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Azure Data Studio Takes SQL Operations Studio to the Next Level

Microsoft seems to be closing the gap between Azure Data Studio and SQL Server Management Studio, making the former a viable alternative for developers and DBAs alike.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

PASS Summit Keynote Covers Broad Microsoft Data Platform Ground

Microsoft kicked off the PASS Summit with a keynote covering multiple initiatives across its broad data platform offerings.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Three Options for SQL Server Performance Tuning

With the increase in the use of the cloud--and the cloud's cost structure--SQL Server performance tuning is more important than ever.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

What You Need to Know about RPO and RTO

With clear RPO and RTO--as well as a solid plan that is tested, hardened and extensively redundant--you’ll be prepared to recover from most incidents you face.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Polybase Expansion, Big Clusters Are Key Features in the New SQL Server 2019

With the newly announced SQL Server 2019, Microsoft is expanding its bet on both open source technologies and Apache Spark.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

What You Need to Know about the Microsoft SQL Server 2019 Public Preview

There will likely be several revisions before SQL Server 2019 goes RTM, but now is a good time to check out some of the major changes in the database platform.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

4 Reasons Why Azure Databricks May Be in Your Future

Azure Databricks delivers Apache Spark-based analytics to the Microsoft Azure cloud.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools

Why You Should Be Using DBCC CLONEDATABASE for Performance Tuning Queries

Performance tuning queries on production databases happens, but it absolutely, positively shouldn't. Here's another, more efficient and safe, path to database optimization.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools