With some interesting experiences under our collective belts when it comes to working with SQL Server on AWS, it seems like it might be interesting to share some of the things we’ve learned and seen in the field. AWS’ RDS with SQL Server is a great SaaS deployment of SQL Server that gives you the benefit of the fully-managed environment […]
SQL Server
5 Ways to Make Yourself Stand Out at Work
A busy professional asks a question regarding working relationships. I’m looking for meaningful, effective ways that employees in nearly any scenario can make themselves stand out in a good way. It goes without saying that above all, you must continue to produce high-quality work, make the most of your time at the office. We don’t want any of the below...
Some tips for using tempdb database in SQL Server 2017
Some tips for using tempdb database in SQL Server 2017 Set the reasonable size for the tempdb database and transaction log. First of all you should estimate how large your tempdb database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained....
A Holistic View of Database Management System (DBMS) – Part 16
Equality Scheduling An equality scheduling can be of the subsequent categories: Result Equality At the time when two (2) schedules create the identical result after the implementation of the commands, they are known as result equivalent. They may perhaps give the similar outcome for certain value as well as not the identical outcomes for another group of values. That’s the...
10 Tips and Tactics for a Better Salary
A busy professional asks a question regarding negotiating for a better salary. I need some tactics to negotiating for a better salary. Whether you are negotiating in a hiring interview OR negotiating for a raise, there are several things you can do to put yourself in the winning position. Here are a few: 1. Make sure you are worth the...
Beware the dark side of capacity
When you’re working with resources that are dedicated instances, powerful instances, you can get caught up a bit in the fact that it can take a lot more to trip up those resources than perhaps you’re used to. It’s sort of like flying as the only passenger in an airplane made for commercial flight; there is likely a lot more […]
Tips for using SQL Server 2017 cursors
Tips for using SQL Server 2017 cursors Use READ ONLY cursors, whenever possible, instead of updatable cursors. Because using cursors can reduce concurrency and lead to unnecessary locking, try to use READ ONLY cursors, if you do not need to update cursor result set. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some...
A Holistic View of Database Management System (DBMS) – Part 15
Transaction A transaction can be well – defined as a set of jobs. Any solo job is the least possible handling unit that cannot be further segregated anymore. Consider an instance of a simple transaction where a person is having two (2) savings account in two (2) different banks and he is transferring $ 100 from an account of ABC...
How to Better Clarify Your Pay Structure to Client
A busy professional asks a question regarding client relationships. My client doesn’t want to pay for going over budget stating that I was unclear… was I? Prior to beginning a specific design project, I submitted a proposal to my client for her review and approval. It clearly specified the projected budget and terms. “Three concepts of the logo will be...
Tips for using backup and restore in SQL Server 2017
Tips for using backup and restore in SQL Server 2017 Consider storing the backup files on physical disks on another computer. Storing the backup files on the same computer where the databases stores may cause problem with restoring databases if the physical disks were damaged. Try to separate your database to different files and filegroups to backing up only appropriate...