Skip to content
June 26, 2022
Login / Register

benjf.com

SQL/Dev/+

  • Special Menu
    • Home
    • Demo
    • Docs
    • Support
  • Home
  • About
  • Technology
    • ✉ Email
    • Privacy
  • Programming
    • HTML
    • CSS
    • Javascript
      • jQuery
    • PHP
    • SQL
      • SQL Server
    • Powershell
    • MS Access
    • WordPress
  • Opinion
    • ✞ Faith
    • ☺ For Fun
    • ? Politics
    • ? Random Awesomeness
  • Health

Category: SQL Server

  • Home
  • Programming
  • SQL Server
SQL Server – AD Groups vs AD Logins

SQL Server – AD Groups vs AD Logins

September 1, 2020September 1, 2020 benf101Opinion, Powershell, SQL, SQL ServerLeave a Comment on SQL Server – AD Groups vs AD Logins

Let me state my position from the outset: Favoring AD Groups for security in SQL Server over individual AD Logins is a mistake. I don’t care what the “best practice” is. It’s a headache with no discernible advantage.

T-SQL Temp Table Check

T-SQL Temp Table Check

October 21, 2019October 25, 2019 benf101SQL ServerLeave a Comment on T-SQL Temp Table Check

What’s better than dropping your temp tables at the end of every script? Checking for their existence at the beginning of the script and dropping them.

Script Storage Update

Script Storage Update

October 17, 2019October 20, 2019 benf101C#, CSS, HTML, jQuery, MS Access, PHP, Powershell, Programming, SQL, SQL Server1 Comment on Script Storage Update

This is an update to a previous post. In another post on this site, it was said that Dropbox Paper is the code storage of choice. This has changed. As of today, I much prefer using Microsoft’s GIT code repository…

Read More

Moving FDLAUNCHERLOG in SQL Server

May 16, 2018October 20, 2019 benf101SQL ServerLeave a Comment on Moving FDLAUNCHERLOG in SQL Server

EDIT: I had two scenarios like this. The one written about here worked. The other one failed. The actual solution came from sql-ution.com. The solution is to fix the registry with the new value. And just in case his website…

Read More

Script Storage

May 2, 2018October 21, 2019 benf101C#, CSS, HTML, jQuery, MS Access, PHP, Powershell, Programming, SQL, SQL ServerLeave a Comment on Script Storage

Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of my work. Where I store them has changed over the years. The challenge has been in finding a repository that is reliable, searchable, accessible…

Read More

sp_who2 Alternative (T-SQL, SQL Server)

May 1, 2018October 20, 2019 benf101SQL ServerLeave a Comment on sp_who2 Alternative (T-SQL, SQL Server)

The trusty “sp_who2” is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what…

Read More

Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)

April 30, 2018October 25, 2019 benf101Powershell, SQL ServerLeave a Comment on Discover How User Is Accessing SQL Instance (PowerShell and T-SQL)

When your security gets unruly, it can get time consuming to figure out how a user is accessing a SQL instance. Sometimes you may know that a user is getting access via one certain AD group but you aren’t sure…

Read More

Removing SSMS Boost

June 30, 2017October 20, 2019 benf101SQL ServerLeave a Comment on Removing SSMS Boost

SSMS Boost is an add-on for SQL Server Management Studio.  I used it for quite some time but I got tired of using it as freeware.  The reason SSMSBoost as freeware didn't work for me was because they require that you…

Read More

TempDB Reporting Incorrect File Size

January 20, 2017October 20, 2019 benf101SQL ServerLeave a Comment on TempDB Reporting Incorrect File Size

So what happens when you run a query to check TempDB file sizes and SQL tells you that each file is 101 MB, but when you look in the file system, they're actually a 45 GB each?   Also, when…

Read More

SQL Server – Disabled User Account Overrides AD Group Authorization!

December 28, 2016October 20, 2019 benf101SQL ServerLeave a Comment on SQL Server – Disabled User Account Overrides AD Group Authorization!

Just a quick note on a scenario I ran into, and what I did to fix it: Scenario A user was running a stored procedure that created a table. Rather than having a table created in the "dbo" schema, it…

Read More

Posts navigation

1 2 … 6 Next

Recent Posts

  • Inspire Clean Energy (Scam or Legit?)
  • Does Memory Need Emotion?
  • Memery
  • Memery 2021-11-15
  • Nextcloud – Removing Duplicate Contacts
  • Population Zero
  • Feel Free To Discuss Your Recommendations At My Front Door, For a Fee
  • Fulton County GA Election Duplicate Scans For Democrat

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Archives

Copyright © All rights reserved.
Agency Ecommerce by mantrabrain