 | A community of more than 1,600,000 database professionals and growing |
| | | The Second Best Job I think I have one of the best jobs in the world. I get to run SQLServerCentral, focusing on the Microsoft Data Platform, writing articles, experimenting with technology, speaking at events, and more, all with a bit of autonomy. I've been doing this job for well over a decade, and I've built routines and rhythms that have allowed me to balance work, family, and life. I really enjoy my job with Redgate. Redgate also runs Simple Talk, a companion site that seeks to educate and inform the community, just like SQLServerCentral. Simple Talk runs somewhat longer pieces and has fewer newsletters, but it's a part of Redgate's effort to give back to the community and help our current and future customers get better at their jobs. And now, we're hiring a new editor for Simple Talk, which means the second best job in the company has an opening. This isn't necessarily the easiest job, and it does take a certain kind of person. I've told many people for years that almost anyone versed in SQL Server could do my job for a few days, but few could do it for a month. Or maybe, few would want to do it for a month. Producing new content on a regular basis, handling some of the tedious duties of an editor, these can be difficult tasks for many people over time. Even managing yourself (we need an independent self-starter) can be a challenge. We have a great team in marketing, and Redgate is a fantastic company. The highest praise I can give them is that they have been the kind of company I'd want to build if I were to start a new venture. There are great benefits, you can work from home and work with autonomy. Plus, you get to work with me. We need good technical skills, strong communication skills, and someone that wants to help grow the site even further. If you think this might be your kind of job, think about applying. Who knows, maybe the second best job could be yours. 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.7MB) 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 |  | | Write, format, and refactor SQL effortlessly with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
|  | | 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 |
|
|
|
| | |
 | Additional Articles from MSSQLTips.com Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server. More » |
 | SQL Monitor’s dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare hosts, significant improvements to performance and scalability, improved configurability of alerts, as well as dozens of smaller enhancements. Since we’re about half way through 2017, it’s time to talk about the plans for the rest of the year. More » |
 | Kenneth Fisher from SQLServerCentral Blogs Every now and again you need to know how big a table is. Or several tables. Or all of the... More » |
| | Wayne Sheffield from SQLServerCentral Blogs In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need... More » |
|
|
| | | Today's Question (by Steve Jones): What does @@IO_BUSY return? |
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: Administration. 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this R code > values <- -10:10 > absolutes <- abs(values) I want to plot a graph that looks like a greater than symbol (>). Which plot does this?
Answer: plot(-absolutes, values) Explanation: In this case, the PLOT() function will take two vectors and produce a graph. The first vector is the X axis and the second is the Y. If we use the negative of the absolutes, we get the two values of 10 and -10 first, with the X axis increasing to 0. The plot looks like:  Ref: PLOT() - 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 deploy 10 T-SQL scripts across 200 databases - Hi , Can any one suggest an efficient way where we can apply about 10 T-SQL scripts on about 200 databases... SQL Server geo-cluster 2016 - Dear Everyone Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes) SQL 2016 SP1 CU2 - sudden and unexplained shutdowns - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in...
Need help in SQL table for updating NULLS - 70-461 exam - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material... Cursor Performance - OK so we have an application that has gone through an upgrade which also saw the database move from a...
Should I Re-design table? - This table has high transactions with select, insert, update, delete and It index got fragmentation about 90% after rebuild 3-4... Read Access to Database Tables - How do you do it in MS-SQL ? - Hi all, I need to control access to the developers&business users whom (by business rules) are allow to look into certain...
How to find row(s) with the same value in a recordset - Hi, I got this query, that gives me all the products(optionid) that are ready to be shipped: SELECT T_Order_Detail.OrderID, T_Order_Detail.OptionID, T_Order_Detail.Quantity FROM...
Error: 18056, Severity: 20, State: 23 - Hi.. Error: 18056, Severity: 20, State: 23. Message The client was unable to reuse a session with SPID 148, which had been reset... List of all dtsx files used in - I need help with the SELECT statement - How may I write a SELECT statement that will list each SSIS Package and the dtsx files that go with...
Update NULL values - SQL Help - Hello Everyone, Need some help in updating one column, I come up with some sample data. Create Table #ACC (Flag Varchar(1), Period...
AlwaysOn : Unable to resume data movement - Hello Few of the databases are showing as 'Not synchronizing' in AlwaysOn dashboard Error logs : AlwaysOn Availability Groups connection with secondary database... How does a integer/any data record store in SQL Server page - Hello Experts, I have seen the 8KB (8192 = 96 Header + 36 Row Offset + 8060 Free space) page architecture in SQL Server....
Are these both same? Begin Tran & Begin Try - My goal here is i delete only data that is inserted, if i only inserted and not able to delete... Expensive View help - Hi Guys I have the below query which is part of a view. This query takes > 5 minutes to complete....
CHARINDEX doesn't find double spaces - Hi all I have a very strange situation where I have a table containing data that definitely has records having double...
Help me hate PowerShell a little less, please. - I found an interesting and useful PoSh script at the following URL: http://woshub.com/get-adcomputer-getting-active-directory-computers-info-via-powershell/ Here's the script that I got directly from that...
No Columns Listed in OLE DB Source Editor Window - Hello, I am trying to set up an integration services package to export the results of a query to a .csv...
"syspolicy_purge_history" "PowerShell subsystem failed to load" - Anyone seen this error logged on a SQL 2008 Cluster? "syspolicy_purge_history" "PowerShell subsystem failed to load" Message
The job failed. The Job was... |
|
| 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 |
|
|
