Tackling Corona Virus Long Term

At this point it seems Corona and its impact is here for the long term. As the days go by I see even more people taking extreme measures often out of fear or a lack of understanding the problem. Social media and Whatsapp has played its share too. The spread of Corona can happen through… Read More »

DB Options – ANSI WARNINGS | ANSI PADDING and more

https://youtu.be/aoAijAWpEAk In this video we cover multiple database options most of which are fairly easy to understand and don’t really require significant research before being set. Often these settings are enabled by default and Microsoft recommends they remain that way. Some of the options we cover are listed below ANSI WARNINGS – Must be set… Read More »

DB Options: SET ANSI Nulls

https://youtu.be/QfB2v6QQej8 ANSI NULLS dictate how SQL Server responds when the equal to (=) operator is used to check for NULLs. Keep in mind that the IS NULL condition works regardless of what ANSI NULL setting is used. When ANSI NULLS are ON using a query like ColA =NULL will not return any results. Setting ANSI… Read More »

DB Options: – ANSI NULL DEFAULT ON

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 UPDATE STATS / ASYNC

https://youtu.be/8ugpVfPzvz4 In this video we are going to talk about auto update statistics. This is a feature in the database engine that automatically triggers a stat update when data has been updated beyond a threshold. In previous versions of SQL server this thresh hold was 500 rows followed by every 20% increase in the count… Read More »

DB Options: Auto Create Incremental Statistics ON

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

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 »

Using Bookmarks in PowerBI

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 »