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.

Delayed gratification or not?

by Ben Kubicek

SQLServerCentral.com

Editorial

There is a temptation to have things now when we should really wait.

Sharing Data

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve discusses the security aspects of sharing data.

Azure SQL Database Virtual Network Service Endpoints and Rules

by Additional Articles

Database Journal

Azure SQL database

One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.

Bones of SQL – Grouping By User-Defined Calendar Periods

by Bob Hovious

SQLServerCentral.com

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.

How Much Data Has Changed Since Your Last Full Backup

by Additional Articles

Database Journal

SQL Server 2017

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.

Questions About the GDPR That You Were Too Shy to Ask

It's Time for SQL in the City

Partition Level Locking: Explanations From Outer Space

Advice for Newcomers

Checking SQL Server with Policy-Based Management

Delayed gratification or not?

Sharing Data

Azure SQL Database Virtual Network Service Endpoints and Rules

Bones of SQL – Grouping By User-Defined Calendar Periods

How Much Data Has Changed Since Your Last Full Backup

Blogs

T-SQL Tuesday #200: When I Look at a Query …

Reflections on the Life of a DBA

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

Forums

ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393

ALAMAT KONTAK BCA KCP Ubud Telp:08218154393

ALAMAT KONTAK BCA KCP Benoa Telp:08218154393

Question of the Day

TempDB Facts I