Building out applications has been a topic in these editorials for a few editions. It sort of started with the need to be innovators and drive that all forward at the clients/companies we all support. There are so many choices now. With our own systems, I really struggle choosing platforms for specific projects. Which is best is not simply a […]

In yesterday’s post I wrote a bit about the fact that perhaps our role is, or needs to change. It seems like this comes up fairly often – where people in this line of work feel like too much time is spent NOT doing the architecture and innovation stuff, but rather focusing on the policing stuff. Personally, I think this […]

As I was running around doing my SQL Server “thang” – I stumbled on this post on the SQL Server Technet blog site that really had me thinking. The blog post, Are you encouraging data professionals to move from doing repairs to being innovators?, was from November, and about sending your DBAs and other data-folk to the PASS event with […]

So far these posts have been all about the concept of storing more of the raw data. I still think this is the direction things need to go. It’s a bit like cryogenic freezing for your data – you hope that new uses and solutions for that data will be discovered in the future. Or, you at least can see […]

I mentioned in the post yesterday that I think it’s getting more and more common and more important to store more information in its “root” or most basic form. If you’re processing information from different sources (flows of information, different data sources, etc.) when you consider the storage costs, it can be far more beneficial to have that information later. […]

An interesting issue is showing up as I’ve talked with a couple of different people about their systems, and as we’ve been working with our own data and storage profiles. With Big Data on the scene, the emphasis is on getting information through, processed and reported on – looking for trends, looking for usable information from the raw data. But […]

I wanted to pass along a lesson that we learned deploying a system to the cloud – in this case Amazon Web Services – as it can be a signficant expense surprise if you’re not aware of it. We had deployed an Amazon RDS database instance in a VPC all its own. We wanted to wall it off a bit […]

SSWUG was created from scratch – every line of code built to provide the content management, the searching, the articles and so much more. This all started more than a decade ago. Since then, we’ve been through a few UI changes as we built out different options and capabilities and even as we jumped headlong into the virtual events options […]

For a while now, I’ve been running into a series of situations where, when we’re helping a client with a data environment, the success of the project comes down to making data providers talk to each other, preferably seemlessly. This can be any combination of things. From applications from third parties that gather and store information and have “claimed” that […]

SQL Server 2005 was a huge release for Microsoft and this SQL Server world we live in in general. It was stable, worked well and had wide application support. Over the years, updates and tweaks and so-on have been well documented and the experience base with 2005 is extensive. It’s also been simmering on the radar security-wise and, with the […]