Data Warehousing

Data Warehousing

Posted on

Data Warehousing for Better Decision Systems The data warehousing industry certainly has matured since Ralph Kimball published the first edition of The Data Warehouse Toolkit in 1996. Although the large corporate early adopters paved the way since then, data warehousing has been embraced by organizations of all sizes. Surprisingly, some have not adopted at all. […]

Monitoring

BCS Monitoring Suite

Posted on

At BCS we use World Class Open Source monitoring software to monitor everything from perfmon data of your SQL Servers (our specialty), including workstations, routers, firewalls, appliances and more. From service states up/down, to ping ‘IsAlive’ checks to custom queries – like how many orders are coming in, Zero? Alert! The beauty of this solution […]

Certification

You Wanna Go Pro? Get Certified!

Posted on

If you want to be a DBA for a living, Get Certified! Or at least try to, so you sound intelligent in interviews.. I will help you with the key takeaways from the Microsoft Training Kits for SQL Server. Starting with this one: Querying 2012, why this one you ask, it’s so old isn’t it? […]

Personal

Upgrading SQL Server in a Heavy OLTP Environment

Posted on

In the trenches, how we upgraded the most important SQL Server for our publicly traded client, in a Production environment where 24x7x365 – 100% uptime is expected.. It’s the most important project of the year for the DBA team. Frankly, it’s the most important project for our team in years! Our client’s primary order-entry SQL […]