Normalize your database tables for optimal flexibility

Though the nature of applications has changed greatly over the years, some of the basic concepts of working with data are foundational, and do not, or at least should not, change. One of the precepts of Data Modeling is normalization;…

Read More >

How many sessions are enough for your application servers?

How much sand can you pour through a funnel? Perhaps this is something you have tried to do at some time. If you have, you would have found that to do so successfully it is necessary to control how much…

Read More >

Microsoft SQL Server on Linux – installation (Ubuntu)

With the release of Microsoft SQL Server 2017 (SQL Server 2017) comes the ability to run SQL Server on the Linux Operating Systems. With Linux being the platform of choice for millions of application developers this is a smart move by…

Read More >

Microsoft Azure IaaS SQL Server best practices

Modern cloud IAAS offerings are sold as a fast and convenient way to setup a server without having to worry about purchasing hardware, networking, and basic installation/configuration work. For the most part, I believe this is true, and they’ve fulfilled…

Read More >

Microsoft SQL Server 2017: identity_cache and select into filegroup

Microsoft SQL Server 2017: Two Useful New Features This week I discovered two new features in Microsoft SQL Server 2017 that I think will be helpful to both developers and DBAs. These are two small changes, but they solve problems…

Read More >

Dbatools and a SQL Agent

The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think that is? Freedom! Freedom to go work on projects that you want to do versus constantly putting out…

Read More >

How to analyze SQL server stack dumps

As a SQL Server production DBA, at some point in time you will have to deal with a stack dump. A stack dump is a file that is written to disk with an “.mdmp” extension when SQL Server encounters a…

Read More >

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