SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Containing the Work

Containment is becoming more prevalent in the computer world. We have containers coming to Windows Server 2016 (or earlier versions with WinDocks), a concept that's been embraced in the Linux world for some time. If you haven't looked at containers, they are a great way to isolate and stabilize your application environment. They can also be great for dev/test environments. You might do a little reading to understand how they can be used.

While containers might be good for SQL Server (or maybe not), we've had other types of containment in SQL Server. We got partially contained databases in SQL Server 2012, with little change since then. That is susprising to me since I expected that all Azure SQL Databases would be contained, and we would want more functionality inside of them. However, those have opened up slightly and I'm not sure where containment is going.

Personally I'd like to see jobs contained inside of a database. The vast majority of processes I've written over the years for application or system work on a database pertained only to that database. I'd like to see things like backups, maintenance, etc. contained as jobs inside a database, that travel with the database as I detach/attach it, backup/restore, and more. That might eliminate some of the issue with clusters and AGs if most jobs moved with a database.

That got me thinking. What else would we want to contain? The thing that comes to mind is a distributor. I'd like to have a distributor somehow contained with all the information about replication processes contained inside of this database (including the jobs). The database would need a way to register with the instance so the publisher and subscribers could find it, but wouldn't that make replication administration easier?

How about the SSIS Catalog and ETL information. Having more information here as a contained database might make managing ETL operations easier, especially if we need to move the load to another instance.

I'm sure there are other ways in which having information, metadata, and job functions contained inside of a database would be helpful, and easier on the administration of the system, whether by humans or automated systems.

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 ( 3.8MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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

ADVERTISEMENT
SQL Clone

NEW SQL Clone - version 1 now available!

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free.

Featured Contents

 

Detective Stories - Tracking Down the Database's Dependents Part I

Brandie Tarvin from SQLServerCentral.com

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article. More »


 

Project Bletchley - The Microsoft Vision for Blockchain

Press Release from SQLServerCentral.com

The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March More »


 

Finding the Worst Performing TSQL Statement

Additional Articles from Database Journal

Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements. More »


 

From the SQLServerCentral Blogs - SQL Clone

Grant Fritchey from SQLServerCentral Blogs

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server... More »


 

From the SQLServerCentral Blogs - Queries with optional parameters

Kenneth Fisher from SQLServerCentral Blogs

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or... More »

Question of the Day

Today's Question (by Henrico Bekker):

Which system database will by default be encrypted when enabling TDE encryption on any user database?

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: Transparent Data Encryption (TDE).

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

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to use ALTER SERVER CONFIGURATION in SQL Server 2016 to set process affinity in my processors. What are my options?

Answer: CPU, NUMANODE or AUTO

Explanation:

Using ALTER SERVER CONFIGURATION, I can set the PROCESS AFFINITY option in three ways: by numanode, specific CPU, or using AUTO.

Ref: ALTER SERVER CONFIGURATION - 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 2016 : SQL Server 2016 - Administration

moving several large databases from old hardware Live to new hardware - Hi, My primary server has about  40  400 GB  ( Windows Server 2003 with SQL Server 2008 ) databases each  which need to be...

Please explain difference between these terms - Server authentication” vs “Windows authentication Server Roles vs Database Roles Logins vs Users


SQL Server 2014 : Administration - SQL Server 2014

All Columns as Included - Hi Experts, Have a select query which is selecting 40 columns .Created index with key columns in where clause and added...

Very large Indexes (~3TB) and need to rebuild fast - Hi, Hi, We have a 40 TB DB, and have some big tables and few indexes which are too big now to...


SQL Server 2012 : SQL 2012 - General

Format Date but Keep as Date Type - I have a date field of type datetime in a table. But while I'm creating a view out of this field...

Use date and time in sql statement for join, but not required in the output - Afternoon, I'm using the date / time from a view to join on the date / time from another part of the view,...


SQL Server 2012 : SQL Server 2012 - T-SQL

tsql help - Hi All, Need query help. Below is my test table and test data. create table test (c1 int not null identity(1,1), c2...

How to make one innerjoin to bring all value of all the substrings within a string separated by a comma - Hi,  I have two tables, answers and lookup, In my answer table I have a field named: value, it my contain...


SQL Server 2008 : SQL Server 2008 - General

Global Temp Table - If I use #Final as a table (instead of #3Final) I get a message Invalid Object Name #Final.  Is there...

2008 R2 Jobs from .bak files not shown in new server when restoring - Hello, I did full backup to our 2008 R2 SQL and restore to another 2008 R2 SQL server the only problem...

Varchar Column type estimates - I just realized sql server is estimating different data size when my column is varchar(7000) with table 72 million records,...


SQL Server 2008 : T-SQL (SS2K8)

Cursor Insert into table with IDENTITY crisis - I have been coming at this problem from several different angles, off and on, for a few weeks now.  This...


Data Warehousing : Analysis Services

Manually Added Partition to Tab Cube, now Fails on load, Have to Process manually - Hello, I have a Tabular cube in SQL Server 2016 that has partitioning tables, I had to restore it from backup,...

This email has been sent to {user_email}. 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.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com