 | A community of more than 1,600,000 database professionals and growing |
| | | Happy Memorial Day 2017 It's Memorial Day in the US today. It's a holiday where very few people should be working outside of the service industries. When I worked in restaurants, this was a busy day for us, and signified the start of the summer season. The last few decades, it's been a day of remembrance as well as one of spring chores and relaxiing with the family. With most of the US taking a break, this is also a fairly quite day around the world for most people. Hopefully it is for you, with no broken systems or high priority work coming your way today. I'll actually be working a bit today. I've got some deadlines to meet, and with my wife and daughter leaving town for a trip, this is a good time for me to catch up on a few things. I'll still be needing to cut some grass and do a few things, but I'll be sitting by a computer for most of the day. Holidays are a good time to remember there's life outside of work and you have a life away from SQL Server and data. That's not always the case, but I hope most of the days away from work are truly away from work, letting go of the stress and responsibility for a few hours. Happy Memorial Day. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | Could you help with some research? The Foundry team at Redgate want to hear about your experience with SQL Server asset management. Fill in this short survey to help out, and also to enter their prize draw for a $100 Amazon gift card. Complete survey. |
|  | | NEW SQL Clone - version 1 available now! 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. |
|
|
|
| | |  | Nick Burns from SQLServerCentral.com Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations. More » |
 | Additional Articles from SimpleTalk When you are automating a number of tasks, or performing a batch of tests, you want a way of automating the production of your plots and graphs. Nothing beats a good graphical plot for giving the indications of how the process went. If you are using PowerShell and maybe also SQL Server, it pays to use a command-line plotting tool such as Gnuplot to do all the hard work. It turns out to be handy for a range of data jobs, turning PowerShell into a handy data science tool. More » |
 | Additional Articles from Redgate If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works. More » |
 | SqlBarbarian from SQLServerCentral Blogs There are some beautiful ways to visualize time series data with the tools I'm going to go over. This post... More » |
| | Ryan Adams from SQLServerCentral Blogs Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but... More » |
|
|
| | | Today's Question (by Steve Jones): How can I prevent connections to my SQL Server from all applications except for the one I choose? |
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: Administration. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Stanley Kapfunde): Which of the following is not an exact numeric data type?
Answer: real Explanation: The correct answer is: D The Real datatype is an approximate numeric data type. Ref: Datatypes - click here SQL Server 2014 Development Essentials by Basit A. Masood-Al-Farooq page 22
» Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | |
| 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.
| This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|