The PowerShell Disconnect

Dave Mason - SQL Server-The PowerShell Disconnect

Not long ago, I installed the first instance of SQL Server 2016 in a production environment. I ran some scripts to create standard SQL Agent jobs, including one that resulted in this error:

Msg 14234, Level 16, State 1, Procedure sp_verify_subsystem, Line 28
The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems).


T-SQL Tuesday #89: The Times They Are A-Changing

For T-SQL Tuesday #89, Koen Verbeeck (b|t) wants to know how we feel about technology and change. What impact has it had on our jobs, our education, and our psyches? It's a really good topic for us data professionals and Koen gets the ball rolling with some excellent questions.

I touched on this topic pretty heavily not too long ago. Some of you probably already know how I've been feeling lately about all the change happening around us. If I had to sum it up in one word, it would be


Certified And Inexperienced: The Kiss Of Death

Ask someone that has hired a DBA which is more important: real world experience or education? To be fair, most will say their ideal candidate has a good mix of both. But if you can't get both, what matters more? Without hesitation, the overwhelming response is "Give me the candidate with experience." Why is that? Why is the combination of inexperience and certification the kiss of death?


The Mount Rushmore of Lazy SQL Security

Dave Mason - Mount Rushmore of Lazy SQL Server Security

SQL Server security can mean different things to different people. And rightly so. The first thing I always think of is authorization. And that is why I'm stepping onto my soapbox, blogging my frustration into the ether. I see four recurring security blunders that drive me nuts. The blundees (is that a word?) are seemingly oblivious. They react as if everything is fine and anyone that suggests otherwise is unreasonable. Allow me to immortalize their folly, National Memorial-style.


Big Data Processing and McKayla Maroney Face

Dave Mason - SQL Server Big Data

I've been taking a few steps down a path that's new for me. So keep that in mind if you've been down this path too. Because you've likely traveled farther than me and the lens you look through offers more clarity than mine.


NBA League Pass - Long Term Update

I'm a long time Celtics fan living in Florida, so I don't normally get to see them play much during the regular season. I'm relegated to the occasional matchups vs Orlando (my cable provider shows all the Magic games), plus any other games televised nationally on ESPN, NBA TV, or TNT. The rest of you vagabond fans probably face the same challenge. For the 2016-2017 NBA season, I subscribed to NBA League Pass for the first time. It hasn't been pretty.



Dave Mason - SQL Server UnPivot RESTORE HEADERONLY Output

Today's less-than-ugent challenge was to un-pivot the output of RESTORE HEADERONLY. I thought for certain someone else, somewhere, at at some time must have wanted to do the same thing. So I asked the Twitterverse, but no one responded. I guess I'll have to make do myself without the easy button. No worries, though. We can do this!


Cannot Generate SSPI Context

I ran into a SQL Server connectivity issue this week that was a puzzler, but (thankfully) only for a short time. Maybe my pain can be your gain. Here's a quick rundown.

I installed and configured a new instance of SQL Server. After getting appropriate firewall ports opened by the network team, everything seemed A-OK. Until I tried connecting from a remote machine. Here is what I saw from SSMS:

SQL Server - Dave Mason - Cannot Generate SSPI Context


Musical Chairs And The DBA

Thomas LaRock wrote a blog post a couple of months ago that really irritated me. It was about the future of the DBA. My first instinct was to write a rebuttal blog post of my own. In my mind I would "throw the bullshit flag" and remind everyone that speculation is an exercise in futility. I'd insist that until his predictions start happening, he's just guessing and full of crap. Let's just say that blog post, if written, would have quickly been added to the list of really dumb things I've done in my lifetime.


Muscle Memory And CTRL+F

I experienced a handful of "firsts" this month. I installed Windows 10, followed soon after by installing SQL Server 2016 and SSMS 2016. It didn't take long for me to hit the CTRL+F keyboard shortcut in SSMS, which of course opens the "Find" dialogue. In the particular version of the Visual Studio Shell that SSMS is built upon, the Find dialogue is quite different than in previous of the shell. But this wasn't a shock to me. I'd seen in before in other Microsoft products including Visual Studio Express and Visual Studio Community.