 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | In Memorium I'm getting older, and as I remind people when I talk about careers and balance, I likely have less life ahead of me than behind me. I think about that as I try to enjoy life and appreciate the good and bad things I experience. I've had a wonderful life, and I can't complain about anything. I wish everyone could say the same thing. My apologies in advance for the tone of this editorial. This week I added a new category to the Database Weekly newsletter: Obituaries. I had Andy Warren suggest this earlier in the year, but I neglected to do it then, mostly because it's a sad reminder of loss. This past week we experienced another loss in the #SQLFamily, with the passing of Naomi Williams on Oct 30. There is a memorial fund set up for her children. I only briefly knew Naomi as a fellow speaker and the organizer of SQL Saturday #550 - San Antonio, but I enjoyed her enthusiasm and joyful nature. This wasn't our only loss this year. Tom Roush passed away on Jan 30, 2018 (his book of stories is available). Robert Davis passed on April 2, 2018 (memorial fund), and I found out this week that Aaron Lowe had passed on July 23, 2018. I'm sure there are others, and while I don't want to learn we've lost others, I'd appreciate anyone letting me know so I can remember them fondly. Life goes on, and we all must deal with losses. Those increase as we age, and that's becoming a regular occurrence as days pass by. Whether it's someone I've shaken hands with or an individual famous in for some aspect of their lives, death is something that I see far too often. Many of these are sudden, unexpected, and unpreventable. However, a few aren't, and I'd like to ask all of you to ensure you help others where you can. Suicide has taken a few people I have known, and if any of you are struggling, please seek help. If you know someone struggling, please refer them to a suicide hotline. If any of you ever need to talk, I'm here as are many of your friends and family. We have enough tragedy in life, so please don't withdraw completely. This is a sad week for me, but I'll toast to my current and passed friends at the Summit with fond memories, enjoying the moments we have and and will have in this life. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 5.1MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | 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 |
| |
|
|
| | |  | Warren Campbell from SQLServerCentral.com A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe. More » |
 | Additional Articles from Database Journal If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is. More » |
 | With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version. More » |
 | Martin Catherall from SQLServerCentral Blogs G’day, One of the things that I’ve been seeing more often than I would like to lately is large databases with... More » |
| | Justin Figg from SQLServerCentral Blogs As DBA’s we are sometimes put in a rock and hard place when it comes to database performance. This situation... More » |
|
|
| | | Today's Question (by Steve Jones): I have some data in a SQL Server 2016 database and table that was compressed with the COMPRESS() function. What function will return the original text to me from the table if I use it instead of the xxx below? select xxx(LogMessage) from dbo.Logger |
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: COMPRESS(). 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 | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): When I create a schema, I can optionally specify an owner. What are valid owners for the schema?
Answer: A database principal (user or role) Explanation: A schema can be owned by a database principal, so any user or role. Ref: CREATE SCHEMA - click here
» Discuss this question and answer on the forums |
|
|
| | | Edward Pochinski from SQLServerCentral.com The Default Windows Power Plan seems to be causing me some headaches on some busy SQL engines. Ok so if I had it my way I would have the DBA IO Tools, setup to update and use. That is some amazaing work ! But I belive this would have to pass throuh security at the company I work at. SO what to do, I checked Chrissy LemMaire's site, looked pretty doable. The PS Code will build you a nice csv for quickly importing into a SQL table. I hope you may be able to make use of the code. More »
|
|
|
| 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 dev stopped listening - A SQL 2017 dev instance stopped responding while watching a trace using profiler today. The service can be stopped and restarted...
get qtr,month and year from start date - I have start date column. how can i get rest of 4 columns of attached file. financial year begins from... DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...
ms_SQLEnableSystemAssemblyLoadingKey - In running a NIST-compliance security check, it advises that this asymmetric key uses an encryption algorithm (RSA_1024) that will no... Full Backup Files - Fastest Way to Copy Over WAN - Hi, I am trying to Robocopy large .bak files over the WAN and it's going terribly slow. The full backup files... SQL job step to copy backup file not working - Hello All, I'm trying to copy a recent backup file from one server to another using the syntax below as part of...
Execute a Stored Procedure against every row insert in Table - I have around 200 tables and we have insert in each table with in each seconds. so there are around 90... OPENROWSET - issue with spaces in the file name - Using SQL Server 2016. I am trying to read an Excel file using OPENROWSET. This works perfectly: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0... Finding the MIN or a group of values not used in a previous group - I have been having trouble finding anything on google because I'm not sure how to phrase the search. What I...
SSIS package + issues with scheduling a package. - I have a package which I have to schedule through SQL Agent. Just a simple package which reads the data from... huge free spaces in data file can make query slower? - Dear All, I need some info for the following 2 questions. Any idea please? 1. Keeping huge free spaces in the data file...
Date Field Calculation Logic - Can somebody please help with this issue... /* Here’s the problem: Let's say we had a table of all US Presidents, with...
Concatenate Strings in a COLUMN using comma delimiter, I need some nice code. - Please run my code and you will see what I mean. So I like to concatenate values in a column and... Any way to display multiple rows of tabs? - SSMS 2012: when you open up many sql files in the IDE, it starts hiding some tabs and you have...
Aggregate without self join - I am fetching the number of clicks and first click from number of devices using event table and click table. [code... Group By in a sub query - I'm trying to use the GROUP BY clause in a sub query that's part of my WHERE CLAUSE, but when... CASE to table conversion - This may be a fool's errand, but I have to try... I have a CASE in my code that checks...
Write Conflict - Hi all, So this issue is driving me bat guano insane. I have MS Access linked to SQL tables. 1. There is... How can I get a set Date and Time Range between Yesterday and Today? - Hello, I am looking to create a query that will get data between Yesterday at 6AM until 1AM today. Is there...
Non-SQL Server Certifications - I am not sure if this question is already posed before. But, I wanted to know if non-SQL Server certifications would... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
