| A community of more than 1,600,000 database professionals and growing |
| | | Back From Vacation and Ready To Go It's been a good holiday for me. I had a week's vacation with just my wife, a nice holiday with kids, and a relaxing week where I'm trying to get a few things done. I've been away from my home office for two weeks, and it often takes a few days to get used to focusing again at the computer, but I'm getting there. It doesn't help that the office, err, house is full of people with my kids away from school. The year is coming to a close, and it's a slow week, as I noted yesterday. However, I'm refreshed and recharged. Getting away on an adventure, without a computer to spent time on was great. I did no work and just enjoyed the time away. That's how a vacation should go, and it's the type of trip I need to take more often. Now it's time to move forward again. As I wrote about in my goals post, I'm planning on spending some time thinking how to achieve my learning goals in 2018. Today is that day, with an hour set aside to do a little research for resources and attempting to build some sort of calendar with milestones that will help me move forward. Those are the personal items for my career, tangential to my work. The other part of today is really digging into where I want SQLServerCentral to go next year. We need to be mobile friendly moving forward (thanks for the push, Google) and that means some code changes. I want to be more involved here, along with upgrade plans to get us onto more modern platforms. The old SQL2008/WS2003 system works, but it's not ideal, and we can't take advantage of newer technologies and opportunities that Microsoft has released. My thought is to add new content and new sections to the site, including some better quiz/test/assessment ways for people to check their skills and work towards their own goals. If you have ideas, let me know. It's been a great year at SQLServerCentral, and I hope you feel the same way. Now, on to 2018 and let's see where we can go. 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 ( 3.4MB) 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 |
| | | | Benchmark your Database DevOps maturity level Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment |
|
|
|
| | | | | Additional Articles from Database Journal There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance. More » |
| | You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio. Related to this, Redgate is doing some research into cross-platform data tools. Read this blog post to find out more about what they're doing, and how you can get involved. More » |
| | Solomon Rutzky from SQLServerCentral Blogs Welcome back! Previously, on “Who’s Collation is it Anyway?”, due to statements made in the Microsoft documentation for “Search Conditions”... More » |
| | Matthew McGiffen from SQLServerCentral Blogs I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve... More » |
|
|
| | | Today's Question (by Steve Jones): It's the fourth day of Christmas week and fun questions (with one more less point). The question today is who said this? "You want the moon? Just say the word and I'll throw a lasso around it and pull it down." The answer comes from this data set. What's the order by? SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', '''s a Wonderful Life', 'Adult', 'Falls') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY |
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 4 points in this category: humor. 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 | | Exam Ref 70-761 Querying Data with Transact-SQL Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): It's the third day of Christmas week and fun questions (with one more less point). The question today is who said this? "Bah Humbug" The answer comes from this data set. What's the order by? SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', 'It''s a Wonderful Life', 'Adult', 'Classic', 'Bedford Falls') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY
Answer: locale desc Explanation: This is Scrooge's famous line. If you sort by locale desc, you'll get his name. Happy Holiday Week! » 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. Tempdb growth - Hi, I have a huge insert/update operation performing in set of tables. The process tooks almost 1-2 hours to complete. Meanwhile... Combine 3 SQL queries - Hello, I want the combine the following queries Select Complains. as NewComplains,Complains.ID AS ComplainID from Complains where Complains.ReadStatus = 'false' Select Suggestions. as... Splitting TempDB across multiple files - I have a question regarding the splitting of TempDB in SQL Server, I know its a must in production environments... Need to put large database into norecovery state - Hello, I have two servers in an Availability group. Servers A is primary and Server B is secondary. For some reason, the... dm_os_process_memory shows more memory usage than dm_os_memory_clerks & dm_os_buffer_descriptors - Hi, I'm looking for some help finding some missing memory and how to reclaim it without restarting the SQL service. The original... suggestion on table order inside a join ? - Hi All, Does the order in which the tables are placed inside a join matter for getting better performance? Assuming, below... Simplified maintenance of columnstore indexes - Hello all, I've just started to use columnstore Indexes in a SQL Server 2016 for a datawarehouse and realized, that it... MDS - Business Rule -> Stored Procedure -> Insert/Update in another DB - Hello all, I'm not sure if i'm posting this in the correct area however it is an MDS related question. I have... Server Not Responding - Hi Experts, The active server in 2 Node Active\Passive Cluster having another Always On AG node was not responding till we... SHREDDING XML - Can it be done quickly? - I have the following combination of code, for which the declared xml variable isn't something I can influence. However, looking... Using hardcoded database names in query when database names are different on development and production server - I have a database 'DatabaseA' which exists on a development server and a production server (called 'DatabaseA' on both servers).... Added a SELECT inside INNER JOIN. Very Slow Performance - HI, I have a sql and added another SELECT inside an INNER JOIN. It is executing very slow now. How can... Explain the execution of a cte - Hi, I had written a cte which has come complex joins and selected 7 columns for output. It contained 4 million... Two tables, exact same structure but with different names, behave differently while performing mass updates. - Hi all, This has me stumped. I'm performing mass updates to a table. I'm using Data Masker by Redgate to de-identify... avoiding distinct operator ? - Hi All, Is there a better way to re-write below type of queries? Most developers tend to keep DISTINCT Operator... Allowing a Web Server to connect to two sql servers that are not in the same domain - We have a production Web Server that is currently connecting to our SQL Server which is obviously in the same... OPENROWSET when Excel worksheet name is unknown - I've created a stored procedure that accepts two arguments: the name of an Excel workbook (@workbookBillRun), and the name of... Data-driven subscriptions - sequential or parallel. - If I have a data-driven subscription that will produce 12 reports, will SSRS try to run those 12 reports at... Export to multiple Workbooks with multiple worksheets - Hi I have a query related to exporting to Excel workbooks in SSIS. I've read the two articles below posted by Rafael... Processing a dimension - Hi Friends, I am new to SSAS. Sorry for this question if this is silly. I have added a attribute to... |
|
| 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 |
|
|
