Automation, PowerShell and Word Templates – let the technician do tech

In my work as a Database Consultant, I enjoy technical challenges, but it’s always a painful process when I need to transfer my technical knowledge into a report. Writing the report isn’t really the difficult part; the real challenge is…

Read More >

A quick guide to SQL server 2016 direct seeding

The Feature: SQL Server 2016 SP1 introduced direct seeding for Always ON Availability Groups. This is a short guide to understand what it is and some warnings when using it. The Problem: In previous versions than SQL Server 2016 ,…

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 >

Datascape podcast episode 2 – running SQL server on Linux – say whaaat??!

SQL Server is a conventional RDBMS created in partnership between Microsoft and Sybase in ~1989. Since then, SQL Server has only ever run on the Windows operating system. Infoworld ranked SQL Server as the second most popular database (along with…

Read More >

I’m launching a podcast!

Chris Presley announces the launch of The Datascape Podcast.

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 >
Page 5 of 22« First Page...34567...10...Last Page »