Azure Data Lake basics for the SQL Server DBA / developer and… for everyone!

The basics If you’re a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data Lake and would like to understand what it’s all about and how to get started, this article is for YOU….

Read More >

Powershell error: sqlps.ps1 cannot be loaded because running scripts is disabled on this system

An interesting issue came across my desk this week. One of our clients has a number of PowerShell tasks running on SQL Server Agent job. One day, the jobs suddenly stopped working due to the error below: Message Executed as…

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 >

Sharding a SQL Server database

This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets. Sharding, at its core, is breaking up a single, large database into multiple smaller, self-contained ones. This is usually done by companies that need…

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 >

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