 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| Editorial: An example of how networking netted a new job Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network with other people. I would guess many of you might be more introverted like I am and networking isn’t something you enjoy or are great at. I wanted to share an experience I recently had where reaching out to my network brought me to my new job. It is important to realize your network isn’t just your professional connections, but also your friends and family too. In the middle of April this year I found myself in need of finding a new job. I started by updating my resume (CV for all you non U.S. people). I updated my LinkedIn profile. I started to apply for jobs I found on the different job sites (dice.com, indeed.com, etc.) Recruiters started to contact me. I emailed a number of people (friends, family, etc.). This was NOT a mass mail email, but an individualized email, asking how they were doing and letting them know I was looking for a new job. Time went on, and a week went by. I continued to apply for jobs and talk to recruiters. I did some phone interviews. Then a friend of mine, who I had sent an email to, responded that he had a buddy, that was a recruiter, named Jim. This didn’t seem like a good fit since Jim the recruiter worked for a contracting company. I did contracting for a number of years a while back ,and I was not in a hurry to go back into it. I was looking for a full time permanent position. Still, I decided to talk with Jim. Well, it was quite the interesting conversation. We had both gone to the same University and graduated the same year. We studied different subjects, so we didn’t have any classes together. Still it was a good conversation, but I didn’t expect it to lead to anything. Jim decided to pass me on to his coworker, Heidi. Well, Heidi just happened to be in the position of trying to find someone to fill a full time permanent job that had just come across her desk. This only happens once or twice a year for her. As she looked at my experience she realized I was a perfect fit. She contacted me, and we met for coffee. We both came to the realization that I was a really good fit for the position. I was able to do 5 interviews over the next week or so, which ended with a job offer that I accepted. I have been at this new job for a few months now and I still love it. It really is a great fit for me. Still, I wonder how easy it would have been to not reach out to more than my professional network. To not let people know I was looking for a new job. To decide I was not interested in talking with a recruiter with a contract company. I could still be looking for my next job instead of enjoying this new one I now have. Share an experience where networking helped get you where you are today. Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT |  | SQL Toolbelt – everything you need to work with SQL Server Redgate’s SQL Toolbelt contains the industry-standard tools you need to make you and your team more productive, to protect your data and manage performance, and to include your database in agile processes. Find out more and download your free trial. |
|  | Join SQL Clone early access program Redgate’s building a new tool to enable rapid SQL Server provisioning, while safeguarding your data and making efficient use of disk space. SQL Clone takes the pain out of creating and managing multiple copies of production databases, helping you and your team deliver new features and upgrades fast. Join the early access program to try the latest release. Join now. |
|  | Want a SQL comparison tool you can trust? 71% of Fortune 100 companies use SQL Compare. They save time comparing and deploying SQL Server database schemas, create error-free deployment scripts in minutes, and fix errors caused by database differences with ease. Find out how with a free trial. |
|
|
|
| |
 | Aaron Nelson from SQLServerCentral.com A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see. More » |
 | Additional Articles from Database Journal David Fitzjarrell takes a look at why the mutating table error is thrown, why it's not going to create data problems, and how to possibly fix it. More » |
 | Tim Mitchell from SQLServerCentral Blogs I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t... More » |
 | Steve Jones from SQLServerCentral Blogs I’ve been working with ReadyRoll quite a bit the last few months, and wanted to start putting out some information.... More » |
|
|
| | Today's Question (by Steve Jones): If I have an In-Memory OLTP table that uses delayed durability to improve throughput on writes. However, periodically I want to ensure that all transaction log records are written to disk. What command should I use? |
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: Delayed Durability. 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): I have a query I want to execute that looks like this: INSERT EventLogger VALUES (@m, @d, @u) However, I want to run this with sp_executesql and decide to do this: DECLARE @cmd NVARCHAR(MAX) DECLARE @p NVARCHAR(500); DECLARE @msg VARCHAR(200) = 'A problem' DECLARE @dt DATETIME = GETDATE() DECLARE @user VARCHAR(10) = 'Steve' SELECT @cmd = N'INSERT EventLogger VALUES (@m, @d, @u)' -- select @p = -- exec sp_executesql xxx Now, how should my parameter list, @p, be declared? Assume the values for @m, @d, @u will be taken from local variables and their sizes are correct. Answer: SELECT @p = N'@m varchar(200), @d datetime, @u varchar(10)' Explanation: The parameter list for sp_executeSql is a single list of the parameter names from the query and their datatypes, as they'd be declared in a DECLARE statement. So, this is the correct statement: SELECT @p = N'@m varchar(200), @d datetime, @u varchar(10)' The value of each parameter is then passed in separately. Ref: sp_executesql - https://msdn.microsoft.com/en-us/library/ms188001.aspx
» Discuss this question and answer on the forums |
|
|
| | Sheraz Mirza from SQLServerCentral.com This Procedure will be created in MASTER Database and could be used to see all Candidate Keys of a Specified Table in a Specified DB. Procedure will take 2 Parameters db_name and table_name to display candidate keys of that table . Command To Run Procedure exec getPrimaryKeys @db_name = 'PROD_DB' , @table_name = 'Sample_Table' 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 Agent missing in SSMS - When I log into an account with Sysadmin role I can see SQL Agent. I set up a user to have... P2V Migration from sql2012 to 2014 - Users complaining about access issues. - Hello everyone, A couple of days ago I was tasked to do a P2V migration from let's say A to B...everything... Reports Migration - We are using the sql serveSqr 2008r2. We have SSRS reports. We are migrating to Sql 2014. But the database... sqlcmd' is not recognized as an internal or external command - Am trying to run the below batch but I always get sqlcmd' is not recognized as an internal or external... Query - HI Everyone, can any one write one dynamic query based on fromdate and Todate columns data should come as mentioned below... Deadlocks with Object Locks - NO objectids - Getting deadlocks between 2 or more SPIds. It gives you the spids, but does not specify what resource is involved.... SP with 3 parameters as delimited list - Goal 500 milliseconds - We have performance issue and Java guys asked me if it;s possible to make this procedure very fast.... So far , I can... Splitting a delimited field - Hi all I'm trying to use Jeff's Delimited8K function to split a string into several rows. The string is in this format:- Drug1|Drug2|Drug3........ Return XML from SQL Server with particular format - Hi All, I'm trying to build XSL FO for PDF creation using FOP.NET. For that i need to generate XML in... Deadlock on simple query - I've been getting deadlocks in a simple query like: Select {data} From DataTable DT Inner Join SetTable ST on ST.SetTableID = DT.SetTableID Where {filter in part... Performance Check - Hi, How to check the performance on the SQL Server for which we recently moved the sql server database to new... rows to columns - Hi Friends, I am trying pivot the rows but I am struggling to get the query. Here is the sample... Concatenate strings - In my sample code, at the end i want @database to be A,B,C. I am not able to concatenate them. [code="sql"] DECLARE... Error: 17827, Severity: 20, State: 1. - We are running SQL 2008 SP1 on Windows Server 2003 sp2 Enterprise Edition, all 32 bit. We are getting this... Need algorithm for Complex looping logic - Dear All, Hope all are good. I am Sql developer but i was in support ,now in developement, i am... SQL Calendar Table based on Start and End Date Help - Hello Everyone, I need some help in setting up a Calendar Table or an Staging Table that I can use for... UNION with CASE statement - Hi Experts, I am getting error in running this query, It has to do with data type conflict. But I am... Dates in Fact or Dimention - Hi Should my dates be in my fact tables or dimension tables? I have information about an application base on dates -... date Hierarchy (simple hopefully) - Hi I'm new to SSAS. I have a dimension table with multiple date fields and I would like to add a hierarchy... How to propagate relationships for calculated members in SSAS? - I am stuck in a situation which I believe should have a ready solution because it looks like a common... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|