 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Work/Training Balance - The hidden balancing act Today we have a guest editorial as Steve is out of the office. Many discussions occur about work/life balance. It appears that most people are striving to achieve a good balance or, at least, are aware of it. I believe that this is exceptionally important and am critical of myself for doing so badly at it. I am improving but too slowly. We can further break down the work aspect. What I am considering today is whether we, as a collective, are achieving a proper work/training balance. By this I am considering the work aspect of the classical work/life balance and asking how many of us put in enough time to maintain our own skill set at a high enough level required to perform our work duties. Some companies help out here by providing on the job training, some individuals help themselves by putting in effort in their own time, some people benefit from both and there are even those that apply neither. Of course, doing neither may be a valid option. For example, if you are working on a technology that is not changing in your environment, your job appears safe and you are retiring soon, then you may feel that there no longer is any benefit to develop your work skills. Or maybe you are about to change careers. I suspect for the majority of us we still need to maintain some work/training balance. Without the assistance of employers, either directly by supplying formal training or indirectly by allocating time, we may struggle to find this balance inside of an appropriate work/life balance. Gary Varga from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. ... |
|  | | DLM Demo Webinar Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now. |
|  | | SQL in the City Streamed Register now for Redgate's free virtual event offering a wealth of SQL Server sessions for you to livestream on December 14 and 15. Find out more and register. |
|
|
|
| | |
 | Additional Articles from SimpleTalk Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing it, more complete than JSON, but easier to read than XML. To try to convince you, he gives a set of flying demos, using PowerShell and his PSYaml module, to illustrate how YAML can let you work faster, and more accurately. More » |
 | Kenneth Fisher from SQLServerCentral Blogs If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC... More » |
| | kleegeek from SQLServerCentral Blogs VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,... More » |
|
|
| | | Today's Question (by Steve Jones): If I want to check the list of possible PowerShell Modules on my system, what should 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: PowerShell. 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 | | Power Query for Power BI and Excel Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | Nicholas Williams from SQLServerCentral.com Greetings, This piece of code will allow you to add a stored procedure name as a parameter, and will then take the output results of the procedure and email it to an address of your choosing, automatically formatting the results into an HTML table embedded in the email for clear and easy reading, or alternatively as an attachment. Regretfully, there are a few limitations which I will eventually get around to fixing when I am interested in this again, namely: - Uses a static 100 length on the output columns instead of dynamically applying a length by referencing the source data
- Cannot use procedures that have a blank column aliased ie.SELECT ' ' as Store FROM table.
- Requires Ad Hoc Distributed Queries server setting to be enabled.
- Change cursors into tally or alternate loop
- Customization of colours, table length, font etc.
It is executed as follows: EXEC DBAdmin.[dbo].[dba_EmailProcResults] @vcProcName='sp_lock' ,@vcDatabaseName='master' , @vcRecipients='<UrEmailHere>' , @vcDynamicSubject = 'Log Backup Check' I hope you have fun using this, and feel free to contact me with questions, suggestions or critique's. Regards, Nick 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.
An incomprehensible portion of the hair thickening - A diminishing in shuddering Healthier skin All these customary things will bolster [url=http://www.7supplements.org/beard-czar/]beard czar[/url] your body to wind up more... possible combinations for all rows in table - I have a table having three column Name Value1 Value2 Value3 A 1 2 3 B 4 5 1 C 2 3 1 I want...
Kitchen Units Manchester - Kitchen Units Manchester Go to kitchenssimply*co*uk Out of nowhere I was offered a 30% discount - Out of nowhere I was offered a 30% discount, I gave I was not content with that. Out of the... RAMDisk? Use it for TempDB? - RAMDisk used to exist in Windows NT. I used it and it worked really well. Then, it was eliminated in... Investigate SQL server Shutdown caused by tempdb maxing out. - SQL server got shutdown caused by tempdb maxing out, how can I trace what\who was running at the moment ? Any...
The final death toll remained - [url=https://twitter.com/i/moments/805424812608716800]Ravens vs Dolphins Live Stream[/url] Al Alburquerque - [url=https://twitter.com/i/moments/805420631948828672]Patriots vs Rams Live Stream[/url]
Identify Start Date / End Date in a date column - Hi Experts, I need your help. I use sql server 2012. I have a table like this: requestid eventdate eventname 46444 2016/08/08 10:20:33.000 OPENED 46444 2016/08/08 10:33:10.000 REVIEWED 46444 2016/08/08 11:09:55.000 OPENED 46444 2016/08/08 11:32:41.000 REVIEWED 46444 2016/08/08... SP_EXECUTESQL query problem - We migrated an application several weeks ago and all appears to be running ok, apart from a couple of queries...
Reince Priebus: "It's possible" millions - [url=http://www.211sandiego.org/sites/default/files/webform/SoNaTa-Tv-Bills-vs-Raiders-Live-Streaming-NFL.-AM..-Football..-NFL.pdf]Bills vs Raiders Live Streaming[/url] Fulltext index top 10000 hits - Hi there, Is there a way of setting the Full text index to get the top 10,000 hits only? I have...
Passing temp table from one stored procedure to another - Hi, I have stored procedure with creates a temp table and stores data.Another procedure is called inside the main procedure, which...
Schema name, Schema Owner and Login - Hi guys, I have two logins abc_prod and abc_dev in my prod environment. All our objects are created with schema...
Eagles expected to pursue DeSean - [url=http://www.jneurosci.org/sites/default/files/SmArt-tv-Seahawks-vs-Panthers-lIvE-Stream-NFL-Gorom.pdf]Seahawks vs Panthers Live Streaming[/url]
Error trying to connect to a remote mssql database - Hi, First time here. I'm the admin of a small business with a mssql database that is remotely hosted by...
Sending csv file using sql server 2014 based on condition - I want to send a csv file using SQL Server only when it has more than 1 record present in...
Locking SQL Server Logins - All, I know that I can use sp_denylogin and sp_revokelogin for Windows NT or 2000 users and groups. How can I...
Alternatives to Microsoft Certifications - Is there any good alternatives to Microsoft's certification route? I found the process of dealing with Microsoft's website traumatic at best.... Microsoft Certified Solutions Expert: Data Management and Analytics - I got an email from Microsoft which said "Congratulations on achieving your Microsoft Certified Solutions Expert: Data Management and Analytics... |
|
| 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 |
|
|
