Tag: Microsoft SQL Server

Building SQL Server Failover Cluster Instances in the Cloud with Windows Server 2016 Storage Spaces Direct

Storage Spaces Direct (S2D) is a new feature of Windows Server 2016 that takes the ‘software-defined storage’ concept to the next level. The value proposition is that instead of deploying expensive SAN hardware, similar results can be achieved by pooling…

Read More >

Extended Events – Fetching API CURSORS

Forum questions can sometimes cause distractions for me because they pique my interest at times, especially when I see someone say “Extended Event (XE) session is not showing the expensive query”. Extended Events are just… The particular forum question that…

Read More >

How to Store Performance Counters Directly on SQL Server Using TypePerf Command

Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive troubleshoot to discover potential problems in your SQL Server environment. The baseline is a key point to measure the instance performance…

Read More >

Automate SQL Server Version and Database Compatibility Report Using PowerShell

Sandeep Arora, SQL Server Database Consultant, provides a script for automating SQL Server Version and Database Compatibility Report by using PowerShell.

Read More >

SQL Server Security Review Using PowerShell

Sandeep Arora, SQL Server Database Consultant, explains how to automate a SQL Server Security review using PowerShell.

Read More >

Log Buffer #482: A Carnival of the Vanities for DBAs

Fahd Mirza, Oracle Database Administrator at Pythian, highlights top blogs posts in the worlds of Oracle, SQL Server and MySQL.

Read More >

Transparent Data Encryption for SQL Server in an Availability Group

Daniel Holt, Database Administrator at Pythian, discusses transparent data encryption for SQL Server in an availability group.

Read More >

Installing SQL Server 2016 – Standalone Instance – New Features

Daniel Holt, Database Administrator at Pythian, provides a step-by-step guide to installing SQL Server 2016, and highlights some of the new installation features.

Read More >

Installing Sample Databases To Get Started In Microsoft SQL Server

Daniel Holt, Database Administrator at Pythian, provides some examples of databases to work on, for new and future DBAs/Developers.

Read More >

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Michelle Gutzait, one of Pythian’s SQL Server Experts, discusses how to migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication.

Read More >
Page 1 of 5012345...10...Last Page »