Posted by Barac in SQL Server, SQL Tips and Tricks
on Mar 12th, 2022 | 0 comments
What is the SCHEMABINDING within VIEW?It simple binds the view to the schema of the underlying objects. Tables behind the View cannot be altered in any way which could affect view definition. You can find more at this MS article: ALTER VIEW (Transact-SQL) There is a easy way to remove SCHEMABINDING, you just need ALTER VIEW statement. But what if you have 100 views that needs to be altered? Well there are no SWITCH OFF button for SCHEMABINDING in SQL Server. I had same situation and I wrote this simple script which will generate ALTER VIEW...
Posted by Barac in SQL Server
on Jan 27th, 2022 | 0 comments
VIRTUAL EVENT #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 5th running on the 14th of May 2022. Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL, Logic...