One of your five a day
With the release of the exciting Service Pack 1 for SQL Server 2016 we get a new T-SQL command – CREATE OR ALTER. CREATE OR ALTER <valid for procedures, views, functions, and triggers> as below for a view; Although
Well Azure SQL Database Long Term Backup Retention is now in Public Preview. This allows us to keep out backups now for up to 10 years which may meet your compliance criteria better then the offerings beforehand and certainly may
Subsequent to my post where we’d covered some Windows Server Clustering PowerShell Commands I thought I’d add the two most useful ones I use. This one shows us whether the Witness has a vote or not: Get-Cluster | Format-Table Name,
On November 16th 2016 Microsoft released the availability of SQL Server 2016 Service Pack 1 (SP1). Normally a service pack release isn’t the most exciting news to blog about, but this release is different – This SQL Server 2016 SP1
After my post on Migrating to WordPress – Part 1 and some questions and comments from colleagues and readers I thought it would be beneficial to describe the various options and costs available to users of Azure and Project Nami to achieve
Sometimes in SSIS we want a particular task to succeed but still have two paths or options, almost like a SSIS Success on Failure outcome. For example, we may want a package to check to see if a file exists before
When running a trace using SQL Profiler we need to be Importing trace files to perform some analysis on the results. To import the files we will simply use the fn_trace_gettable function. SELECT * INTO tracetable FROM dbo.fn_trace_gettable (‘C:\tracefiles\trace_1_1.trc’, default)
I’ve recently been doing a significant amount with Windows Server Clustering and Availability Groups and I thought I’ d get some of the information posted whilst its all fresh. Clustering, the basics The basics of Windows Server Clustering are
Recently I had a conversion about the options available to create a copy of a production database for testing and development. There are, the enhanced, CREATE DATABASE and the standard Restore database options available. We’ve got the restore database option,
There are many new features in Windows Server 2016, but one interesting one is the new Cloud Witness feature for using with Windows Server Failover Clustering. Essentially, you use a Azure Storage Account which you can store a blob file