Tag: Microsoft SQL Server

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

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Read More >

SQL Server Default Configurations That You Should Change

Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company has specific Post-Installation Tasks procedures/document, SQL Server configurations are left as is until an issue comes along. If you are doing your…

Read More >

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 >
Page 1 of 5112345...10...Last Page »