Additional Articles

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

by Additional Articles

MSSQLTips.com

always on

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.

2017-01-13

3,309 reads

Identifying Last Night’s SQL Agent Job Failures

by Additional Articles

Database Journal

SQL Agent

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

2017-01-12

4,563 reads

SQL Server Database Provisioning

by Additional Articles

SimpleTalk

provisioning

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.

2017-01-11

4,829 reads

SQL Server 2016 Enterprise Edition Performance Advantages

by Additional Articles

SQL Server Performance

SQL Server 2016

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

2017-01-10

4,975 reads

Using SQLite with PowerShell and SQL Server

by Additional Articles

SimpleTalk

SQLite

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQLite version of the old PUBS database that the first generation of RDBMS developers cut their teeth on.

2017-01-09

3,904 reads

SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error

by Additional Articles

MSSQLTips.com

OPENROWSET

I was trying to use OPENROWSET to query a remote database and I experienced the following error "Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server". When I ran this same query using a sysadmin account it worked fine. Why doesn't this work for other logins?

2017-01-06

2,805 reads

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

by Additional Articles

SimpleTalk

SQL Server security

For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having database applications that meet industry standards for access control and security. The problem, however is in admitting that you have a problem and finding answers to those problems you are just too shy to ask in public.

2017-01-05

7,712 reads

Removing Email from msdb Database

by Additional Articles

Database Journal

msdb

Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records. Greg Larsen explains.

2017-01-04

6,454 reads

Triggers: Threat or Menace?

by Additional Articles

SimpleTalk

Triggers

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.

2017-01-03

3,807 reads