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

Boring or Scripting

This editorial was originally published on May 18, 2015. It is being re-run as Steve is traveling today.

Do you want to continue to perform boring, repetitive, mundane tasks as a part of your job? Many of you might not be challenged at work, or you might be burdened with a series of requests that repeat themselves over and over. They're easy tasks, many of them probably take minutes. I'm sure there's also a level of mindlessness that you find comforting at times with just working through a familiar task.

However many of you also get busy. You have no shortage of new tasks that get assigned to you on a regular basis. You probably also get stressed from your heavy workload at times. What do you do when you're too busy to work through the mundane tasks, but they still need to be done? It can be a challenge to manage that burst in a workload if you haven't prepared for it.

There is a way to remove some of the mundane administrative work from your job. It's not simple, and it's not going to solve all your issues right away, but over time, you can certainly reduce the burden of working on dull tasks over and over again, across multiple machines.

Learning PowerShell (PoSh) or some other scripting language. VBScript works fine, as does Perl, and there are others, but if you're a Microsoft person, especially a SQL Server person, learn PoSh. It's used in all the products, it's becoming a standard for all Microsoft products, it works in the cloud, and it works with SQL Server. It takes some getting used to, and some practice, but it certainly can help with repetitive tasks. It can also run all your SQL scripts for you, just in a more automated fashion.

You can grow your career, add a new skill, reduce your workload, and become more efficient at your job.

Or continue to be boring.

Steve Jones - SSC Editor

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

 
  Featured Contents
Stairway to Snowflake icon

Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code

Mike McQuillan from SQLServerCentral

Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.

External Article

Should That Be One Update Statement or Multiple?

Additional Articles from Brent Ozar Blog

Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:

Technical Article

The SQLskills Black Friday Super Sale!

Press Release from SQLServerCentral

Starting at 4pm PST on Thursday, November 28th, SQLskills will be offering our lowest prices ever for our signature Blackbelt bundle with more than 158 hours of top-quality training.

Blog Post

From the SQL Server Central Blogs - Thoughts on AI Data Infrastructure Field Day #1

kleegeek from Technobabble by Klee from @kleegeek

On October 2nd and 3rd, I took part in an amazing event called AI Data Infrastructure Field Day as a delegate. If you’ve never heard of this event before,...

Blog Post

From the SQL Server Central Blogs - PASS Data Community Summit 2024 Day 3 Keynote

Steve Jones - SSC Editor from The Voice of the DBA

It’s been an amazing week here, as well as a long week. I’m tired, as are many others. The blogging table is a little bare this am, but I...

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

  Question of the Day

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

 

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';

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)

What's the Ceiling?

What do I get as the results from this code?

SELECT CEILING (999.999), CEILING (-999.999);

Answer: 1000, -999

Explanation: CEILING returns the smallest integer greater than or equal to the argument. Ref: CEILING - https://learn.microsoft.com/en-us/sql/t-sql/functions/ceiling-transact-sql?view=sql-server-ver16

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
Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing - First time here...hoping I can find some direction and answers so I can devise a proper solution. Novice Basic SQL experience over the years while being the "jack of all trades' IT support, not a DB admin by any means. Issue: After vendor Application upgrade and SQL upgrade from 2014 to 2016 we cannot process […]
Issue with DBMail - Hi all   We've got 3 servers with the same setup for dbmail. They use the same account (just with a different display name as replies are ignored) and every was working perfectly until this weekend. I've now only got 1 server out of the 3 that is correctly sending emails automatically. Server1 is running […]
SQL Server 2016 - Development and T-SQL
Counting values with hysteresis in Report Builder - Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value reached above lets say 75%. Is there a way to do that in Report builder ? Thank you JK
SQL Server 2019 - Administration
Agent job security account - Hi All, I have few sql server agent scheduled jobs which are supposed to run as NT Service\mssqlserveragent account however at times it runs using different account. Being novice in this world , I am not able to figure out where to make the change in agent job security to ensure that it only and […]
Export database and tables no table data - Trying to move a database from one sql server instance to another on separate servers . I need to only move it like a skeleton no data and looking for steps to export the database and tables. Is this possible?
SQL Server Newbies
normal role member to be able to view list of other role members in his DB - Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and [sys].[database_principals] can not be accessed even with grant .
SQL Azure - Development
How to manage Time zone changes for countries - Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October 2, 2024. This software is copyrighted by Microsoft Corporation in 2022. We have developed a ticketing system currently used by around 30 countries, and we expect this number to grow in the coming days. To maintain each country's local time, we […]
SQL Azure - Administration
Azure elastic job issue authenticating to Azure SQL database - Azure elastic agent jobs: I’m getting this error “The server principal “ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3” is not able to access the database” when an elastic agent job tries to run against a new database that has been added to an elastic pool.   The elastic pool is configured as a target group member. For all other databases in […]
Connecting
SSMS 20.2 on Windows11 not able to connect to SQL 2005 ?? - We still have a couple of dino's. What should I check to re-enable access to ye good old SQL 2005 on Windows 2003 for my SSMS 20.2? I have already accepted "use server certificate" and "optional encryption" Still doesn't work; "SSL Connection forcebly closed by server" btw: When using SSMS 18.12.1 it works fine
Integration Services
Package to Project model conversion - Hi All, With previous customer range we were always required to work in the traditional package model approach were individual packages were stored in deployment folders and combined with configuration files. (Usually old 2008R2 SQL server versions) For my current employee I have the liberty to setup everything from scratch using newest versions of everything. […]
SQL Server 2022 - Administration
Converting job_id to join to another table. - I need help, please! I have a monitoring table that pulls in information about program name (plus sp_who2 does as well), and I need to join it to msdb.dbo.sysjobs to get the job name where the program name starts with SQLAgent (like SQLAgent - TSQL JobStep (Job 0x8FA89775AAF135499FA4CC1621B639FB : Step 1)). Nothing I try is […]
How much transaction logs generated by hourly/daily - For MSSQL is there any queries or methods for me to pull historical data of transaction logs generation? I know that for Oracle database we can run a query to extract the amount of archivelogs generated hourly/daily. Is it possible for MSSQL? I have an hourly TLog backups running on the database, so currently I'm […]
Export Data-tier Application vs Generate Script: Why Does SQL Server Have Both? - Hey everyone, SQL Server has two mechanisms for deploying and moving a database to another platform: Export Data-tier Application and Generate Script (with the "schema and data" option enabled). I'm a bit puzzled because these are two different tools that seem to tackle the same task. From what I've read and tried, they appear almost […]
SQL Server 2022 - Development
A Design Question using a fictious example - Background: I have two tables. Tests and Grades. For each Tests record there are many Grades; one for each student. The Grades table has a field called: StudentsGrade. Each time a Tests record is inserted into the database, an associated Grades record is inserted into the database, one for each student where the value of […]
Generating (semi-)fake purchase data - I know how to generate fake data (thanks to Jeff Moden's articles!)... the problem is that I'm trying to generate purchase data where the unit price of a product increases on some products over time.  Normally, I'd get the changing price information from all the purchase invoices, but I don't have those. So I have […]
 

 

RSS FeedTwitter

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

 

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