Comments on: About

By: Jeff Moden

Jeff Moden — Tue, 05 Sep 2023 15:03:15 +0000

In reply to Kenneth Fisher.

Heh… Thanks for the honorable mention, Ken, but if I were “right as usual”, I’d be a whole lot richer right now. 😀

By: Kenneth Fisher

Kenneth Fisher — Tue, 05 Sep 2023 14:36:54 +0000

In reply to Jeff Moden.

Ok, done. It needed an update anyway 🙂

By: Jeff Moden

Jeff Moden — Tue, 05 Sep 2023 14:06:07 +0000

It just dawned on me about how hard it is to identify you through this blog, Ken. You don’t even post your name in your “About” post above.

By: Kenneth Fisher

Kenneth Fisher — Mon, 18 Jan 2021 23:01:29 +0000

In reply to Lance Wulfers.

https://github.com/sqlstudent144/SQL-Server-Scripts

By: Lance Wulfers

Lance Wulfers — Mon, 18 Jan 2021 19:29:38 +0000

Can you send me the source for your sp_DBPermissions script? Not sure what the web page is doing to your source but a copy and paste generates a bunch of invalid characters in the resulting paste buffer

By: scottedwards2000

scottedwards2000 — Wed, 22 Jul 2020 01:46:07 +0000

Glad to see you are still active here, Kenneth! I just re-discovered your blog from a 2016 evernote I saved from your site. I’ve had to move on from SQL Server, as my last 3-4 jobs have forced me to learn PostgreSQL, Redshift (AWS), Apache Spark SQL (surprisingly pretty standards compliant), and, most recently, Snowflake (another cloud DW, also pretty standards compliant). As a result of this, I guess I’ve become somewhat of a SQL nerd and have moved more towards ANSI/ISO standards. I was surprised by how much they have evolved over the years (if you are curious, the site modern-sql.com is really good).

I was just wondering, given your dual focus on development and administration, if, while having your SQL developer hat on, you ever wish SQL Server was more standards compliant. Not that it’s the worst (that award would certainly go to MySQL), but it’s not the best either (probably Oracle or PostgreSQL would win that one).

Do you see the world changing, as more companies shift to cloud services that are not necessarily from M$? What does it mean to be a SQL developer anyway in this new world?

By: Pail Writer

Pail Writer — Tue, 06 Nov 2018 15:28:30 +0000

In reply to Pail Writer.

Holly SQL Macros, Thanks for the caution. I didn’t know. Okay, I’ll stick with MeasureUp and my books.
On a side note, there’s you a subject for an article, SQL macros and macro sets.

By: Kenneth Fisher

Kenneth Fisher — Tue, 06 Nov 2018 15:17:43 +0000

In reply to Pail Writer.

I don’t really like brain dumps. They go against the spirit (and in many cases the laws) of the exams. In fact, depending on the brain dump if MS catches you using them they will revoke the certification and ban you (I think) from getting others. I’d stick with something like Measureup’s practice tests.

By: Pail Writer

Pail Writer — Tue, 06 Nov 2018 15:15:59 +0000

In reply to Pail Writer.

Thanks for the advice. I plan on taking the exam in the next few weeks. I thought about buying some brain dumps, just to see how the questions are worded on the exam. Any comments or suggested brain dump sites?

By: Kenneth Fisher

Kenneth Fisher — Tue, 06 Nov 2018 02:21:08 +0000

In reply to Pail Writer.

Yea, my best advice at that point is to review the tested subjects on the exam site and make sure you are completely comfortable with each category. (https://www.microsoft.com/en-us/learning/exam-70-461.aspx). After that if you are still uncomfortable get a practice exam from Measureup. They are a little over $100 but the biggest benefit for me has always been peace of mind. Also depending on when you purchase the exam there is sometimes a free retake option that you can get.