When you are creating a system benchmark you need a place to store your benchmark data and when you’re collecting SQL Server performance data what better place could there be than SQL Server? Performance Monitor is your primary tool for collecting performance data and Performance Monitor has the capability of writing performance data to SQL […]
Read More
In large enterprises and multi-tenant environments controlling the resources that are used by a given workload or application can be an important factor in meeting your SLAs. If one workload consumes too large a chuck of your system’s resources then all of the other workloads running on that host could be adversely affected. That’s where […]
Read More
When SQL Server® 2014 brought in some interesting innovations around In-Memory objects it was one of a kind in the industry. It was amazing to see how In-Memory objects can be ACID complaint, persistent, and not be lost because of power outages. I have yet to see users using this feature to its full potential […]
Read More
SDN is about making networking more flexible and agile through programming network elements. Such programming needs to be done in a standard way. Hence, standardizing the southbound protocol that directly commands a network element to forward traffic is important. So is the northbound protocol through which different applications tell an SDN controller the WHAT […]
Read More
Virtualization is an amazing and valuable tool for so many reasons. I’ve been a proponent of the concept since GSX server, and early Workstation products. In the early days, I used to use it as a fresh image to load on a workstation for a development crew who required a pristine testing environment for a […]
Read More
The FILESTREAM data type is SQL Server’s principle BLOB storage technology. The FILESTREAM data type lets you combine native NTFS file system performance with relational database data integrity. It supports up to 16 TB files which maximum file size supported by the NTFS file systems and simultaneously provides you with full data consistency. The FILESTREAM […]
Read More
Combining Binary Large Object (BLOBs) with relational databases like SQL Server has always been like combining oil and water. They just don’t mix very well. BLOB objects like pictures, videos, text documents and xml documents don’t fit within the standard relational data types. SQL Server originally offered support for BLOBs using the TEXT, NTEXT and […]
Read More
Recently, I’ve been giving some thought to the roadblocks I discover when I attempt network automation and orchestration, and how those roadblocks impact the software-defined data center idea as a whole. As a result, I have a few suggestions for how to prepare a network – and the thought process – for the future. Thou […]
Read More
Waiting is everywhere! Waiting for your laptop to start or shut down; waiting for a disc to finish copying; waiting for an operation to complete; waiting for Apple® to release its next iOS. Unfortunately, the release of Apple’s next iOS is up to Apple, and we can’t do much about that. What about the other […]
Read More
Whether your IT operation is a small-scale endeavor or a Web-scale enterprise, systems monitoring plays a critical role in the delivery of your services. The ability to quickly and accurately assess the state and health of your infrastructure and applications is no longer a luxury, it’s a categorical requirement. The question is no longer, “Do […]
Read More
Virtualization has been around for quite a while now; however, its mass appeal has only been realized with the extensive improvements that have appeared in the last few years. In virtualization’s early days, you had to purchase very expensive hardware; now, due to its ability to use commodity PC servers, you can download free virtualization […]
Read More
You can use the CREATE TABLE statement to enforce several different kinds of constraints on a table: candidate keys, primary keys, foreign keys, and check conditions. A CONSTRAINT clause can constrain a single column or group of columns in a table. The point of these constraints is to get Oracle to do most of the work […]
Read More