Be an Analyst is weekly series which aimed to enhance skills beyond beginner level.These topics are composed of the most popular articles, as well as articles demonstrating new or updated features
1. Owner of a database in SQL Server
Have you ever find in a situation to know the owner of a database. then this article will help you to write a T-SQL query.
2. Changing database ownership
when we create the database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the user full control on the database, meaning he/she can do whatever they like on that particular database. According to the SQL Server security best practice document, we should grant login with the least amount of privileges. Therefore, it is recommended to set built-in sa account as an owner of all databases on SQL Server instance. This will make database and server more secure.
3. Download the StackOverflow database for SQLServer using Bittorrent
Now you can download a torrent of the SQL Server database version of the Stack Overflow data dump by following this article.
4. Calculating Running total in SQL Server
If you ever thought about executing a query to calculate the running total. Then Shailendra Chauhan from dotnet-tricks has explained it.