LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "Microsoft SQL Server Admin"

2013 – Review of Writing

In 2013 I took on a slightly different approach to writing by putting more into each article with content, length and defining either what the topic was on or how the troubleshooting methods are taken. This, of course, meant my average blog count per mo…

Read More...

A New Solution for Monitoring SQL Server

Monitoring a SQL Server environment is one of the many tasks a DBA should be performing on a regular basis.

Read More...

ACL added security for Availability Group Listener in Azure

Prior to the release of supporting listeners for availability groups in Azure running Windows Server virtual machines, availability groups were supported but more so in a mirroring configuration.  This means, applications, services, or users would conne…

Read More...

SQL Server 2012 Reporting Services Blueprints – Review

 

Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe (blog|twitter). My former colleague Valentino was the technical reviewer for this piece – he wrote…

Read More...

Can I recover from a secondary replica COPY_ONLY full backup?

I’m asked this question quite often while setting up availability groups and setting a preferred secondary for transaction log backups – can you recover from the full backup taken on the secondary with COPY_ONLY and also rely on a full backup taken on t…

Read More...

Async replica loss causes transactional replication to fail

Availability Groups have come on strong as a true Enterprise high availability feature in SQL Server.  While the setup and maintenance of availability groups is fairly straight forward, adding other features into the mix can make operations quite comple…

Read More...

Master Data Services stops working after an upgrade

Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensio…

Read More...

Document Your SQL Server Databases with Extended Properties

How important is database documentation to you? I know you have a hundred “more important” things to do. But consider this: how much time is it going to take you to document the purpose of a constraint right now? How much time will you spend trying to r…

Read More...

Speaking about BIML at the SQL Server Days 2013

I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The biggest SQL Server event of the year in Belgium, with lots of learning opportunities for developers, BI folks and DBAs. This event is organized by SQLU…

Read More...

SQL Agent Job High Availability – Availability Groups

The concept of SQL Agent Jobs being highly available or having a high level of fault-tolerance, is typically defined with the implementation of Full Clustered Instances (FCI).  However, now that Availability Groups have really taken a great deal over wi…

Read More...
« Previous PageNext Page »