It's a holiday in the US today. It's Labor Day, and many in the US have a break. With a holiday late last week, this turns into a 5 day weekend for me. That's unusual for me as I struggle to take time off. I enjoy my job, and it seems that I have no shortage of tasks I can find during the week. I'm trying to do better. Vacation is important, and I'm hoping to fit in more across the next few months.
Most of us work as labor for some enterprise. Whether it's an employer or our own business, we work to earn an income, support our families and, hopefully, find some sense of purpose in our efforts.
Work is hard, and every job is work at some point, but I hope you enjoy your employment more days than you don't, especially the work in technology. The tools, capabilities and amazing things we can do in the digital world are very exciting.
I've got a blooper real for the podcast that I hope you enjoy today if you're reading the newsletter. For those of you around the world, I know many of you may be working today, but I hope you have your own holiday at some point during the year that recognizes the efforts you put in.
SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners. More »
The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell. More »
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one... More »
Question of the Day
Today's Question (by Steve Jones):
It's Labor Day in the US. Today's question is "how many points are the fun, holiday questions worth?"
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 QOD, simply log in to the
Expert Performance Indexing for SQL Server 2012
Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.
You wish to enable xp_cmdshell. You run the following code:
@configname = 'show advanced options'
,@configvalue = 1
@configname = 'dsh'
,@configvalue = 1
What is the outcome?
The first call to sp_configure succeeds
The second call to sp_configure succeeds
Explanation: Even though the full configuration name is xp_cmdshell, SQL Server will only find 1 unique entry for the characters values of "dhs" and be able to link it to xp_cmdshell. From BOL: "The SQL Server Database Engine recognizes any unique string that is part of the configuration name."
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.