I write about SQL Server…and occasionally something else.
-
Policy-Based Management Policy-Based Management is a policy based system for managing one or more instances of SQL Server. This has been around in SQL Server since 2008 but is often overlooked for both its primary function in administration as well…
-
Regain access to SQL Server via inject service
One way to regain access to SQL Server is to use a simple inject technique which overrides the current Image Path for the SQL Writer service. PsExec can alternatively be used to access SQL Server as shown in the…
-
Microsoft SQL Server 2016 build
Here is a quick post for the recommended patches to deploy for Microsoft SQL Server 2016. After deploying Microsoft® SQL Server 2016 I would recommend immediately patching to 13.00.1708 by applying the MSVCRT patch. (Unless planning to apply a later…
-
Backup History
If you want to see more than just when the last backup occurred. Here is a script for backup history with two bonus features. Backup compression ratio – CompressionRatio Backup speed – Backup_MiB_S
-
SQL Server and PowerShell (SQLPS) Starter
The following two snippets of code are two ways to achieve the same outcome, which is the $Server object containing the default instance. Or when opening a SQL PS (Powershell) prompt at the default location. e.g. PS SQLSERVER:\SQL\SB01\DEFAULT> I mention…
-
SQLBits XV – 4 – 7 May 2016
Very exciting SQLBits is nearly here again. Still time to register if you have not already done so 🙂 Exhibition Centre Liverpool Kings Dock Waterfront Liverpool Merseyside L3 4FP United Kingdom https://sqlbits.com/
-
Using the default system_health Extended Event
The default extended event system_health appeared in SQL 2008 and provides several key monitors, which can prove useful when investigating issues. In the past I have mentioned this in the capturing deadlocks post as it is one of the monitors…
-
Creating a Deadlock
Previously we have looked at how to capture a deadlock, but how do we go about creating a deadlock? I think the following is the simplest method: 1. Create two tables with a single row in each and update a…
-
Samsung Gear VR2
Samsung VR for S6 Edge Plus in the UK is here ***** https://shop.samsung.com/uk/samsung-gear-vr-lite-286321/ ***** Update 2 new link http://www.samsung.com/uk/consumer/mobile-devices/wearables/gear/SM-R322NZWABTU Original Moan below: There may be a few of us geeks in the UK looking for the latest VR offering from Samsung, which…
-
Bits, Bytes and the Binary Decimal confusion
Quick Binary Bit background In computing we use a unit of information with two values 0 or 1, which is called a bit. Now with either a 0 or 1, how do we go about representing the number 6 or…
Join 900+ subscribers
Stay in the loop with everything you need to know.