Skip to content
benjf.com
benjf.com

Real content from a human brain

  • Home
  • About
  • ✞ Faith
  • Opinion
    • Politics
    • Health
    • Movies
    • Music
    • ☺ For Fun
    • Random Awesomeness
  • Technology
    • Desktop
    • Android
    • ✉ Email
    • Privacy
    • Programming
      • HTML
      • CSS
      • Javascript
        • jQuery
      • PHP
      • SQL
        • SQL Server
      • Powershell
      • MS Access
      • WordPress
  • Productivity
benjf.com

Real content from a human brain

Month: March 2016

Finding Active Node in SQL Server Cluster

Writer #1, 2016-03-19

The T-SQL method to find the active node that a SQL service is running on:…

Continue Reading

SQL Jobs – Daylight Savings Risks

Writer #1, 2016-03-19

For those of us not lucky enough to live in Arizona (where daylight savings is…

Continue Reading

Validate SQL Code Without Running It

Writer #1, 2016-03-19

Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; — The script…

Continue Reading

SSMS Scripting Partition Scheme With Correct Filegroup

Writer #1, 2016-03-19

I almost found a bug… but it’s a feature after all. If you are scripting…

Continue Reading

AdventureWorksDW Databases – 2012, 2008R2 and 2008

Writer #1, 2016-03-19

AdventureWorks sample databases seem to be so hard to find when you want them.  Here’s…

Continue Reading

Database File Space and Free Space

Writer #1, 2016-03-19

/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID(‘tempdb..#space’) IS…

Continue Reading

Autogrowth On But Database Not Growing

Writer #1, 2016-03-19

An issue arose where a database was giving the error: Could not allocate space for…

Continue Reading

Shrinking Database Files With Excess Free Space

Writer #1, 2016-03-19

This script is intended for environments where space constraints require the space to be closely…

Continue Reading

SQL Server – Lots of Empty Space But Database Won’t Shrink

Writer #1, 2016-03-19

Today I ran a script to delete a huge portion of data in a DEV…

Continue Reading

SQL Server – Get Latest Backup File Sizes For All Databases

Writer #1, 2016-03-19

This returns a result for each database and includes its size in MB. SELECT DATABASE_NAME…

Continue Reading
  • Previous
  • 1
  • 2
  • 3
  • …
  • 5
  • Next

Recent Posts

  • Love Never Fails
  • FIXED! Left Audio Only on OBS with Behringer U-Phoria UMC204HD
  • Gnome Alt+Tab Window Switching; How to ungroup the windows
  • Pay or else
  • 1Password App Integration With Browser Extension on Kubuntu (or Debian Linux)

Recent Comments

  1. LOL on Major Federal Budget Cuts – do the math
  2. Writer #1 on Online Privacy In The United States
  3. More About Sortable Dates; Plus AutoHotKey Scripts! – benjf.com on Date/Time Formatting Can Unite The World
  4. AutoHotKey Tips – benjf.com on Date/Time Formatting Can Unite The World
  5. Kevin on Moving FDLAUNCHERLOG in SQL Server

Archives

  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • April 2024
  • March 2024
  • November 2023
  • October 2023
  • September 2023
  • July 2023
  • June 2023
  • May 2023
  • October 2022
  • September 2022
  • August 2022
  • May 2022
  • December 2021
  • November 2021
  • September 2021
  • July 2021
  • June 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • May 2018
  • April 2018
  • February 2018
  • December 2017
  • September 2017
  • June 2017
  • May 2017
  • February 2017
  • January 2017
  • December 2016
  • August 2016
  • July 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • October 2012
  • September 2012
  • July 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009

Categories

  • Ai
  • Android
  • C#
  • CSS
  • Desktop
  • EMail
  • Faith
  • For Fun
  • Health
  • HTML
  • Javascript
  • jQuery
  • Just Info
  • Linux
  • Movies
  • MS Access
  • Music
  • Opinion
  • PHP
  • Politics
  • Powershell
  • Privacy
  • Productivity
  • Programming
  • Random Awesomeness
  • Self Hosting
  • SQL
  • SQL Server
  • Technology
  • Uncategorized
  • WordPress
©2025 benjf.com | WordPress Theme by SuperbThemes