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

The Voice of the DBA

HA HA HA

Enjoy our latest crossword puzzle and see if you can solve all the clues. The theme for this crossword is high availability. The key will be posted in the comments tomorrow.

Across

4. Same piece of data was updated in two different locations.

5. Instance that keeps an eye on articles for changes.

7. Backup log, copy log, restore log.

12. A set of databases that fail over together.

17. Can be an initial copy of the data.

18. Copy of the whole database, but no, it's not backward.

20. Where the data is written to. AG

21. Receives data. Can be a push or a pull.

23. Potential failover target.

24. More than one writeable location.

Down

1. Always points to the primary replica.

2. Edition required for Availability Groups.

3. Manage these separately if you want your batch process to work after a failover.

6. Manage these separately if you want to be able to log in after a failover.

8. A group of Articles.

9. Commit now, sync later (hopefully).

10. Switch over to a secondary.

11. Instance that receives the data.

13. Marketing term that covers Availability Groups and Failover Cluster Instances

14. Notifies the subscriber of changes.

15. Instance required for automatic failover in mirroring.

16. Copy

17. No commit until the secondaries are set.

19. Allowable data loss after a disaster. abbr.

22. Secondary that can be used for backups or reporting.

Kenneth Fisher from SQLServerCentral.com

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

Using SQL Census to audit SQL Server permissions

Redgate have just released SQL Census, a prototype tool that makes auditing SQL Server user access permissions much easier. In this post, Ally Parker shows how it works, tells us what's up next in the tool's development, and explains how you can download it for free. Try the free prototype

The best career move you can make

On the new Redgate Hub, we’ve gathered together a wealth of information to help you solve problems, share ideas and discover the latest insights. Whatever you need to know about to advance your career, the answer is probably right here. Move to the Redgate Hub

Featured Contents

Stairway to Database Design Level 5: Procedures

Joe Celko from SQLServerCentral.com

Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers. More »

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Additional Articles from Redgate

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. More »

SQL Server R Services: Working with ggplot2 Statistical Graphics

Additional Articles from SimpleTalk

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it. More »

Improved parentheses formatting in SQL Prompt 8.1

The SQL Prompt team have made some improvements to parentheses formatting in the latest version of the tool - here are the details of what's changed and why. More »

From the SQLServerCentral Blogs - Seattle SQL Pro Workshop 2017

Jason Brimhall from SQLServerCentral Blogs

Seattle SQL Pro Workshop 2017 October is a great time of year for the SQL Server and Data professional. There are... More »

Question of the Day

Today's Question (by Steve Jones):

I have a file containing some data for the top NFL Quarterbacks from 2016. The data is stored in a tab separated format in the file 2016QB.tsv. How can I read this in?

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: R Language.

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

Professional Microsoft SQL Server 2014 Integration Services

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I've got a date that I want to format to look better for a client report. My intention is to get the date to just show the month name and day. I have heard the new FORMAT() function makes this much easier, so I decide to use that. Here's my base code:

 declare @date datetime2 = '20171024 08:24:15' select format(@date, )

What should I use for the second parameter of the FORMAT function?

Answer: 'M'

Explanation:

The FORMAT() function takes the .NET formatting strings as the second parameter. In this case, the 'M' will return the month name and date, October 24. The others return numeric values.

Ref: FORMAT() - click here

Formatting Types in .NET - 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

backup to MSSQL 2012 from mssql 2016 - I do not think it's possible, but i could really use it. Best regards Edvard Korsbæk

Making Indexes Invisble to the Optimiser - Good Morning Folks! I am working on an optimisation project that is focusing heavily on indexing within the database. At the...

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

Nested insert statements problem - Hello all. fairly new to SQL. but not that new. I have 3 stored procedures. The first one has a statement like...

Challenging string handling in T-SQL - Hello Experts, I have a data in a table as shown in the first column (A) and would like to update...

SQL Server 2014 : Development - SQL Server 2014

How to only select 11pm to 7am in DateTime (many months of data) DDM&DDL included :) - Looking to run a report for a few years but only between 11pm and 7am. CREATE TABLE mytable( i_ticket_id INTEGER NOT...

Possible to add a Total for Amount at the end of each day? - DECLARE @Yesterday DATETIME = DATEADD(DAY,-1,CAST(GETDATE() AS DATE)); DECLARE @PeriodStart DATETIME = DATEADD(DAY,-6,@Yesterday), @PeriodEnd DATETIME = CAST(GETDATE() AS DATE), @MonthStart DATETIME =DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0); SET NOCOUNT ON; SELECT ...

Set up job to convert word document to pdf - I'm working on a SQL job to transfer some data along with some word documents. After copying the word documents...

Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...

Database design to handle Millions of records - Dear Techies, Please suggest how should design database to handle millions of records. And also let me know strong points to...

SQL Server 2012 : SQL 2012 - General

parallel installation of SQl Server, - We have a 2012 windows server with SQL 2012 installed. . Can we install SQL 2016 on the same server in a separate partition?

Importing data reports data truncation in both EM and SSIS from multiple data sources - First, I'm retired so have time to play with my own data. I have two data sources, an extensive collection...

SQL Server 2012 : SQL Server 2012 - T-SQL

SSIS : "The value could not be converted because of a potential loss of data.". - Dear all, I have a data conversion task and I am getting the following error message: while converting column "VALUE_IN_FUND_CURR" (488) to...

Find tables - I have to design a script to find all tables in a database with below criteria. 1. Identify all tables should...

Identify wrong links inside a hierarchical tree-structure - Hello, I'm working on an electrical network, edge are link between nodes, insert lines with 'end' are all clients. The first line...

SQL Server vNext : SQL Server 15 - Administration

Open .PRC with connection - Using V17.3 and 2008R2 When I double-click on an .sql file, SSMS v17 launches with a new connection window. When I...

SQL Server 2008 : SQL Server 2008 - General

Resource Governor Classifier Function Question - How to restrict resources usage based on individual Databases in resource governor? We have many databases in one instance; I would...

SQL Server 2008 : T-SQL (SS2K8)

Session Scope with Temporary Tables and Dynamic SQL - I came across something interesting while troubleshooting a developer's code recently. We use temporary tables which are populated by executing...

Programming : General

Managing Assemblies - Dear Community, An application that validates user accounts, using assemblies, IIS, etc. works fine. Lately, some problems has originated that validation get...

Data Warehousing : Analysis Services

Measures showing up Blank in Power BI - When I attempt to connect POwer BI Desktop to my tabular model, The measures all show up blank. I am able...

SQL Server 2005 : Administering

Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.' - Hi, While trying to restore a database (with replace option), I am getting the below error - Exclusive access could not be...

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.