Call Us Today! 775-348-4053

Blog

Database Offline – Redux

By Jason Brimhall | April 15, 2019

A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help you get a reasonable deduction for that offline event in the absence of better data.

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

By Wayne Sheffield | March 11, 2019

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.

The post Scalar UDF Inlining in SQL Server 2019 – Simpler functions appeared first on Wayne Sheffield.

Scalar UDF Inlining in SQL Server 2019

By Wayne Sheffield | February 25, 2019

SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.

The post Scalar UDF Inlining in SQL Server 2019 appeared first on Wayne Sheffield.

CLR Strict Security in SQL 2017

By Wayne Sheffield | January 21, 2019

Locking down CLR

SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!

The post CLR Strict Security in SQL 2017 appeared first on Wayne Sheffield.

Quick Permissions Audit

By Jason Brimhall | January 14, 2019

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.

What were you thinking (hidden relationship)???

By Wayne Sheffield | November 20, 2018

Exploring how a parent-child relationship was implemented by a third-party software vendor improperly.

The post What were you thinking (hidden relationship)??? appeared first on Wayne Sheffield.

PowerShell ISE Crashes

By Jason Brimhall | November 19, 2018

Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to manage your server. Sometimes getting to the current PoSh versions comes with a little pain such as ISE crashes.

%d bloggers like this: