Tag: Microsoft SQL Server

Australian Red Cross gains speed, stability, and savings by optimizing cloud platforms

When the Australian Red Cross, a leading humanitarian aid and community services charity and an auxiliary to the Australian government, realized that their data platform was no longer performing optimally for their critical applications, they turned to Pythian for help….

Read More >

Microsoft Ignite 2018 special cloudscape podcast

This episode of the Cloudscape podcast is dedicated to the announcements that were made at the recent Microsoft Ignite 2018 conference. We are joined solely by Warner Chaves to walk us through the most important and exciting announcements from the…

Read More >

Analytics in the cloud – Azure analysis services

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Advanced mashups and modeling features are used to combine data from multiple data sources, define metrics and secure your data…

Read More >

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on a Windows 2012 environment. You will quickly find out that there are a number of compatibility issues that can make…

Read More >

Data classification with Microsoft SQL Server and Azure SQL DB (GDPR, PII, HIPPA…etc)

This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let’s start by explaining what data discovery and classification is and why is it important. Data discovery is not…

Read More >

SQL Server storage review using PowerShell

Problem There’s no doubt that storage is one of the key components to SQL Server performance and availability for both large and small SQL Server instances. With today’s increases in server and virtual server processing power and large-scale memory support,…

Read More >

SQL Server and Azure – hybrid partitioning – a low-cost solution to retain your data

It’s already a fact: cloud is here to stay. As time goes by, we have a better understanding of how it really works as well as its real pros and cons. But here is the most important lesson: We don’t…

Read More >

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

It’s not uncommon to have authentication issues with Microsoft SQL Server. Not only with users trying to access the server, but problems related to the connection between instances, like AlwaysOn Availability Groups. The traditional way to solve it is well…

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