If you work on a computer, get these tools
So much of IT comes down to tools. I love getting a recommendation from a colleague that improves my workflows. Here are a few of my favorites that can benefit anyone, no matter what your specialty. I do database work, so my examples come from that area. I use these on Windows, … Continue Reading ››
Tweaked script to find all db_owner members
Running a plethora of T-SQL
Have you ever needed to run a bunch of scripts, over and over and over? And the SSMS tabs - it can be a mess. This is mind-numbing work - call in the computers. Check out this script I forked from GitHub and modified: https://github.com/propellor/Powershell-pasen/blob/master/Run-Sql.ps1 You point the … Continue Reading ››
Easy Security Fixes
Here are some security tasks I've been tackling lately.
1. Find weak passwords and change them.
I keep track of application logins and passwords using a product called KeePass. It has a plugin called strengthreport that you can use to make a report or .csv showing the strength of your passwords. Use the SVN command … Continue Reading ››
Validate Views
Sometimes after moving databases between servers some views may be broken. This query will generate statements to test the views in your database.
Easier SSRS log querying
{{unknown}}
SQL Server Reporting Services scale-out cluster problems
I've been trying to get an SSRS scale-out cluster working the past few months. I'd given up today and resorted to calling MSFT support. I'd read all the manuals and supplemental articles like a proper admin should. I'd posted questions on the MSFT forums to no avail. Time to bite the bullet and sit on … Continue Reading ››
SQL Saturday 131 – Phoenix
I am presenting at 8:30 at SQL Saturday 131 at the Chandler Gilbert Community College.
Looking for notes from my presentation? Find them on this page.
DBase
Here at work, we need to import from DBase files every now and again. DBase is a strange breed of database if you've been working in SQL. To import from SQL, you use a OLE DB connection and then pick the folder that contains your DBase file - which is actually just one table. Continue Reading ››
Inserting results of FILELISTONLY to a table
I was looking for a code example of this on the web, but couldn't find it, so here it is. You would need to create the @cmd of course with your own variables.
SELECT @cmd = 'restore filelistonly from disk = ''' + @localBackupPath
… Continue Reading ››