Speaking of SQL Profiler brought this to mind. The number one feature that brings a smile to every DBA's face:
GRANT ALTER TRACE TO [somedev]
No longer do you have to listen to developers ask “make me SA so I can run the trace”. Actually, brings a smile to devs too, no longer do they have to beg for it. Just brings the gate over to a more granular permission level. You still do have to ask for ALTER TRACE now…
Extended events has firmly established itself as the premier diagnostic feature in SQL Server and SQL Server 2016 brings along more events to correspond to
The security announcements around Azure SQL Database keep coming. Auditing was implemented a few months ago, and today it was followed by a preview of
Yesterday’s blog post about Azure SQL Database V12 mentioned that one of the features I was particularly interested in seeing/testing were the spatial features. Interestingly,
In general, I usually hate “me too” announcement blog posts. Over the years, I’ve considered it less than useful to simply repeat “Product XXX released
A few months ago, I embarked on a project to learn more about data mining, machine learning and, as a prerequisite, statistics. I was tired
I’ve been experimenting with Power Query and the rest of the Power BI suite in Excel (desktop edition) since it was originally released. But, like
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.