SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

New IT Departments

I had a friend that used to run an Exchange system. Actually, he was part of a team of four that managed a 50,000+ mailbox system for a very large company. In 2000 or 2001, he told me that his job would be done by computers in a few years and he had decided to leave the industry. Over the last 15 years, he's worked in another field.

I have no idea if those Exchange systems are still around, and I would concede that mail is better purchased as a service for most organizations than managed in-house. However, I think my friend made a mistake. There are still plenty of people working in technology infrastructure in companies, making a good salary in good working conditions. I've spent my career in IT in one way or another, either as a developer, Operations staff, or manager. I see no sign of this going away quickly, though certainly many menial, simple tasks like checking logs and backups are being increasingly handled by automated systems.

When I see articles like this one (Why IT as you know it is dead), I'm not sure what to think. One one hand, I do think IT is changing, especially in larger organizations, where there is pressure to reduce costs (often labor) as well as increase the speed of output. DevOps is one way that we try to improve our systems, though the cultural change is very hard. Often this means that developers produce work in smaller chunks, and may release more often, but don't get more work done. This is because the cultural change is hard, and most of us don't want to change our habits.

On the other hand, I also think that in many ways IT is the same. We can't respond as quickly as business analysts or customers come up with ideas. I know most of those ideas probably aren't great, and IT doesn't want to waste resources on something that will not prove to be valuable. Just as happened 30 years ago, departments will create their own POC applications. This used to happen in Lotus 1-2-3, then Access and Excel, now it may happen with low-code development tools, whatever those are.

I don't really worry about this, as I'll find ways to make things better. If someone wants an Access or Power BI application, let them build it. If it's really useful, and others need access, we can upgrade and invest in a better system. I'll go along and get along, working to build the things that the organization finds useful. I just realize that my time is limited, and if someone else can prove a concept is valid, perhaps that means I should spend time ensuring that works or gets rebuilt in a better way. I also know many of those ideas and concepts won't prove themselves, so it's fine if there's some sort of citizen development (or shadow IT) in an organization.

To me, the key is that we enforce security for our data. If anyone wants to build software, that's fine. They just need to ensure that they use the same security and authentication mechanisms that other systems use. We need to protect the data, no matter what application is going to be used to view, analyze, or manipulate it.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.0MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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
SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

Featured Contents

 

Cancelling DBCC SHRINKFILE with EMPTYFILE

Steve Jones from SQLServerCentral.com

A fun experiment using DBCC SHRINKFILE to rebalance data. More »


 

How to Programmatically Identify When Your SQL Server Was Last Started

Additional Articles from Database Journal

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started. More »


 

Spring into the Latest Features at the Luxemborg User Group

Additional Articles from SQLServerCentral.com

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned. More »


 

Custom Metrics for Detecting Problems with Ad-hoc Queries

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this. More »


 

From the SQLServerCentral Blogs - Webinar: 6 Principles of the GDPR and SQL Provision

Steve Jones from SQLServerCentral Blogs

On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance... More »


 

From the SQLServerCentral Blogs - I’ve gotten a transaction log full error but when I look it’s not full??

Kenneth Fisher from SQLServerCentral Blogs

Every now and again I’ll get an error telling me a transaction log is full. This can be for any... More »

Question of the Day

Today's Question (by Steve Jones):

I decide I want to setup an Extended Events session. I create a session with one event and one target with this code:

 CREATE EVENT SESSION [BareBones] ON SERVER ADD EVENT sqlserver.error_reported( ACTION(sqlserver.client_hostname)) WITH (STARTUP_STATE=OFF) GO 

I then decide to run this code:

 ALTER EVENT SESSION BareBones ON SERVER DROP EVENT sqlserver.error_reported GO 

What happens?

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: Extended Events (XE).

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 Junior Galvão - MVP):

The suspect_pages table is used for maintaining information about suspect pages, and is relevant in helping to decide whether a restore is necessary. The suspect_pages table resides which system database?

Answer: MSDB

Explanation:

Answer: The suspect_pages table resides in the msdb database.

References: 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.

SQL Server 2017 : SQL Server 2017 - Administration

Server role and user mapping lost when apply Dacpac - Hi, Database Server role and User Mapping is lost when applied Dacpac in database. How to solve this issue. Attache screen shoot for...

Transactional Replication to Multiple Subscribers - Hi all: I'm attempting to set up replication from a SQL 2017 Instance to multiple subscribers.  One is another SQL 2017...


SQL Server 2017 : SQL Server 2017 - Development

Select All Records Where Date Falls Within Next Week - Id like to run query that would display records where the Build Day occurs next week. So if I run...

Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to...


SQL Server 2014 : Administration - SQL Server 2014

SQLCMD Error ODBC Driver 11 - SQL Server 2014 Enterprise Cluster Windows 2012 R2 Servers On the Node1 SQL Cluster server I am running SQLCMD scripts to...

SQL 2014 Cluster Setup on VMware - VMware ESXi 6.5 Windows 2012 R2 Cluster Servers SQL 2014 Enterprise My Windows Server Clusters validation ran with just two warnings...


SQL Server 2012 : SQL 2012 - General

Transaction Replication & AlwaysOn - We have a request to configure transnational replication on AlwaysOn Availability Group with 3-4 replica nodes of different SQL servers.Have...


SQL Server 2012 : SQL Server 2012 - T-SQL

decrementing order quantity if needed - Hello, I am back, want to say thank you again John M. for the assistance, with that logic i was able...

decrements Quantity for each part - Hello, i may be over thinking this, but i have a situation where we have a requirement for a part, example...


SQL Server 2008 : SQL Server Newbies

user typed "begin transaction" and went home - Good Morning Experts, A user typed "begin transaction" and went home. Will this have any affect on the log file(.ldf file)....


Reporting Services : Reporting Services

Double Hop issue from a non domain computer - We just offloaded SSRS onto its own machine.  Ran into the typical Double hop issues.  I verified the SPNs and...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com