SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Happy New Year 2018

It's the start of a brand new year, and hopefully many of you are not anywhere near your work today. I hope to be running a 5k this morning, so I'm up early, at my usual time for work, getting ready with a jolt of coffee before a nice jog. I haven't run a lot the last few months, so I'm just going for fun. I'm writing this early, so if the weather is bad, I'll likely go to yoga instead.

In any case, this is usually a day off for most people working with data, so I hope you enjoy yourself with a quiet day before we begin the new work year tomorrow. I'm excited, with less travel, to tackle some projects around SSC. We are looking to upgrade hardware and software, moving into the new era of SQL Server, maybe even with graph tables! If there's something you'd like to see, apart from bug fixes, let us know. I'll be meeting in the next few weeks to lay out a direction and try to get moving forward.

Happy New Year!

Steve Jones from SQLServerCentral.com

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

SQL Clone

SQL Clone: Now supporting databases up to 64TB

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

SQL Compare

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


PowerShell Tool Time: Controlling Our Tools

Mike Fal from SQLServerCentral.com

The next installment of the Powershell Tool Time series shows you how to manage backup files by More »


Can you prevent deletes and inserts without a WHERE clause from running?

Additional Articles from Brent Ozar Unlimited Blog

Erik writes a script to do what it says on the tin. More »


From the SQLServerCentral Blogs - BK’s Professional Learning Plans for 2018 #tsql2sday

Brian Kelley from SQLServerCentral Blogs

With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask... More »


From the SQLServerCentral Blogs - T-SQL Tuesday #97 – Setting learning goals for 2018

Kenneth Fisher from SQLServerCentral Blogs

T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic... More »

Question of the Day

Today's Question (by Steve Jones):

Which of these converts to this year? (choose 2)

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 7 points in this category: humor.

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


SQL Server Query Store In Action

The Query Store changes the way you monitor performance on your databases and the way you tune the performance of those same databases. This book represents a deep dive into a large number of topics in and around the Query Store. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What's today?

Answer: SELECT DATEADD( dd, -3, DATEADD(yy, DATEDIFF( yy, 0, '2017-04-01'), 0))


Simple date manipulation to find today's date.

Ref: DateAdd - click here

Datediff - 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 - Development

SQL InMemory Natively Compiled SP - unsupported constructs - We're looking at converting several normal T-SQL Stored Procedures into Natively Compiled SPs for performance. The SPs use a ton of...

using araylist in stored proc - hello i have this stored proc for  dynamically insert update delete select  and select with id but hier have a 2...

SQL Server 2012 : SQL Server 2012 - T-SQL

SQL Server Over Partition - I have added the code that was missing. Column A is not a dollar figure but a limit payed out....

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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com