SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

Managed Instance States

The Voice of the DBA

Encouraging Innovation

I was working with a client recently and one of the managers said they wanted to encourage innovation inside their organization. That sounded good, but as I thought about it, I wasn't sure what this means, or if it's really something that matters. Let's take a few examples and think about this in a modern organization that builds and operates software.

If I am a developer, I get a series of requirements or tickets where I have to write code. Perhaps I need to take inputs from a user, query a database, and produce a result. I might write code in C# 7 instead of C#6 . Maybe I'd use a lambda instead of creating a new function. Perhaps I decide to ensure I use the stored procedure type with named parameters rather than submitting SQL as a batch. Is that innovative? It might be a better way to write code and improve the quality (or security or maintainability) of the code, but is it innovation?

Another example. I'm a DBA and I need to run scripts against production. All the DBAs use SSMS, but I decide to change. I store the scripts in a folder and use Flyway to execute them against production with an automated system like Octopus Deploy, which manages the security. Is that innovative or just adopting a more DevOps-y practice?

Jason Fried says innovation is overrated, which I think is true. At least when that's an aim or we expect to build something radically different. I know there are sometimes we might come up with something new that our organization hasn't done, but most of the time work is work. It's tedious mundane, and it can be very repetitive. That's why the urge to do and try something new pervades most development organizations.

I do think that you can regularly innovate in your workplace. You might not create something that's never been done anywhere in the world, but you might get people in your org to try something new. To adopt a new technique or habit, to create higher quality code with a small change. That's the type of innovation that I like to see and foster. That's what DevOps encourages, experimentation and learning. It's also what I think my examples above show. It's innovation in this particular space, which hopefully makes work more interesting and enjoyable.

Steve Jones - SSC Editor

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

Featured Contents

How to Create a SQL Database on a New Drive in Ubuntu

Nisarg Upadhyay from SQLServerCentral

This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This article covers the following topics. How to install SQL Server 2022 on Ubuntu Linux. How to add a new drive in Linux. Attach the StackOverflow database using the database. Install SQL Server 2022 on Ubuntu I have […]

PASS Data Community Summit registrations are open!

Additional Articles from Redgate

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.

Find 40 Problems in this SQL Server Stored Procedure

Additional Articles from SimpleTalk

I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.

From the SQL Server Central Blogs - Monitoring Deadlocks in Azure SQL Managed Instance

SQLBalls from SQLBalls

Hello Dear Reader! My lastest blog on our Azure FastTrack blog for Microsoft is live, Monitoring Deadlocks in Azure SQL Managed Instance. Here's a little from the blog:To paraphrase Annie,...

From the SQL Server Central Blogs - New Job -> Week 7 and Beyond

hellosqlkitty from SQLKitty

This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be...

SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Additional Articles from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Managed Instance States
There is the ability of Azure SQL Managed Instance to stop the instance. With this feature, what are the states that a Managed Instance can report to the admin?
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)

KILL permissions

What permissions are required to use KILL on a different connection?

Answer: anyone with ALTER ANY CONNECTION can run the KILL command

Explanation: The KILL command requires the ALTER ANY CONNECTION permission, which can be granted to anyone, but is included in the sysadmin and processadmin roles. Ref: KILLPermisions - https://learn.microsoft.com/en-us/sql/t-sql/language-elements/kill-transact-sql?view=sql-server-ver16#permissions

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

Index Creation for large table failed. - I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job. CREATE CLUSTERED INDEX [IX_Arc_tblFST_GSNID] ON [dbo].[tblFST] ( [GSN_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON, DATA_COMPRESSION=PAGE) ON [ps_tbl_arctbltnr]([TNR_Date]) However the creation […]

Always ON, HA, File Location Problem - Hello All, I have four VMs setup while I am learning SQL Server Admin tasks and configurations. SVR01 is the DC, the other three are the servers to be used. I am attempting to setup Failover clustering, however I run into this error every single time, no matter what folder I use, what name I […]

SQL Server 2016 - Development and T-SQL

Extracting Data from XML file - Hi all, I have a XML file which consists this type of data: 12345 1 ABC XYZ TEST TYPE TEST REFNUM 2016-11-30 TESTCOMMENT TEST DESIGN TEST NAT TEST TYPE EXACT 1964-07-17 […]

How To Enumerate Hierarchical Info on SP calls - NOTE: Forgive me if I am using the wrong terminology with regards to this. \ I am trying to get a list of all The SP's (Stored Procedures) that are called by an SP. For example let's say I have the following SP's: LF5_Job1, LF5_JOb2, LF5_CalcResFees, F5_CalcCommFees & LF5_PopulatFees The SP LF5_Job contains one 'EXECUTE' […]

SQL Server 2019 - Administration

Log File continue growing - Hello everyone, i read a lot about growing Log Files on this forum but can´t find a solution for my problem. I moved a database from one server to another, cause there were several performance problems on that old server. Since i moved the database the lfd file is continue growing. Database (mdf) file is […]

Generate 1 log file every 1 hour doing a backup every 1 hour? - EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = 'D:\DADOS-LOG', @BackupType = 'LOG', @LogSizeSinceLastLogBackup = 1, @TimeSinceLastLogBackup = 60, @DirectoryStructure = NULL, @FileName = '{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}.{FileExtension}', @AvailabilityGroupDirectoryStructure = NULL -- How to modify this script to generate 1 log file every 1 hour doing a backup every 1 hour?

how to set to a variable - how can I make SELECT SERVERPROPERTY('MachineName') to set to a variable? Thanks,

SQL Server 2019 - Development

Script to import BACPAC file? - Did some searching, and the closest I've seen is using the SqlPackage command-line tool, either directly from CMD or through a PowerShell script. I'm aware that in SSMS, you can do this by right-clicking and selecting "Import Data-tier Application". Is there any way to do this through a standard SQL script? Or is the only […]

select query - Hi, I would like to select the specific string from the field(Text_Loginame) value from a table. Below are the two records in that filed. Text_Loginame Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided.[CLIENT: XXXXX] Login failed for user 'ABC\XXXX'. Reason: Failed to open the explicitly specified […]

Importing XML data into a Table - Hi, I am trying to write a script which will import fields from an XML file into a table. Below is the example XML Test company other Other 111111 […]

Grouping the words which has maximum count - Hi All, I have to highest two word in the columns. It should have the maximum two words combination. I have attached the excel for reference.

General

SQL server loads slow troubleshoot common issues? - What are some best practices to identify and troubleshoot slow query performance issues on an SQL server, and what are some effective tools and techniques to resolve problems with server crashes or connectivity disruptions? How do you optimize SQL queries for performance, and what are some common pitfalls to avoid What are some advanced features […]

Analysis Services

How can external customers access SSAS cubes to create their own analysis - My company has a number of SSAS tabular cubes which are deployed to a server and Power BI reports are built on top of that. We have lots of bespoke reporting requirements from external customers and are thinking it would better for them to do there own analysis and reporting as long as we can […]

Strategies and Ideas

Injest user-provided Excel? - In today's episode of "Products that Should Exist (and maybe do)": Have you come across a solution (preferably a web-based portal) that allows an end user to upload an Excel file, digests the data, identifies tabular data, walks the user through column mapping to structured data, performs data validation, highlights invalid data, allows editing of […]

Integration Services

SSIS package succeeding but Job failing (fail - converting date and/or time) - Hi, I successfully created an SSIS package and it executed perfectly in Visual Studio's development environment. However, when I scheduled this very package within a SQL Server Job Agent, it mysteriously fails: " Hresult: 0x80040E07 Description: "Conversion failed when converting date and/or time from character string.". End Error Error: 2023-05-04 13:33:28.19 Code: 0xC004701A Source: Load […]

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.