| A community of more than 1,600,000 database professionals and growing |
| | | What's your approach ? Today we have a guest editorial as Steve is on vacation. Recently, I came across one of Richard Branson’s quotes on work commitments. “If somebody offers you an amazing opportunity but you are not sure you can do it, say yes – then learn how to do it later!” This reminded me of a few project managers, who did commit to certain deliverables to the stake holders, without discussing with the technical team (clearly they didn’t know what was possible and how much time it would take). Results, most of them fell flat on their faces, with some losing their positions in the organisations. However, there were a couple, who were able to deliver within the time and budget constraints. Though they faced a lot of stressful situations, they managed to gear up the teams to see their vision and deliver it. Then, on the other hand, I have worked with very cautious Project Managers, analyst by nature, who took facts in consideration, before committing to a deliverable and deadline. No doubt, they succeeded most of the times, but they always took longer to commit; and were not very much liked by the stake holders. So broadly speaking, there are 2 types of approaches: CUD - Commit, Understand and Deliver UCD - Understand, Commit and Deliver Of course, there is a third approach - paralysis of analysis, but let’s ignore it for now. Personally, I feel my approach is UCD. I cannot justify committing to something, which I am not sure how I would deliver. Committing before understanding, to me, seems like lying. However, after reading about Richard Branson’s quote; and all his achievements, it made me wonder, if my approach (or attitude) was actually restricting my overall successes. Shouldn’t the life be about taking higher risks for higher gains? Or is honesty still the best policy, when it comes to such commitments ? Where do you stand? What’s your approach to work commitments? Nitin Bhojwani from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | 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 |
| | | | Using SQL Census to audit SQL Server permissions Redgate have just released SQL Census, a prototype tool that makes auditing SQL Server user access permissions much easier. In this post, Ally Parker shows how it works, tells us what's up next in the tool's development, and explains how you can download it for free. Try the free prototype |
|
|
|
| | | | | Jovan Popovic from SQLServerCentral.com Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you. More » |
| | Additional Articles from SimpleTalk In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database. More » |
| | It’s fairly widely known that just because you delete data from a database, it doesn’t mean it’s gone from the data file itself, but the question is, how should you go about removing it? More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Power KPI Custom Visual. The Power KPI displays your KPI... More » |
| | Brian Kelley from SQLServerCentral Blogs File this under “soft skills.” Let me start with a recent experience. Last week I was leading a team of youth... More » |
|
|
| | | Today's Question (by Steve Jones): I want to run a series of queries from SQLCMD and capture performance statistics from the batch. What parameter 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: SQLCMD. 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): What does the result of @@TIMETICKS mean?
Answer: The number of microseconds per tick Explanation: This returns the number of microseconds per tick on the current hardware. A tick is 31.25 millieseconds. Ref: @@TIMETICKS - 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. Design Distributed Availability group - In my existing environment there is a design of distributed AG is proposed, can you please help to let me... Full backup size is very high - Hi, Database size is 65.4 gb (including mdf, log file and file stream directory) Full backup size is 341 GB. How to reduce... Delete a wrong push subscription. - Hello, Recently after a server migration can see that some of the wrong / unwanted subscription still shows up in the repl... One of my Passed Exam of MCSA shows in MCSE, Why? - Hello, I passed MCSA today. When I see the requirement for MCSE, among the list, it shows an exam (70-762) to get... Can't open RSReportServer config file - Invalid license data. Reinstall is required - Server : SQL server 2014 Standard edition I wanted to open RSReportServer config file as I need to addthe new path of... Query optimization help - Hi Experts, One of the query is taking long time to execute. Its taking more than 6 mins. Can anyone provide... Get LastOrderDate from each Table - Hi, i want to write the max(Orderdate) from all Tables in DB into a #TempTable. How can i realise this in a... Handling DBNull When Inserting or Updating Using Stored Query - Hi Guys, I have a question and I'm hoping someone can help me sort out a clean and effective way of... Getting rid of duplicate records - Hi All, I have a table that stores schedule events. One event can be scheduled more than one time in one... db_executor role - I have three databases: trading, ref, rts. I created a new role and added a member to that role by... Checking server settings - Hi guys Just after someone checking a few server settings for me to see if I've done anything dim (it's entirely... Load multi tab Excel data into SQL Server table using SSIS - I have a requirement that I need to load an Excel file with multiple tabs into the SQL Server table. The... Foreign Key Heirarchy - Okay, first, I haven't written any real code just test code as I am having a problem just trying to... How to execute dynamic sql statement - ALTER PROCEDURE dbo.Employee ( @IdList NVARCHAR(3500) ) DECLARE @SqlStatement NVARCHAR(4000) = N' INSERT INTO #Employee ( EmployeeId ) SELECT EmployeeId FROM &nbs Rolling back after Committing - Hi All, Is there a way to recover previous values after committing an update on a table , apart from recovery from... Difference between shrinking a database and shrinking individual files separately - Hi All, I've planned to free up some space in our database by dropping some tables that are no more required . Weighing between... BCP upload from a txt file - Hi Guys, I an trying to do a simple upload from a txt file to a table. I know it should... Where is best place to start? - I'm looking at upgrading the ETL servers to SQL 2016, upgrading the development environment to VS 2015, and migrating to... Using parameters in Execute SQL Task - Hmmm...how to best summarize this... I'm writing an SSDT package that: 1) Clones the table schema of a source table query to... Calculated Query Help - Hi, I am struggling to grasp on how to calculate in SQL where there is a fixed Qty in stock and... |
|
| 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] |
|
|
