 | A community of more than 1,600,000 database professionals and growing |
| | | Thanks for the Memories, Tom I had other things to do today. There's no shortage of work, I travel this week, and I'm behind on a few things, but that all ended this afternoon. I saw a note on Tom Roush's Twitter account from his daughter. Tom passed away on Tuesday, Jan 30, 2018. I'm saddened, with watery eyes and a heavy heart this afternoon. I've known Tom was ill for some time, battling cancer, and it always brought a little joy to my heart when I saw a new post on Facebook from Tom. I was also a little saddened after reading, wondering if this was the last communication I'd get from him. He's one of the few SQL friends I have on that platform, and I've enjoyed keeping in touch and communicating. Tom and I lived in separate cities, and rarely had the chance to sit down in person, but we've exchanged a lot of private messages over the years, and getting the chance to chat with him in the middle of a busy day was always a treat. Tom has been a DBA for a long time. He has had a blog for SQL stuff, but he has really shined in his storytelling and communications. Tom supported others, with always a kind word of praise, advice, or a suggestion, given at the right time to help someone. Tom was truly a wonderful soul in our #sqlfamily. A couple years ago Andy Warren and I put on a Game Night at the PASS Summit. This was another of our experiments at trying to find new and interesting ways to engage people at the Summit. Many of us are introverts, and both Andy and I dislike the loud, crowded environments. For years we'd debated doing this for the SQLServerCentral party, but the popularity of the Casino Night kept us from experimenting. This year we managed to procure a room and spent an afternoon shopping for some games for people to play. We weren't sure how many would come, and I was planning on staying only a short while because of work commitments. We got the room opened, the bartender inside, wrote some signs by hand and stood around. A few people wandered up, some bringing their own games. As the evening progressed, I was about to leave when I saw Tom walk up to the room. An older, weaker Tom that wasn't attending the conference made the effort to come out to the community, despite weakened from illness. We found him a chair and a beverage and sat down to spend some time. I stayed longer than I should have, given the demands of my day job, but that 30 or so minutes, where Andy and I could sit and chat with Tom was worth it. I'll cherish that time for the rest of my days. We didn't have any great epiphanies, no life altering conversation. Just a few friends shooting the breeze, talking about the current events in our lives, reliving memories, and just catching up. RIP, Tom. You are a great man I'll always remember. Some wonderful stories: Red Converse High Tops (from Ken Fisher), Brent's favorites, The Paul Mile, and Life Lessons. If you'd like to donate to the family, you can do so here. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | SQL Clone: Now supporting databases up to 64TB 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 |
|  | | 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 |
|
|
|
| | |  | Bill Pearson from SQLServerCentral.com Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context. More » |
 | Press Release from Redgate Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More » |
 | Additional Articles from SimpleTalk Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system. More » |
 | Grant Fritchey from SQLServerCentral Blogs Deleting data from a table using T-SQL works quite a lot like the UPDATE statement. How it Works In the same way... More » |
| | Arun Sirpal from SQLServerCentral Blogs Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged... More » |
|
|
| | | Today's Question (by Steve Jones): I have these two sets of data in R: > First.Names <- c("Steve", "Andy", "Brian") > Last.Names <- c("Jones", "Warren", "Knight") I want to combine them so that I have a single vector with 1 row and three elements. Which code do I run? |
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: R Language. 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 | | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I am writing a PoSh function that will check for various database parameters, including the recovery model. I decide to include a parameter that will filter based on recovery model. However, I want to be sure that the user can't enter an invalid model as a typo. How should I specify the parameter, $recoverymodel in the function header?
Answer: Param([ValidateSet("Full", "Simple", "Bulk-Logged")][string[]] $recoverymodel ) Explanation: The syntax requires the ValidateSet function to be included inside brackets. The items that are valid in the set are in quotes and separated by commas. Ref: PowreShell Tool Time: Controlling Our Tools - http://www.sqlservercentral.com/articles/PowerShell/131080/ About Functions Advanced Parameters - 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.
How to rollback Dacpac applied - Hi, How to rollback Dacpack applied in a database. SQL Server version used is 16. Regards Binu
Calendar table - I have been trying to find out the best way to design a Normalized table for IMPORT INTO EXCEL 2016 - Hi Guys, i have just been upgraded to excel 2016. I trying to import data from SQL server into excel... Is learning Python/R an advantage for SQL Server Developers? Need an expert advice. - Hello Guys, Is it time for SQL Server Developers to start learning R/Python to excel in their career? Expert advice needed.
how to find if xp_cmdshell is being used or not - I am trying to figure out if we can find out if xp_cmdshell is used on a particular SQL instance... A little problem with the Agent - In a Instance the value for user_options How to copy a database with one big mdf file to another server with smaller multiple drives. - We have a server that has a database with a single File group (Primary) and has one mdf and one ldf file...
Result truncation bug - Here's an interesting riddle. I'm building a code generator, so the SELECT clause is just one great big concatenation of... Help me in update - complex - hi All, Hope all are fine create table #sample(id varchar(100), version_no int, set_type varchar(100), set_no int ,XML_NAME varchar(100)) insert into... OR in JOIN criteria - Apologies if this has been asked before, searching for it yields too many results. I've been eliminating NOT EXISTS in some...
AlwaysOn Availability Groups Failover - uncommitted transactions - My understanding is that when performing a manual or automatic failover of an availability group in synchronous mode. Any uncommitted...
Looking to sort two queries by Date, Time - SELECT LTRIM(RIGHT(CONVERT(varchar(6), .,100),7)) AS --, FORMAT(., 'MM-dd-yyyy') AS , CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), .,101),'/','-')) AS , LTRIM(RIGHT(CONVERT(varchar(20), Find out all the tables with VARBINARY column - Hi, Is there any way that to find out all the tables which include a VARBINARY type column? Thanks,
Automate Encryption Key opening in HA environment - Hi, Currently have a database setup in HA. Whenever a fail over occurs we need to run the below on the...
Sql Server Change from local Account to Domain Account - Hi, I'm trying to change SQL Server Account from local to Domain but I'm getting this error message. I'm using... Creating one record from multiple records - Hi From the table script below I would like to write a query that creates one row for each User. Each...
email with attachment powershell - This code runs successfully but does not send an email.Any help is appreciated. Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue function sendmail_withAttachment { Param ( # $smtpServer...
Script Tasks and input and output variables - is there any way in a script task to find out the actual variable names that were specified as readonly...
SSIS package last date/ time run - Hi, How to find date/time last SSIS packgae ran. Please let me know if you need any other details .. Thanks In Advance, -Krishna
Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|