| A community of more than 1,600,000 database professionals and growing |
| | | What do you do to relax after work? Today we have a guest editorial as Steve is out of town. I would guess most of us have demanding jobs, which can be stressful at least some of the time. Perhaps for some of you, the strain of job stress rarely leaves you. I have been in situations like that, I am thankful my current position has much less stress then my previous one. Still, even if you aren’t under much stress it is still nice to relax after work. So what do you find relaxing? I imagine a number of you enjoy going to the local watering hole to enjoy a beverage with some friends. Perhaps some of you find exercising relaxing. Personally, I don’t. Exercising causes me to feel tired, which perhaps helps me sleep better, but I don’t find the time during or after exercising particularly relaxing. Others, might enjoy streaming a movie or watching a show on TV, or playing a video game. I confess I have spent way too much time playing Agar.io much to the irritation of my wife. I am sure many of you enjoy social media like Facebook etc. It is interesting as I consider these different avenues to “relax” it seems that they are sort of fun and they certainly take up time, but do I truly feel more relaxed afterwards? This caused me to ponder what is something that really helps me feel more relaxed? I realized for me, I really enjoy reading. When I have a good book or the latest issue of popular mechanic, after 20 or 30 minutes reading I feel quite refreshed. Now I realize you may not enjoy reading, or reading just doesn’t relax you. I guess my challenge to you is to spend some time considering what you are doing during your off hours and decide if those activities are actually refreshing you and causing you to relax. Perhaps that stressful show is not the best thing to watch when you are trying to unwind after work. Maybe social media is causing more irritation then doing any good. Winning one more round of a game or reaching that next level can be fun, but also stressful, which is the opposite of relaxing. I would encourage you to spend sometime today or in the near future thinking about how you can better relax in your off hours. Let me know what you come up with. Perhaps your idea of a good way to relax will inspire someone else to do the same. Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | NEW SQL Clone - version 1 now available! 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. |
|
|
|
| | | | | John F. Tamburo from SQLServerCentral.com Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter. More » |
| | Additional Articles from SimpleTalk When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature. More » |
| | More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar. More » |
| | matthew.mcgiffen 73574 from SQLServerCentral Blogs This is a quickie post to introduce the new DBCC command CLONEDATABASE. Okay so this isn’t technically a SQL Server 2016... More » |
| | Steve Jones from SQLServerCentral Blogs I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss... More » |
|
|
| | | Today's Question (by Steve Jones): Why are spatial methods faster in SQL Server 2016 than previous versions? |
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: Spatial Data. 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 | | Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today. | e |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Igor Micev): What is true about stored procedure parameters? (choose 2)
Answer: Parameters can be input only Parameters can be input and output in the same procedure Explanation: Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output. The OUTPUT keyword in the procedure’s definition or its invocation, designates the input/output type of a parameter. Reference: click here 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. Statistics with NORECOMPUTE - Evening All, When would one typically specify NORECOMPUTE on Statistics? Presumably when the data is changing dramatically in a way could skew... 2016 Cluster Questions For Always On but also with other services - I'm trying to build up my clustering skills in my Lab, which is an all virtualbox environment. I wanted to create... Database Architecture Question - Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend... My organization... SSIS Project Deployment - Hi there, We are about to deploy a third party SSIS DWH project which contains over 100 packages on SQL Server... Starting with Full Text Search: Suggested links ... - Hi, I am starting with Full Text Search. Am reading a chapter on that in a book by well known authors,... Deadlocks When Expiring SSRS Dataset Cache - We are currently on SQL Server 2014, V12.0.5203.0. We use SSRS as our core reporting tool. Most of our report... SSIS Failure Workflow not getting triggered upon OLAP processing task failure - Hi, I have a SSIS package which contains a For Loop container that will execute at max 100 times. Within this container... How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates... fill factor with clustered PK on identity PLUS another column - Most of our tables have a clustered PK on an integer identity column. These have a fill factor of 100... sql query - From the tables given below i need to know the values of 'ThPr_name' from TheoryPractical table and 'ETPA_name' from EndtermProgressive... Cancelled Full Backup -- What of Differential Backup Now? - Morning All, I had to cancel a full backup that was underway as it was started in error. As a result the... 'Spell check' a string-valued field - Hello all, We have a field in a table that's a string-valued field. In this field are (mainly) what I'll call... Instance is under memory pressure. How to relieve from pressure - Instance is under memory pressure. How to relieve it from pressure DBCC is running from 5 days - We have a huge database in TB size.We have a job that reorganizes/rebuilds indexes on all dbs and then does... Convert DATETIME, trim leading zeros - Hello All, How can I alter this convert statement to return 1/25/2012 rather than 01/25/2012. Or return 1/1/2012 rather than 01/01/2012 SELECT CONVERT(varchar(10),getdate(),101) Thanks... Page File location and Size - I found out there is a huge (33GB) pagefile on the database data drive on one SQL Server box. The page... Dynamic report header based on condition - I have a requirement to show the company name in the report header based on the login user id. User... Instances of 2008R2 and up to 2016 - I have a database on isntances of 2008R2 and upwards. I would like to produce some SISS packages that would hopefully... How to load and in what order warehouse tables - Hi, I am somewhat new to were housing but not new to SQL. I have been looking all over the net and... SQL Server DBA Certification - Hi All: I want to become a certified DBA, i'm not sure what path is the right one. I have exprience... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
