Log Shipping – Error: Failed to update database “DATABASE NAME” because the database is read-only
Here’s a strange one that I’ve recently come across. I had a customer report that their log shipping restore jobs...
2018-02-22
730 reads
SQL Undercover
Getting started with the SQLUndercover Inspector
Here is a quick guide to getting started with the SQLUndercover Inspector.
Pre-requisites:
SQL 2012 or higherSQL Server AgentA database to store...
2018-02-19
360 reads
T-SQL Tuesday #99 : Getting Decked Out in Rubber and Lycra, My Non-techy Passion #TSQL2sday
So this month’s T-SQL Tuesday invitation comes from Aaron Bertrand. It’s a non-technical post this month as he asks us...
2018-02-13
806 reads
The SQLUndercover Inspector is now available!
The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here:...
2018-02-11
1,022 reads
sp_AGReconfigure 1.1 is now available
sp_AGReconfigure 1.1 is now available HERE and on GitHub
V1.1 includes a new Parameter and some minor bug fixes:
@Readable
NULL – DEFAULT: ...
2018-02-08
374 reads
UNDERCOVER TOOLBOX: Get Details of All Open Transactions
It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a...
2018-02-07
443 reads
Undercover TV – We’ve got a YouTube channel!
We’ve now got ourselves a shiny new YouTube channel at UndercoverTV.
We’ll be using this to host our monthly podcasts as well...
2018-02-01
382 reads
sp_RestoreScript 1.2 is now available
sp_RestoreScript 1.2 is now available HERE and on GitHub
Changes include Service Broker options and the ability to restore a database in...
2018-01-30
639 reads
SQL Undercover Podcast – Feb 2018
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...
2018-01-29
438 reads
Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group
Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’. If you’ve...
2018-02-02 (first published: 2018-01-24)
2,202 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers