The role of the Database Administrator has never been more demanding. Between cloud migrations, high-availability architectures, performance tuning, security, and endless fire-fighting, […]
Data Warehousing for Better Decision Systems The data warehousing industry certainly has matured since Ralph Kimball published the first edition of The […]
At BCS we use World Class Open Source monitoring software to monitor everything from perfmon data of your SQL Servers (our specialty), […]
A favorite tool for us to effectively monitor our SQL Server environments and beyond is Icinga. Icinga is an open-source monitoring system […]
Querying Microsoft SQL Server Chapter 1 Key Take-Aways – Chapter 1: Foundations of Querying. T-SQL is the main language used to manage […]
If you want to be a DBA for a living, Get Certified! Or at least try to, so you sound intelligent in […]
In the trenches, how we upgraded the most important SQL Server for our publicly traded client, in a Production environment where 24x7x365 […]