| A community of more than 1,600,000 database professionals and growing |
| | We Want Maturity, But Is It Fun? Today we have a guest editorial from Andy Warren as Steve is away on vacation. This was originally published on Dec 23, 2014. I was reflecting recently on my first real IT job. It was a small-ish company when I joined it, perhaps a hundred employees or so, and still using a mishmash of software and a lot of dated hardware. We had one developer/sysadmin/DBA and a few people doing what we now call ETL and data cleansing. Not an elegant process, but one that absolutely was getting the job done. We had no change tickets, and the only development environment was on a developer's machine, with most changes deployed during the day. No QA team either. Interestingly all the code was in source control from the start. I guess in a lot of ways it was a startup, though I didn’t think much about it back then. Maybe it sounds chaotic, but it was challenging and fun. I learned a lot too. As the company grew so did IT, and with it came the earliest silos: splitting up development and ETL. Hardware was upgraded, we hired a network/systems guy, and I became the first DBA, trying to figure out how to be a DBA and how to reconcile what I read about security and change control with the demands of the business and the realities of how much of the work got done. We grew a little more and the walls between the silos got higher. We started to add process because what works with one developer doesn’t work as well when you have ten. We needed a help desk to manage the calls and a task tracking system so we could manage the work. It took longer to make changes because the system was more complex and that meant it took more time for new hires to figure out how it all worked. We started moving away from the hero model and arguably away from cowboy coding, but it was still an environment that most of us today would consider lightly structured. Even back then then it felt like our velocity was slowing as we added process. Since then I’ve worked in far worse/less mature environments, worked with teams where even small changes took 90 days to work through the process, and a lot that fell in between those. I tried to find something to like and to learn about all of them. I get process and change control. I’ve learned to bridge silos and work the system, to appreciate being methodical and patient, but I’ve never seen it as fun in the way it was when I was on a team of three tasked with rolling out a new product in ninety days. Nothing about process and change control should eliminate fun, but it seems like it does? Why is that? Is work only fun if there is risk? Or no rules? Or is the nature of things that as a company matures there is less fun to be had because it’s all been done or it’s too risky to try? What makes a job fun anyway? Many jobs are satisfying because they pay well, or because they offer decent problems to conquer, but are they fun? I’m curious to hear from you. What IT job was the most fun and why? And looking back with the benefit of experience, would you go back to a similar environment today if you have the chance? Andy Warren from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| |
| | | David Poole from SQLServerCentral.com If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand? More » |
| With the v7 release, SQL Source Control now enforces Git hooks, and provides full support for working with Git repositories hosted on Azure DevOps. It also comes with pre- and post-deployment scripts to make it easier to automate the build and deploy new database versions to your pre-production or production servers. Finally, the latest release continues SQL Source Control’s long-standing commitment to keep pace with SSMS improvements, with support for the public preview of SSMS 18. More » |
| Additional Articles from SimpleTalk In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it. More » |
| ChrisJenkins from SQLServerCentral Blogs In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And... More » |
| Kenneth Fisher from SQLServerCentral Blogs Indexes are probably the number one tool we have to improve performance. That said, there are times when we want... More » |
|
|
| | Today's Question (by Steve Jones): In SQL Server 2017, what is the most number of parameters we can use in a stored procedure? |
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: Stored Procedures. 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 the Buffer Pool Extension enabled and set on my instance. Currently I have a 58GB setting for max server memory and a 100GB file set for BPE. I want to increase this to 200. Which of these statements do I run? ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION OFF ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'F:\memory.BPE', SIZE = 200GB) ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION (FILENAME = 'F:\memory.BPE', SIZE = 200GB) ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON Restart the instance Answer: 1, then 2 Explanation: To alter the size of the buffer pool extension, the option must be disabled. The size can then be increased and the option turned on. No restart is required for increasing the size. Ref: ALTER SERVER CONFIGURATION - 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. Best tool to migrate data from Oracle to SQL and Management tools - 1)Tool to migrate data from Oracle to SQL like full data , incremental data and also It need to handle PK,FK... Remote connect to a linux SQL instance - I installed my first instance of SQL server on Linux to experiment it. The Linux is installed using Virtualbox on my... SQL Server Snapshot Replication error 22018 - I am trying to get snapshot replication between two MSSQL servers to work but am receiving errors. Any help will... How to connect to git in SQL Server 2016/2017 without using any third party tool - I was curious to know if we can connect to Git in SQL Server Management Studio without using any third... Database Corruption - Got the below error on our database on day 1 Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3851,... bcp Invalid character value for cast specification - Hello SQLServerCentral colleagues, I'm getting the error: Invalid character value for cast specification trying to bcp in a large file to... TOP Clause performance is slow - I have 2 tables combined with union all operator in procedure.First table contains 20 million records and second table contain... Page setup for reporting - setting header and footer page margins - Hi, Not sure if this is the correct place to post so apologies if not (please let me know which sub... Importing an XML file into a sql table - Edit to make things more understandable, I wish to import my XML file into an sql table. The XML has a... The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|