Limiting Database Permissions for DLM Dashboard

I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues,...

Text Mining Loch Ness Monster Sightings

Text Mining with RapidMiner for Loch Ness Monster Sightings
Text mining involves pulling root words from text in a system.  In...

DocumentDB Tutorial 2 – Working with Documents

Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...

Moving to Open Live Writer

I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well...

SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a...

Azure SQL Database monitoring

Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing...

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...

How Bad Are Your Indexes?

In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...

Leadership and the Data Professional

Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...