A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

New Database Options

I saw recently that Azure SQL Database is getting a few more Database Scoped Options for that platform. These are intended to give more control over the way in which the engine behaves, without requiring each database on a server to function the same way. I expect to get to the on-premises product at some point, where they'll be even more useful as we often might want different behavior for different contexts on an instance.

While there are advantages to managing all databases in an instance in the same way, I do think that more and more we consolidate databases at times and it's better to have additional control when needed at the database level. This week, I wonder if there are things that you wish you would have been able to specify for each individual database.

What options would you want to see added at the database level?

I think that many of the options we've been given in current versions, as well as the newer ones appearing in SQL Server 2019 are a good start. I don't know which instance level settings I might want here, but I certainly would like to see newer capabilities at the database level. It would be nice to see the capabilities for jobs and alerts to be set at the database level. Even if this were a part of the Agent subsystem, having the ability to keep these jobs within a database and have the agent read them would be useful.

Moving more capabilities to the database level gives us more flexibility in separating the workloads for different applications. With the movement of the platform code, and many customers, to Azure SQL Database where the system requires less dependence on an instance, it makes sense to start including more options at the database level. I would guess that at some point most of the settings that we need for manage a system will be included and set at the database level.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.5MB) podcast or subscribe to the feed at iTunes and Libsyn.

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL in the City Streamed

The theme for December 2018's SQL in the City Streamed is Your Journey to Compliant Database DevOps. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. Find out more and register for free

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents

Permissions and Security in Dynamic Data Masking

Steve Jones from SQLServerCentral.com

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature. More »

Batch Mode For Row Store: What Does It Help With?

Additional Articles from Brent Ozar Unlimited Blog

Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements. More »

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here. More »

From the SQLServerCentral Blogs - Adding SQL Search to Azure Data Studio

Steve Jones from SQLServerCentral Blogs

There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is... More »

From the SQLServerCentral Blogs - Premium blob storage

James Serra from SQLServerCentral Blogs

As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage... More »

Question of the Day

Today's Question (by Steve Jones):

I have the Sales database that I am restoring. I have restored a full backup and ten log files. Each of these was restored using the WITH NORECOVERY option. I have run out of log files. How do I get the database online for users to access?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Restore.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

In SQL Server 2016, when deploying an Availability Group on Windows, a Windows Server Failover Cluster (WSFC) is needed.

Answer: True

Explanation:

The answer is true. A WSFC is needed tomonitor the health of the replicas. This is a clustering constrict, but this isn't the same as a Failover Clustered Instance (FCI), which uses shared storage and duplicates all aspects of one node on another.

Ref: Overview of Always On Availability Groups - click here

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 : SQL Server 2017 - Administration

CLR Error - I do not know (at this time) what version of SQL Server is actually involved as I am waiting for...

Page File Optimization 2012 sp4 - Hi All, Can you please explain about how to do Page file optimization? Does it require sql restart.? What factors should I...

SQL Server 2017 : SQL Server 2017 - Development

SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K - Need a maintenance query for an alarm logging table to see if the row count is more than 200K rows...

DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...

How to study the layout of a database? - Hello friends, Suppose you download a sample database, whether it be AdventureWorks, Northwind, or whatever other database. What steps do you...

SQL Server 2016 : SQL Server 2016 - Administration

WITH (NOLOCK) vs READUNCOMMITED proper way / performance differences - Good afternoon everybody, I need help from the Community. For the purposes of this post I do not worry about dirty reads. In...

Database upgrade and migration to 2016 SQL Server - I am looking for pointers on what option to take for high availability for a new SQL Server 2016 environment....

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Trigger on saving a stored procedure or function. - We would like the act of saving a T-SQL procedure or function to automatically append the name of the programmer...

Finding the MIN or a group of values not used in a previous group - I have been having trouble finding anything on google because I'm not sure how to phrase the search. What I...

Compare top 2 transactions from 12 months from the current transaction date -

SQL Server 2014 : Administration - SQL Server 2014

Recreating SSISDB - Hi Is it possible to drop and recreate SSISDB database.My collegue restored SSISDB to a new server and now all the...

SQL Server 2014 : Development - SQL Server 2014

Parsing First and Last Names from Full Name - Hi there! I have this code: SELECT CASE WHEN CHARINDEX(' ',name) = 0 THEN name WHEN CHARINDEX(' ',name) = PATINDEX('% _%',name) THEN RTRIM(SUBSTRING(name,...

SQL Server 2012 : SQL 2012 - General

DB Corruption - Hello, One of the teams at my place of work came to me with a problem with one of their SharePoint...

Pass SSIS parameter into Agent Job - Hi The problem: I am calling a stored proc from VBA which executes a stored proc. The stored proc triggers an...

SQL Server 2012 : SQL Server 2012 - T-SQL

Get Query used for update/insert/delete and log it with a trigger - I am trying to get the query executed to perform an insert, update or delete on a table, but only...

Insert with null - Hi I have a table called Remote_Item with some records like

SQL Server 2008 : SQL Server 2008 - General

how to find the lowest usage of a database - Hi Guys How do we find the lowest usage of a database ? I need to find the best time to ...

Reporting Services : Reporting Services

Databases using Reporting Server - Hi, Is there a way to see what db's are connecting to report server over the last 30 days. Hope...

Programming : Powershell

parse string and check for valid date - I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13) for...

Convert VbScript Com object to PS to load sql2005 DTS pkg - Trying to Convert VBScript Com Object to PS. VbScript: Set objPkg = CreateObject("DTS.Package") objPkg.LoadFromSQLServer machine,,,DTSSQLStgFlag_UseTrustedConnection,,,,packageName objPkg.Execute PS: $DTSSQLStgFlag_UseTrustedConnection = 0x100 $dtsapp = New-Object -ComObject DTS.Package $dtsapp.LoadFromSqlServer( $server, [typ

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.