Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "Microsoft SQL Server Admin"

0

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...
2

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...
0

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...
0

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...
3

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...
8

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...
0

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...
0

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...
29

SQL Server Configuration Manager – Remote Procedure Call Failed

If you find a need to install multiple version of SQL Server on a laptop of server, you are bound to run into a problem with the MMC snap for configuring the instances.  One of the most common, the remote procedure call failed.  This error is simply due…

Read More...
18

Virtual book club.. who is in?

At work we decided to start a book club, we pick a book, every week we decide how much we will read. After the week is over, we meet and then discuss what we read. We discuss what we liked, what we didn’t like and also what we learned.

Why should…

Read More...
« Previous PageNext Page »