I have some coworkers that haven’t worked a lot with sql subqueries. Subqueries are a great tool, but can be confusing for folks who have limited sql experience. It’s my opinion that, like any code, good naming, proper formatting and …

Read More

Last fall, I took and passed the microsoft 70-761 and 70-762 exams to achieve MCSA (Microsoft Certified Solutions Associate) status for sql server 2016.

I’m planning to take the next step this spring, to MCSE. Achieving MCSE certification consists of …

Read More

I’ve been looking into table partitioning as a way to manage large historical tables. The idea is to be able to keep the size of the table reasonably static as new rows are inserted by removing older rows. My goal …

Read More

Recently I had a need to assign a user DBO to all databases on a server.

I put this script together, it seems to do the trick.

declare @login varchar(255)='testuser'

declare @databasename varchar(255),
        @sql varchar(max)

declare xcn cursor fast_forward local 
Read More

To create a CLR stored procedure in SQL Server….

I used this nice blog posting by Scott Sutherland as a starting point:
https://blog.netspi.com/attacking-sql-server-clr-assemblies/

If you are using SQL Server 2017 it will be necessary to sign your CLR assembly.

If …

Read More