Tag: Microsoft SQL Server

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

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Azure SQL Managed Instance: New Member of the Family!

SQL Server is one of Microsoft’s strongest enterprise software products. Both in terms of revenue and industry reputation, it is widely adopted for its ease of use while at the same time offering high end features in terms of security,…

Read More >

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