Category Archives: Azure

A lit of blogs focusing on Azure and Cloud concepts

Database Options: – Filestream

By | May 3, 2020

Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather than data pages within SQL Server. Since the filesystem is meant to store and work with such data it makes it a perfect candidate for this feature.… Read More »

DB Options: – ANSI NULL DEFAULT ON

By | March 4, 2020

https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it doesn’t make sense to set it at Database level. This option default the NULLAbility of columns when creating the table or altering it. When set to off… Read More »

DB Options: – ANSI NULL DEFAULT ON

By | March 4, 2020

https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it doesn’t make sense to set it at Database level. This option default the NULLAbility of columns when creating the table or altering it. When set to off… Read More »

DB Options: Auto Create Incremental Statistics ON

By | February 18, 2020

In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the DBA to update stats by merging the updated stats for the partition in question with existing stats. In this way DBA are able to reduce the overhead… Read More »

DB Options: Auto Create Stats and why it should be ON

By | February 14, 2020

Auto create stats is one of those database options that every DBA knows they should set to ON. In this video we explore what happens when you set if OFF and why having good stats is important for query optimizations. We explore the impact of not having statistics on a simple query and then cover… Read More »

Database Options – Auto Close and why should set it to OFF

By | February 12, 2020

Auto close is one of those features that should have been removed long back. The setting needs to stay at default of OFF for reasons that will be made obvious in this video. In this series of videos we cover each of the database options what they do and why they should be set to… Read More »

Using Bookmarks in PowerBI

By | February 7, 2020

https://www.youtube.com/watch?v=SftUYP6nchk PowerBI is a robust reporting tool that has a number of easy to use and configurable options when it comes to reporting. One of the most frequently used features in PowerBI is the bookmarks capability. A bookmark as its name suggest provides way to snapshot a report page keeping in mind the filters and… Read More »

SQL 2019 – Christmasql

By | December 4, 2019

Early November I had posted I would be conducting a series of sessions on MS SQL server. The response was really great and while I intended to do a classroom session the interest was primarily for online delivery. So I will be arranging the first half of it this in the coming 10 days. Here… Read More »

SQL 2019- Licensing

By | November 11, 2019

In this post I will try to explain SQL 2019 licensing in the simplest way possible. Do you need to worry about SQL Express, Web or Developer edition? No not really, we are only exploring production workloads, and none of the editions above are used in true production workloads. Besides they are practically free (even… Read More »

SQL 2019-Data Classification and Vulnerability assessment

By | November 5, 2019

  Data Classification With GDPR security has become a high priority for a large number of organizations the cost of not implementing robust security has been significantly increased and therefore companies that previously used to think security wasn’t a key part of their architecture now has to revisit that approach. But complying with GDPR and… Read More »