Jordan Sanders

Subscribe to Jordan Sanders: eMailAlertsEmail Alerts
Get Jordan Sanders via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Jordan Sanders

Over the last few years, more and more businesses have been embracing the cloud-based technologies for their CRMs, customer service, project development and management, accounting, etc. The reasons of the trend are pretty obvious - all you need to access cloud services are web browser and Internet connection, what allows cloud-based companies to minimize maintenance costs and to boost productivity. Nevertheless, there is still a large segment of business that looks at the cloud rather suspicious, mostly questioning its ability to provide data security and integrity. In this article, we will try to explore the most common myths about the cloud and try to show how cloud technologies may help to improve your business. - Cloud is a wild territory providing poor control over your data First of all, there are two principal types of cloud providers - public and private. P... (more)

SQL Server Index Fragmentation In-Depth.

There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down into SQL Server index fragmentation issue. We will figure out why index fragmentation is a problem and how it affect on overall performance, discuss how to detect and avoid it. Index Fragmentation Fragmentation is a common term that describes numerous effects that can occur because of data modifications. Chances are, you already know that SQL Server stores data on 8KB data pages. E... (more)

Practical Tips to Reduce SQL Server Database Table Size

In this article, I'd like to elaborate on the subject of boosting productivity while working with database tables. Chances are you already know this from multiple resources on database development process. However, the topic seems to become a front-burner issue when there are continuous data growths - tables become too large that leads to the performance loss. It happens due to an ill-designed database schema that was not originally designed for handling large volumes of data. To avoid the performance loss in the context of continuous data growth, you should stick to certain rul... (more)

How to Track Your Working Time in JIRA

Many of us are using JIRA during development and sometimes it is necessary to record our working time spent on resolving a bug or completing a task in JIRA. There are a lot of various time trackers but I want to show you a free and easy solution that will help you to track your working time in JIRA.  TMetric is a time tracking software which helps individuals and organizations to be more productive. This time management software provides time tracking, work session monitoring, reporting tools, integrations and much more. Why is TMetric now called Jira Time Tracker? Using its rich ... (more)

Instant File Initialization – Killer Feature for SQL Server

The use of Instant File Initialization is a terrific way to reduce downtime during failure recovery. It won't take you much time to initialize files for filling them with zeros before the recovery. So keep in mind that there is such useful thing as Instant File Initialization. When SQL Server reserves new space on a disk, it initializes the space with zeros. This behavior can be switched off thereby reducing the execution time of some operations and the load on the disk subsystem. Disk space reservation without initialization is called Instant File Initialization. This feature is... (more)