NYC SQL User Group Mtg - Building a Personal Brand

This month, Thursday, June 27, 2013, the NYC SQL User Group be doing something a little different. Instead of a technical presentation,...

SQL Server 2014 CTP1 is here!

As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...

A Rickety Stairway to SQL Server Data Mining, Part 14.1: An Introduction to Plug-In Algorithms

by Steve Bolton

…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got...

Last Weeks Top “Reading” Links #38

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Don’t Use MD5

“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably...

I Don’t Care

It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...

SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts

We had a situation where Application owners automatically notified whenever server restarts.  The SP_PROCOPTION do have a facility to perform...

My upcoming SQL Server Trainings

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...

Baseline SQL Server with SQL Sentry Performance Advisor

Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...

Metadata Functions (OBJECT_NAME for example)

What is a metadata function? According to BOL a metadata function is one that returns data about the database or...