Tag Archives: Database Weekly

More Power in Your BI

I’ve seen lots of data visualization tools over the years. Cognos, Microstrategy, ProClarity, and more. While I haven’t been a BI person for most of my career, in many of my positions, someone has wanted to try some new tool … Continue reading

Posted in Editorial | Tagged , | Leave a comment

The vNext Bleeding Edge

Microsoft has had early access programs for years. I worked at a few companies that were a part of the TAP (Technology Adoption Program) program, and we would get access to code early in exchange for providing feedback and working … Continue reading

Posted in Editorial | Tagged ,

Faster Versions and More Support

When I started working with SQL Server, the versions came a strange paces. Three years between v4.2 and v6.0, but less than 1 before v6.5. Then two years to v7, one more to SQL Server 2000, but five until SQL … Continue reading

Posted in Editorial | Tagged ,

Local Database Issues

There was a report that Spotify is writing lots of junk data to users’ local drives. Some people have noted GB a day or writes, even when they aren’t using Spotify for listening to music. Some debugging by users show … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Intelligence from Data

There is an incredible amount of data in the world, and all that data is changing the way industries work. That’s the opening to a keynote talk from Jim McHugh at the O’Reilly Artificial Intelligence conference. The talk is short, … Continue reading

Posted in Editorial | Tagged , ,

Analyzing Data in Real Time

A few years ago I was listening to a presentation from Microsoft where they touted a customer that had real time analytics with Analysis Services. Since my exposure had been that cubes needed to be processed, a resource intensive process, … Continue reading

Posted in Editorial | Tagged ,

Why We Need Backups First

One of the things I show when I talk about TDE is that the backup of the certificate is very important. When you create a certificate, SQL Server warns you right away that a backup of the certificate is needed. … Continue reading

Posted in Editorial | Tagged ,

Paying for Data

Would you recommend your organization pay a ransom to get the key to decrypt data that’s become encrypted on your database systems? What if the data were encrypted in backups going back two weeks? It’s an interesting question, and one … Continue reading

Posted in Editorial | Tagged ,

Install Cumulative Updates

For years I haven’t recommended installing Cumulative Updates (CU) as they are released. The main reason is that Microsoft has had language associated with their CUs that say customers should not install a particular CU unless they are experiencing the … Continue reading

Posted in Editorial | Tagged ,

Power BI Week

This past week was T-SQL Tuesday #75, with the topic of Power BI. There were some interesting posts, and we’ve included a few in this week’s newsletter. This was also the week where the winners of the Power BI report contest were announced, … Continue reading

Posted in Editorial | Tagged , | 1 Comment