Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.

Making Choices

by Steve Jones

SQLServerCentral.com

Editorial

Steve talks about making changes to balance work and life.

How to use Azure SQL Database features and settings

by Additional Articles

MSSQLTips.com

Azure SQL database

Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.

Questions About the GDPR That You Were Too Shy to Ask

by Additional Articles

SimpleTalk

GDPR

The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask.

It's Time for SQL in the City

by Steve Jones

SQLServerCentral.com

Editorial

Today is the day for SQL in the City 2017 - Streamed.

Partition Level Locking: Explanations From Outer Space

by Additional Articles

Brent Ozar Blog

Partitioning

Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.

Advice for Newcomers

by Steve Jones

SQLServerCentral.com

Editorial

If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.

Checking SQL Server with Policy-Based Management

by Additional Articles

SimpleTalk

Policy Based Management (PBM)

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.