| A community of more than 1,600,000 database professionals and growing |
| | | The Career Bucket List The Bucket List is a fun movie to watch, where two old men get a second chance at life and engage in some activities they've always wanted to enjoy. The idea of a bucket list isn't new, and there are plenty of sites that can help you manage one. Brent Ozar has one on his site that he calls his Epic Life Quest, and I've enjoyed watching him tick off items. I got the idea of my own list nearly 20 years ago after hearing Ted Lesonis on the radio. He had a list of 101 things to tackled in life. Since he sold his stake in AOL, he's had the resources to work on them. I have one, along with my wife, and we've worked through a few items over the years, though we were talking recently we need to revisit the list and perhaps revise things. Why revise a bucket list? One of the things I've learned over time is that I change and the values, goals, and desires I once had will also change. The things I've had put on a list at 20 years old would have included owning a Ferrari, a Porsche, and a Lamborghini. At 40+, having owned a Porsche, the other things seem a little silly and vain, not to mention very impractical. At this point in my life, there are other things I find more interesting and captivating. The bucket list of today would be more experience based and likely contain more volunteer oriented goals. I think my career has really changed as well, and as I move towards retirement, I don't know if there are many more goals for me in this area. However, if I think back, I know I'd have had lots of them when I were younger. There are a few things I'd still like to accomplish, and hopefully I'll find some time to work on them. For now, I wanted to ask you about your career. What's your career bucket list? Is there something you'd want to accomplish? Build some software? Work in an industry? Get a particular job, position, or work in a location? Maybe you'd like to become an advanced techie on some platform or using some technology. There might even be a goal you have to achieve some recognition for your skills. This is a tough question to spring on you in an editorial, but leave a comment if something comes to mind. If it does, maybe you want to jot some notes down that might help you move towards that goal. Even if nothing strikes you, perhaps you want to bookmark this piece and spend some time in the coming weeks thinking about your career. Goals are always good, and they can help drive us in a direction that may ultimately provide some meaning or satisfaction that is lacking. 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 ( 4.2MB) 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 | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | Free whitepaper: Solving the database deployment problem with Database DevOps Learn how to extend DevOps practices to SQL Server databases, so you can spend less time managing deployment pain and more time adding value. Download the free whitepaper |
|
|
|
| | | | | Jason Selburg from SQLServerCentral.com SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory. More » |
| | Additional Articles from SimpleTalk SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding. More » |
| | Does your organization have a data governance program, or are you thinking of implementing one? Redgate want to hear from you, as they're collecting data that will later be published in a report on the topic. Complete their survey to receive a copy of the report, and to be entered into a prize draw for a $100 Amazon gift card. More » |
| | Steve Jones from SQLServerCentral Blogs I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to... More » |
| | Arun Sirpal from SQLServerCentral Blogs So the decision to move to the cloud has been made but there is a fear from people that once... More » |
|
|
| | | Today's Question (by Thomas Franz): How many and which line IDs (dummy column) does the following procedure call return? IF OBJECT_ID('dbo.p_test_temptables', 'P') IS NOT NULL DROP PROCEDURE dbo.p_test_temptables GO CREATE PROCEDURE dbo.p_test_temptables AS BEGIN DECLARE @sql NVARCHAR(100); IF OBJECT_ID('tempdb.dbo.##tmp') IS NOT NULL DROP TABLE ##tmp IF OBJECT_ID('tempdb.dbo.##tmp1') IS NOT NULL DROP TABLE ##tmp1 IF OBJECT_ID('tempdb.dbo.##tmp2') IS NOT NULL DROP TABLE ##tmp2 CREATE TABLE #tmp (dummy INT, txt VARCHAR(150)); CREATE TABLE ##tmp (dummy INT, txt VARCHAR(150)); SET @sql = 'INSERT INTO #tmp SELECT 1 dummy, ''Insert into existing local #TempTable using EXEC'' txt;' EXEC (@sql) SET @sql = 'INSERT INTO #tmp SELECT 2 dummy, ''Insert into existing local #TempTable using sp_executesql'' txt;' EXEC sys.sp_executesql @sql SET @sql = 'INSERT INTO ##tmp SELECT 3 dummy, ''Insert into existing global ##TempTable using EXEC'' txt;' EXEC (@sql) SET @sql = 'INSERT INTO ##tmp SELECT 4 dummy, ''Insert into existing global ##TempTable using sp_executesql'' txt;' EXEC sys.sp_executesql @sql SET @sql = 'SELECT 5 dummy, ''Insert into new local #TempTable using EXEC'' txt INTO #tmp1;' EXEC (@sql) SET @sql = 'SELECT 6 dummy, ''Insert into new local #TempTable using sp_executesql'' txt INTO #tmp2;' EXEC sys.sp_executesql @sql SET @sql = 'SELECT 7 dummy, ''Insert into new global ##TempTable using EXEC'' txt INTO ##tmp1;' EXEC (@sql) SET @sql = 'SELECT 8 dummy, ''Insert into new global ##TempTable using sp_executesql'' txt INTO ##tmp2;' EXEC sys.sp_executesql @sql IF OBJECT_ID('tempdb.dbo.#tmp') IS NOT NULL SELECT * FROM #tmp AS t IF OBJECT_ID('tempdb.dbo.##tmp') IS NOT NULL SELECT * FROM ##tmp AS t IF OBJECT_ID('tempdb.dbo.#tmp1') IS NOT NULL SELECT * FROM #tmp1 AS t IF OBJECT_ID('tempdb.dbo.#tmp2') IS NOT NULL SELECT * FROM #tmp2 AS t IF OBJECT_ID('tempdb.dbo.##tmp1') IS NOT NULL SELECT * FROM ##tmp1 AS t IF OBJECT_ID('tempdb.dbo.##tmp2') IS NOT NULL SELECT * FROM ##tmp2 AS t IF OBJECT_ID('tempdb.dbo.#tmp') IS NOT NULL DROP TABLE #tmp IF OBJECT_ID('tempdb.dbo.##tmp') IS NOT NULL DROP TABLE ##tmp IF OBJECT_ID('tempdb.dbo.#tmp1') IS NOT NULL DROP TABLE ##tmp1 IF OBJECT_ID('tempdb.dbo.##tmp1') IS NOT NULL DROP TABLE ##tmp1 IF OBJECT_ID('tempdb.dbo.##tmp2') IS NOT NULL DROP TABLE ##tmp2 END GO EXEC dbo.p_test_temptables GO DROP PROCEDURE dbo.p_test_temptables |
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 2 points in this category: Dynamic SQL. 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 connect to my instance like this: sqlcmd -S .\SQL2016 I then enter "SELECT @@VERSION" at the prompt. I see this: How do I execute the statement?
Answer: Press Enter, type "go", and press Enter again Explanation: You must end a batch with a go on a new line for SQLCMD. Ref: Using SQLCMD - click here » Discuss this question and answer on the forums |
|
|
| | | | Emil Bialobrzeski from SQLServerCentral.com 1. Create procedure on every server that is using AlwaysOn 2. Schedule the procedure to run every X minutes (i.e. 10min) 3. Never again worry about CDC when failover happen 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. Strange transaction log activity - I'm suddenly seeing unusually large transaction log backups for a small database, and the application team swears that nothing has... Split String into Table or Record Set - Morning Guys, I have 3000 rows of address data in a single field called Address. The actual components of the address are... Using Dynamic Query in a Transact SQL Select - Hi Guys, I am trying to calculate formula using SQL Server 2016. How can I get the result of a Formula within... Restore production database to other environments - I have a question to DBAs for restoring database using SQL server native tools from production to test or development... Reindex maintenance plan error - Hello I have created a maintenance plan (hope this is the correct translation - I'm in France) for reindexing and executed it... Script or Ways to check if SSRS encryption key backed up - Hi Experts, Can anybody help me finding out how to check if the SSRS encryption key have been backup up... Using Try Catch With Stored Procedures - Hi Guys, I'm hoping someone would be willing to spot check me here. I'm attempting to add Try Catch Blocks to... Are These Two Code Fragments Equal? - Hi Guys, I'm kind of stumped here and could use another set of eyes. I've got two pieces of code that... Left outer join make duplicate column name - I used code below to select 10 temp tables as one row table. All 10 tables has the same column . How... SQL Server - It's not really a Mailer Service, is it? - I'm not entirely sure if I'm looking for an answer or an opinion here, sorry. The topic started off an... Append variable to query - Hi, declare @Value varchar (20) SELECT @Value = case when @Status = 'Y' then '' else 'top 500 ' end I need to append the above @Value... Optimize WHERE predicate - Hi All, Help required in re-writing below WHERE predicate so that an index on date column can be utilized. Currently a... Dynamic pivot and calculating total and ordering the total - Create Need to find a store procedure in a database - Hello Experts. Ive been trying to find the whole weekend a logic which is creating a xml file of this calculation: SQL 2008 - Extract parts of a string - Hello SQL Gurus, I need some help in extracting the data out of the string in certain way. So basically between each... The SELECT permission was denied on the object 'abc', database 'xyz', schema 'dbo' - Good morning Experts, An user is getting the below error: The SELECT permission was denied on the object 'abc', database 'xyz', schema... Activity Monitor Empty - I need help and I'm ready to pull my hair out. I'm running SQL Server 20008. Microsoft SQL Server Management Studio 10.0.4000.0 Microsoft... File System Task vs. DFT for flat file copy - I'm designing a new package where the very first step I need to copy a flat file from a share... Data flow concept - Thoughts wanted - Looking for thoughts on this. I have an application where we receive data from customers via text file. Unfortunately, we... Potential presentation idea: What a cookbook can teach us about programming - I was looking up information about ColdFusion (my still-relatively-new job uses CF, which I've never used), and in doing some... |
|
| 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] |
|
|
