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 "Database Administration"

1

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

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

Automated Job Activation with Mirroring and Availability Groups

Database mirroring is a fantastic feature.  It allows for a high safety and performance-capable copy of a database in another physical location.  This feature provides a level of failure tolerance on the database which flows to the disk level.   Of cour…

Read More...
1

SQL Server Services fail to start – FAIL_PAGE_ALLOCATION

At some point, you may run into problems where the SQL Server Windows service will not start or the services are hung in stopping or starting.  In this case, many times the chain of events that brought the services to the state they are in was due to a…

Read More...
« Previous PageNext Page »