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

Daily Coping Tip

Get outside and pick up litter or do something kind for the planet

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.

What Were Your 2021 Wins

LinkedIn sent me a prompt just before Christmas that asked me to write a post on my 2021 wins, using the #2021wins hashtag. I thought it was a neat idea, and I blogged on this topic before I left for my final vacation. I primarily had work items in there, though a couple of work-related things. To me, while 2021 was disappointing in some ways, it was still a great year for me in many ways, and I've tried to keep that in mind. Not focus on things that didn't go well but those that did.

It's the first week of the new year, and many of you are likely starting to look forward at work and in your career. You might have made resolutions, or maybe you are just re-focusing after the holidays. Either way, on this Friday I'd like you to think back to last year, focusing on how your career might have changed throughout the second year of the COVID pandemic.

What was a career win for you in 2021?

That's the question. It could be a change that you made, a skill you learned, a project you completed, maybe an award. Perhaps it was something that happened and you just experienced. Maybe an event or talk that inspired you or changed the outlook on something.

I'd like to think that all of you had at least one good thing happen in your career last year. Take a minute and share in your win and congratulate others for theirs.

 

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Query control made easy

maxtardiveau from SQLServerCentral

Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It's a hard problem, and there is no single solution, other than a defense in depth. Let's look at one of those defenses for databases: query control. Query control is a simple idea: most applications access […]

SQLServerCentral Article

Analyze Live Salesforce Data in Infragistics Reveal 

JerodJ from SQLServerCentral

Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combining Reveal with CData solutions, you can instantly build dynamic dashboards from live enterprise data sources like Salesforce. […]

External Article

Using Flyway Teams with SQL Change Automation PowerShell Cmdlets

Additional Articles from Redgate

Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.

External Article

Azure Policies and Management Groups

Additional Articles from SimpleTalk

You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.

Blog Post

From the SQL Server Central Blogs - 2021 a year in review

Kenneth.Fisher from SQLStudies

No matter where you are in the world the last couple of years have been, shall we say, difficult. More ... Continue reading

Blog Post

From the SQL Server Central Blogs - Distributed SQL

James Serra from James Serra's Blog

A very brief history of databases for online transaction processing (OLTP) workloads starts with relational databases (RDBMS), which worked well for many years. With the advent of the internet and...

 

 Question of the Day

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

 

Easily Saving PoSh Results

I am running a PowerShell script, but the results scroll off the screen. I want to easily paste the results into Excel, but I can't easily highlight the entire result set and copy/paste it. How can I send the results to the clipboard so I can paste them into Excel?

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)

Shrink and Release

I want to use DBCC SHRINKDATABASE to get some space back after a lot of data was deleted. Which option will release free space back to the operating system?

Answer: TRUNCATEONLY

Explanation: The TRUNCATEONLY option will release space from the end of the database file(s) to the operating system. This option, however, does not move pages inside the file. NOTRUNCATE will move pages to the front of the file and leave space at the end, but will not release space to the operating system. Ref: DBCC SHRINKDATABASE - https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-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 2017 - Development
Is it possible to migrate a solution from SSMS to SSDT?? - VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SSMS to SSDT? The main purpose is to incorporate large solutions with multiple files into TFS that SSMS is not supporting.
Help with query - Hi  all, This code gives 2 results SELECT distinct(AtcCode) as id, Atc_Text FROM [dbo].[Drugs_BasicData] d inner join [dbo].[ATC_CodeTexts] t on t.AtcCode = d.ATC AND t.County = 'DK' INNER JOIN dbo.Companies c on d.Distributor = c.CompanyID WHERE c.Country = 'DK' AND LEN(AtcCode) > 5 and Atc_Text like 'Cefalexin%' Order by Atc_Text;   id Atc_Text QJ01DB01 Cefalexin […]
SQL Server 2016 - Development and T-SQL
Missing Indexes - We are noticing a lot of I/O latency on our SQL server. Is it common to have a lot of missing indexes? We are trying to narrow down what could be causing all the I/O latency we are seeing. Thanks for any help!  
Administration - SQL Server 2014
No objects listed for "SQL Server performance condition alert"? - Hi All, Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition. Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box. SQL Server event alerts are working. Issue is only with "SQL Server performance condition […]
SQL 2012 - General
Noob SQLServer 2012 Question - Let me preface this with I am a sysadmin working on an SCOM 2016 install and have a question regarding an error message that keeps getting thrown via application event logs. An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCESSACCOUNT', […]
Execution plan not show missing index so are there are remainig point to enhance - I work on sql server 2012 my execution plan as below my query is very slow it not show missing index so please how to enhance query please ? my execution plan as below https://www.brentozar.com/pastetheplan/?id=HJbwOAkhF
are there are any thing can do after create index to enhance query speed ? - I work on sql server 2014 i need to enhance query my execution plan as below : https://www.brentozar.com/pastetheplan/?id=ryWtGAknF now i create index as execution plan analysis CREATE NONCLUSTERED INDEX MissingAttr_idx ON [dbo].[TPartAttributes] ([ZfeatureKey]) INCLUDE ([PartID],[Name]) my question are there are any thing remaining can do to improve enhance after create index as above
SQL Server 2019 - Administration
Install SSIS - Hi I am getting this error when i try to install SSIS: MainViewModel.OnBundleAction: Bundle action failed: The requested metafile operation is not supported (0x800707D3) I am downloading and installing this file: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects I already installed Visual studio 2022 and I am running SQL Server 2019. Do you know how I can fix this error message? […]
SQL Server 2019 - Development
Trying to print barchart to PDF file using Python within SQL Server ML module - There are likely to be several unrelated errors here, but I'm going to start with the first one what I can get my mind around.  I'm trying to use the "Python within SQL Server" mechanism to generate a barchart to PDF.  I get an error message that I don't have permissions to the directory I'm […]
Get Data from Internet Directly into SQL Server - Hi I am using these rates for a calculation https://www.treasury.gov/resource-center/data-chart-center/interest-rates/pages/textview.aspx?data=yield Currently, I manually update a local table and then insert that table into SQL Server.  It would be ideal if I can get SQL Server to directly access the rates from that site.  Is this possible?  If yes, how would I do that? Thank you
CASE statement and partition by - Hello everyone, I have a question if someone may know how to adjust the code correctly. I need just to edit the last outer SELECT statement. I need to change the partition by DMDUNIT, I need  outer CASE statement to look at 2 columns: 1) Start Date - if we have 3 distinct weeks worth […]
Using OPENDATASOURCE as an ad hoc Linked Server -   I'm not sure if this should be posted here or not, but I will try. We have a configuration where multiple customer databases are distributed across several servers. On occasion (not frequently), it is necessary to compare data between two databases on the same table utilized by the application.  Because there are several Servers […]
BCP adding carriage return/new line every 2034 characters - I have an SQL query that creates a JSON output.  The query works properly and gives me the output I expect when I manually run it via SSMS.  When I run it in a BCP command from an SP, the BCP utility is adding carriage returns and new lines every 2034 characters.  I can open […]
Interpolation/Extrapolation - Hi everyone I am trying to use linear and cubic spline interpolation/extrapolation to fill in missing rates.  I have never done this before in SQL.  What is the most efficient way to do this? Thank you
General Cloud Computing Questions
Cloud Storage Questions... - Hi. I own a mobile entertainment business....dj, photobooth, karaoke, etc... I have had several portable hdd failures, and am concerned about loss of data. I am hoping to find a way to host an online backup of about 5tb of files (music, video, photos, etc...) but don't know where to start looking. I have searched […]
 

 

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

 

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