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

The Voice of the DBA

Byte Me: Avoiding Detection

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

SQL Clone – create database copies fast!

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. Download the beta.

Featured Contents

Stairway to Server Management Objects (SMO) Level 3: The Database Class

Laerte Junior from SQLServerCentral.com

Learn how to get started working with SMO and PowerShell. More »

Introducing Minion CheckDB by MinionWare

Press Release from SQLServerCentral.com

Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs. More »

Planning for Successful Data Management

Additional Articles from SimpleTalk

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier. More »

From the SQLServerCentral Blogs - Running SSMS 2016 in Read Uncommitted Mode

Aaron Nelson from SQLServerCentral Blogs

Back in July when we received the first official release of SSMS not tied to an engine release we got... More »

From the SQLServerCentral Blogs - SCOPE_IDENTITY() or @@IDENTITY

Igor Micev from SQLServerCentral Blogs

I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from... More »

Question of the Day

Today's Question (by Steve Jones):

In SSMS 2016, there is a clipboard list, which contains a number of items that you have recently copied. What is the keystroke combination to cycle through the clipboard items?

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: Management Studio (SSMS).

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

Securing SQL Server - Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What are the complex built-in datatypes for U-SQL? (choose 2)

Answer:

SQL.ARRAY
SQL.MAP

Explanation:

There are two types of data types in U-SQL: Simple and Complex. The complex types are SQL.ARRAY and SQL.MAP. The other types listed as Simple types.

Ref: Complex Built-In U-SQL Types - https://msdn.microsoft.com/en-us/library/azure/mt764126.aspx

Simple Built-In U-SQL Types - https://msdn.microsoft.com/en-us/library/azure/mt764128.aspx

» 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

SSRS 2016 Error - When I try to access SSRS URL externally or from any other server it gives error: Could not load contents. Something went...

SQL Licensing Question - We have a UAT environment, in which customers outside of our organization run tests against software that we develop using...

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

Inserting DBCC Results into a table - Hi, my Goal is to insert the results from a DBCC CHECKDB into a table that will hold 6 months worth...

SQL Server 2014 : Administration - SQL Server 2014

SQL Pivot Query - Hi, I have managed to get a pivot using the following code Select SALESDESCRIPTION, GROUPDESCRIPTION, ACCOUNTNUMBER, ACCOUNTNAME, SUM(NP8) AS...

Execution plan estimates Join hint spilling. - Hi, I've been troubleshooting a performance problem with a stored procedure where depending on the parameters the row count on two...

Index Foreign Key & Other Indexes - Is it a good practice to index all foreign keys? We have Index on all foreign keys currently and for some...

Always On Readonly - Have created a always on setup in which 3 nodes are involved 2 in SQL server Failover Cluster and 1...

SQL Server 2014 : Development - SQL Server 2014

What's the best way of getting this to work? - Hi All, I'm working on an SP that will be run as part of an SSIS package and I'm not sure...

SQL Server 2012 : SQL 2012 - General

SQL Static Port - We have named SQL Server which uses Static Port (e.g: 4000). Application in the configuration uses that port but somehow it...

Too many workers? - Hi, I think have a problem with one of my SQL 2012 SP3 CU4 servers. Twice now, our two principal servers...

How to write a string to a file in SQL. - Hello All, I want to write a varchar(max) string to a file. The file should be UTF-8 (and not in a multi...

SQL Server 2012 : SQL Server 2012 - T-SQL

How to find PRIOR line of service? Help plz! - Hi guys! So I am stuck! I am trying to find prior line of service and I cannot come up with...

Age as of January 1st - Hello all, I'm really strugling on this age calcualtion. I need to find the age of a patient based off January...

Restore database with move - Hi everybody, I have a script to restore a database with move. I do not have a database yet for this...

SQL Server 2008 : SQL Server 2008 - General

How can I prevent a record from appearing based on two columns - Sorry for the vague Subject line but, I couldn' t come up with a good summary. In the table the...

Need help with bcp - I have created a job to export the results of a stored procedure to a folder on our shared drive...

SQL Server 2008 : T-SQL (SS2K8)

Help on query based on condition - Hello friends hopefully you can assist me In my query, I need to frame a condition like Count of activities of activity category...

Reporting Services : Reporting Services

SSRS Group Total does not match Excel - Am trying to create an SSRS report based off an Excel query. The source is an SSAS database. The hierarchy...

Data Warehousing : Integration Services

Package in Job failing, No Clear Visiable error, Errors logs clear, Unsure How to Approch for Fix - Hello, taken over where a contractor left off. He created a series of multi-step processes broken down to jobs that...

SQLServerCentral.com : SQLServerCentral.com Announcements

FAQ: Using the new forum Software (Jan 2017) - After we completed the forum upgrade on Jan 12, 2017, quite a few things changed, so this thread is a...

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.