The SQL Geek's Blog

This is the first Blog I am doing in a series on Storage and Disks. It is important to understand the “Black Box” so that the proper Architecture can be designed to maximize the value of the technology investment. Disks Types The type of hard drive utilized in the host server or the […]

I have been a on few calls with my customers lately and there seems to be confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS. So I thought I would post a blog entry on it. First ADF is not “SSIS in the cloud”. What makes them different you might ask? SSIS […]

With current regulations such as SOX, HIPAA, etc., protecting sensitive data is a must in the enterprise. There is a published toolkit to implement Row Level Security (RLS) and Cell Level Security (CLS) using SQL Server Label Security Toolkit which is a free download from CodePlex http://sqlserverlst.codeplex.com/. It makes use of a Security label […]

Understanding Fragmentation and how it affects the performance of your database is critical.  Performing regular maintenance tasks that defragment and compact clustered and non-clustered indexes on tables and views. This will improve index-scanning performance. This should be run on weekly or fortnightly basis. Fragmentation can happen at several levels and if fragmentation […]

My last post had a great deal of information and formulas in it. I took the weekend to form it up in a calculator. I am working on a APP for it now as well. Why not? Attached is the AG Calculator, to use fill in the info required and it will return WT […]

I wanted to share this video. It is a tour of the Microsoft Azure Data Centers it is very impressive.  Enjoy. http://www.youtube.com/watch?v=JJ44hEr5DFE

Microsoft BI is easy to use and is the largest growing BI platform according to Gartner. In order to get data out of Essbase it requires some magic. Below is a list of options to get data out of Essbase into another stack like Microsoft BI.  One other option that I didn’t include […]

The need for a Logging Framework for SSIS packages to track and log activity within ETL (Extract, Transform, Load) processes. This blog outlines the database schema, stored procedures and implementation practices within SSIS packages to be utilized for the SSIS packages used for the data applications.  I will build and use a […]

I doing a series of Blog Post’s on storage and disk configuration. You should never treat it like a Black Box and need to understand your workloads and use cases to get the value out of your servers and your licenses. In this post I am going to talk about RAID […]

There are a number of factors to consider when undertaking the capacity-planning phase for your AG environment. One such factor is the amount of resources each replica will require to provide appropriate performance for the system. To work this out, you need to take into account not only the normal […]