| A community of more than 1,600,000 database professionals and growing |
| | Holiday traditions Today we have a guest editorial as Steve is on vacation. The holiday season is quickly approaching, and this got me thinking about holiday traditions. I know many people are all over the map with how they celebrate the holidays. Some people let their children believe in Santa Claus (Father Christmas, Saint Nicholas, etc.), but others do not. Some people give gifts and others don’t. Some families have certain food or meals they always do during this time of year. When I was young, my father had an unusual Christmas tradition. On Christmas eve there was nothing. No lights, no tree, no presents. My father certainly encouraged my brother and I to believe in Santa Claus. My older brother and I would ask him on Christmas Eve if Santa Claus was coming. He would say, “I sure hope so.” That night, he would put us to bed early and then he would go out and buy a tree. He would put up all the decorations and bring out all the presents. I can tell you when my brother and I got up Christmas morning it was awe inspiring. Even long after I no longer believed in Santa Claus, I still had trouble going to sleep on Christmas eve. I think it is good to have some holiday traditions as long as they are meaningful to you. We can have traditions at our places of work as well. I am sure a lot of companies take out new employees for lunch on their first day. Perhaps on their anniversary they get another free lunch. There might be a day where everyone brings in their homemade holiday cookies or treats to share with each other. My office has a contest over Halloween. People dress up in costumes and whoever is judged the winner, gets a prize. Sometimes it is a really nice prize like a weekend getaway for two. I think there are some other work place traditions we should consider over the holiday period. Traditions like going over and testing out disaster recovery plans. The holiday time can be slower for some companies and it seems like a good time to review or test out things that you don’t normally have time to work on. If you have never tested a production backup and restored it, this would be a good time. Now you should be testing your backups and ensuring the restore properly more than once a year, but if you aren’t doing it at all, better to do it now, over the holidays, then never. Hopefully, you have some holiday traditions that you and your family enjoy. If you don’t perhaps this is the year to create some new traditions. It also might be time to create some new holiday traditions in your work place as well. Share some holiday traditions you do during this season. Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | Database migrations inside Visual Studio Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free |
| | Write, format, and refactor SQL effortlessly with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
|
|
|
| | | Peter Davidson from SQLServerCentral.com In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members. More » |
| A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers. More » |
| Additional Articles from SimpleTalk Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in the GROUP BY clause is not that difficult, but what do you do if you need to include different combinations of group by expressions in the same result set? Alfonso demonstrates how to use the GROUPING SETS operator to accomplish this task. More » |
| Kenneth Fisher from SQLServerCentral Blogs SQL Server login ids may not be the most secure thing in the world but they are likely to be... More » |
| Ed Elliott from SQLServerCentral Blogs I have been working with ARM templates for a little while and have found it really annoying to test functions... More » |
|
|
| | Today's Question (by Steve Jones): I have created a new SQL Server 2017 database, in which I want to enable automatic tuning with this code: ALTER DATABASE TheNextFacebook SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON ); Before I do that, what do I need to turn on in the database? |
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: Automatic tuning. 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 | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a table with a few rows in it. ContactID FirstName 1 Tom 2 Peyton 3 Eli 5 Drew I have this code. What happens when I run this? DECLARE @name VARCHAR(100) = 'Bob'; SELECT @name = c.FirstName FROM dbo.Contacts AS c WHERE c.FirstName = 'Joe' PRINT @name Answer: Bob is printed Explanation: In this case, there is an initial value for the variable. Since the SELECT statement doesn't return anything, the initial value isn't changed. Ref: SELECT - 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 Restore takes long time - how do I clear committed transactions from log ? - Hi everyone, There is so many blog posts and articles out there about this case and I have been reading, but... Restore full backup at first and restore diff backup later, can I? - Let me explain. I have a big database (250 gigs) that I need to restore on another machine. Copying and restoring... Why the performance difference (parameter)? - Hello, How do I troubleshoot/resolve this performance difference when parameterizing vs not parameterizing this query? These two queries are essentially identical. This... SQL server 2014 slower on more powerful desktop than a laptop - Hello.... this is driving me nuts. I have a macbook pro and a mac pro both running windows 10. The macbook... Null Value Behaving Weird in SQL Query - Hi Guys, Need help to understand, Please help me to understand.... Here is my sample data ID,FNAME,LNAME,STATUS 1,Smith,Sam,Active 2,Faid,Kim,Null 3,Jim,Al,Null My Simple SQL Query is Select * from table1 where... Where do you set an SSIS EvaluateAsExpression property of the variable to TRUE? - Where do you set an SSIS EvaluateAsExpression property of the variable to TRUE? Index sugggestion... - Hi All, I have below query and the table has 933575 rows in it. I would like to create a... Selectivity vs SARGAbility? - Hi All, What is the difference between Selectivity and SARGAbility? Thanks, Sam baselines and benchmarking - Hi All, What is the difference between Baseline and Benchmark in performance terms? I Often get confused? Any anology of remembering... Replace TABLE with STAGING_TABLE. Approach? - I have a Stored Procedure which does some ETL "stuff" At the end of the procedure I want to replace a... Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ? - I have a table with 4 columns and 10 million rows in which I want to update 1 column I have... Please get rid of this constant, useless job alert!!!!!!! - I've been getting this email from the SQL Server Central website's daily for at least 2 months, notifying me of... |
|
| 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 |
|
|