Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Send someone a gift, big or small

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

New IT Departments

This editorial was originally published on 23 Apr 2018. It is being republished as Steve is on vacation.

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 - SSC Editor

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

 
 Featured Contents

Sending streaming data from Azure IoT Central to Azure SQL Database

Sucharita Das from SQLServerCentral

Introduction In my last article, Working with Azure IoT Central at SQLServerCentral, I gave an overview of Azure IoT Central. I had connected my mobile phone as a device to Azure IoT Central and collected the telemetry data. In this article, I will export the telemetry data continuously from Azure IoT Central to Azure SQL […]

Getting Started with Flyway Migrations on PostgreSQL

Additional Articles from Redgate

Phil Factor brings us yet another lesson in Flyway and database migrations. Learn how to use PowerShell with Flyway to run SQL migration scripts that will build, fill and modify a PostgreSQL database.

Issues with SQL Server Permissions to Restore a Database

Additional Articles from MSSQLTips.com

In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.

From the SQL Server Central Blogs - Using Subflows in Power Automate Desktop

Devin Knight from Devin Knight

In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to leverage Subflows to better organize your

From the SQL Server Central Blogs - Ignoring System Generated Key Names in SQL Compare

Steve Jones - SSC Editor from The Voice of the DBA

Recently I ran into a customer that was having issues deploying code from their development system to their production system. The issue was that they often found that the...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Starting FTS Population

I have created a Full-text Search index, but used manual population. How can I start the population of the index?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Engine Edition

What does this return?

SELECT SERVERPROPERTY('EngineEdition')

Answer: An integer that maps to Personal, Standard, Enterprise, Express, or a cloud version of the database

Explanation: This returns an integer that is one of the following (as of Aug 2021):

  • 1 = Personal or Desktop Engine (Not available in SQL Server 2005 (9.x) and later versions.)
  • 2 = Standard (This is returned for Standard, Web, and Business Intelligence.)
  • 3 = Enterprise (This is returned for Evaluation, Developer, and Enterprise editions.)
  • 4 = Express (This is returned for Express, Express with Tools, and Express with Advanced Services)
  • 5 = SQL Database
  • 6 = Microsoft Azure Synapse Analytics
  • 8 = Azure SQL Managed Instance
  • 9 = Azure SQL Edge (This is returned for all editions of Azure SQL Edge)
  • 11 = Azure Synapse serverless SQL pool

Ref: ServerProperty - https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver15

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 2016 - Administration
Suppress Backup Messages In Logs - I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress completed notifications by enabling trace flag 3266. However, I'm still dealing with "backup passed" and "backup skipped" entries which quickly clutters the log when performing log backups every 10 minutes on dozens of databases. The […]
SQL Server 2016 - Development and T-SQL
Gap in dates query - Hello All, I need your help in building this query. create table #memb (ID int, eff_dt date, term_dt date, prod varchar(5)); insert into #memb select 1111 , '01/01/2016' , '12/31/2016', 'AAA' union all select 1111, '01/01/2017', '12/31/2017', 'AAA' union all select 1111, '01/01/2018', '03/31/2021',  'AAA' union all select 1112, '01/01/2017', '12/31/2017', 'AAA' union all select […]
Development - SQL Server 2014
Incorrect Syntax near End - Hi if Month(@frDate) < 4 begin SET @ytdfrDate = (SELECT CONVERT(DATE, dateadd(y,-1,@frdate + '-04-01')) end Thanks
YTD Date calculation - Hi I have @frdate parameter. In below condition i want to Set date as '01/04' and subtract 1 year from @frdate if Month(@frDate) < 4 begin SET @ytdfrDate = "01/04/" + dateadd(y,-1,@frdate) end Thanks  
YTD Sale - Hi I have below Stored Procedure . I want YTd column value also. If user enters @frDate = 01/01/2021 and @toDate = 31/01/2021 then YTD value should be from 01/04/2020 to 31/01/2021 If user enters @frDate = 01/12/2020 and @toDate = 31/12/2020 then YTD value should be from 01/04/2020 to 31/12/2020 Create PROCEDURE [dbo].[SpBpGroupWiseSalePurchase] @frDate […]
SQL 2012 - General
Function for converting hh:mm:ss time to decimal equivalent - I have a user defined function that just needs a little tweaking. The first block of code used in a query returns 7 decimal places and when I wrap the code in a function it only returns 2 decimal places. Any clue would help... Thanks! ,CONVERT(DECIMAL(10,2),LEFT([LOGIN TIME],2) ) + CONVERT(DECIMAL(10,2),SUBSTRING(CONVERT(VARCHAR(8),[LOGIN TIME]),4,2))/60 + CONVERT(DECIMAL(10,2),RIGHT([LOGIN TIME],2))/3600 AS […]
SQL Server 2012 - T-SQL
How to get the detailed record and summary value at the same time - there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below picture, I just know one way to get the the result , could you please help me how many ways to get the result, it seems that […]
SQL Server 2019 - Administration
Complete permissions script - Hi Everyone Is there a script that can output a FULL audit of my SQL instance. As in script out: Logins Server roles Server securables Database Users Database Roles Database securables   I have bits and pieces of this but cannot find a complete solution.   Any help is appreciated   Thanks
Is that a reason DBA should Install SQL Server - Hello: I got a question from upper manager and he wanted to know why DBA should install SQL Server? Should Window Server Team install SQL Server? I tried to explain and clarify to him. Would you please give me a good reason why DBA should install SQL Server?   Thank you in advance. Edwin
Returning Database Properties related to "Change Tracking" - The SSMS Database Properties screen has a page "Change Tracking". How can I get those properties via regular SQL? The normal way to return database properties is to use sys.databases or DATABASEPROPERTYEX, but I could not find those properties via either approach. The SQL instance is 2019 - Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - […]
SQL Server 2019 - Development
T-SQL Unique Index - classification of unique - advice needed - I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not null), StartDate (not null), EndDate (nullable) and then the entity attributes. When an attribute changes, the EndDate is completed and a new record added with the new StartDate. So far - So good Each table also has a […]
SQL Server 2008 - General
Service Broker limit in SQL - As mentioned in the link below, https://www.codemag.com/article/0605061/SQL-Server-2005-Query-Notifications-Tell-.NET-2.0-Apps-When-Critical-Data-Changes For client-side applications, query notification users should not exceed ten concurrent users , in SQL Server 2005. What is the maximum number of concurrent users allowed while using query notification in  SQL 2008 and above?
General Cloud Computing Questions
Questions about Cloud Computing - I am currently a second year Information Technology student and I aspire to be a Data Analyst or be a DBA and I have currently learned SQL through MySQL Workbench and have created personal projects and I was just wondering as it pertains to cloud computing (Azure SQL or AWS SQL) is it best I […]
SSRS 2012
SSRS 2012 Email Relay question - Hi All, I am trying to figure out if it is possible to send SSRS subscriptions via email directly through our office 365 environment, and I am having issues. I can't seem to find documentation of if this is possible in SSRS 2012 (I know they added it in 2016)., and what settings I need […]
Analysis Services
SSAS Referenced Dimension - Ahoi, i have been looking at the different relationship options the Multidimensional Model offers, because i only have the Regular and the M:N ones in actual use. The one that confuses me is the Referenced Dimension type. From my understand it allows connecting a  Dimension and Facts by using an intermediate Dimension which has a […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -