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

Daily Coping Tip

Pause to just watch the sky or clouds for a few minutes today.

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.

Working in a Distributed Fashion

Recently at the Redgate Summit, Kendra (b|t) noted that all the developers working for her are doing so in a distributed fashion. She is a product manager at Redgate, and her team uses git to move source code around and share it with different members

With a shared database, we can have issues between developers, but many teams accept this as a part of working on the same project. We often just expect that our code is in the shared database, which means we don't need to actually move it around. Hopefully, we do put it into version control.

Has anything changed during the pandemic for how you work with your team? Or with other teams? I assume you don't see people, but you do need to share things, or maybe you've moved away from shared databases. In that case, you might have some tricks for sharing technical items.

Most of our work in this business is digital, so we likely adapted fairly easily to remote work. However, it might not have been completely seamless, and if things have changed, maybe you want to leave a comment on what's different.

For most of the work I typically do, it was always remote. While I miss collaborating with people in person, something I used to do regularly, the actual bits I need to move and share work in the same way. Actually, they work in more ways, as we've found new and interesting ways to share things outside of email and chat. Mural, Kanban boards, and even more video recording and posting have become more a part of my work day than they ever were before the pandemic.

Steve Jones - SSC Editor

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

 
 Featured Contents

Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory

Randheer from SQLServerCentral

Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]

Five facts about the SQL Server Tempdb Database

Additional Articles from MSSQLTips.com

In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.

SQL Templates and Code Snippets in SSMS and SQL Prompt

Additional Articles from Redgate

Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.

From the SQL Server Central Blogs - Summarizing a Script with SQL Prompt

Steve Jones - SSC Editor from The Voice of the DBA

I have never used this feature, but someone was asking for feedback on Prompt, and I noticed  this in the menu: Summarize script. I had guessed that it might...

From the SQL Server Central Blogs - Lesser-known facts of Explicit Transactions

Brahmanand Shukla from SQL Server Carpenter

Transactions are of various kinds in SQL Server such as Autocommit, Implicit, Explicit and Batch-scoped. I personally found this article quite helpful if you wish to understand Implicit Transactions....

 

 Question of the Day

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

 

Finding XP_CMDSHELL

I know I have a few stored procedures that are using xp_cmdshell. How can I easily find which procedures are calling this function?

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)

Checking out a remote branch

I have cloned a repo from someone else, but I don't see one of the branches that is shown on GitHub. I want to work on this branch. How do I check this out and get the code from the branch, mybranch?

Answer: git checkout -b mybranch origin/mybranch

Explanation: The checkout command can be used, with the local and remote branch names listed. Ref: git checkout - https://git-scm.com/docs/git-checkout

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 - Administration
Database list and the last access date - I've SQL like this, SELECT name as [Database Name], [Last Access Date] =(select MAX(temp.lastaccess) from ( select lastaccess = max(last_user_seek) where max(last_user_seek)is not null union all select lastaccess = max(last_user_scan) where max(last_user_scan)is not null union all select lastaccess = max(last_user_lookup) where max(last_user_lookup) is not null union all select lastaccess =max(last_user_update) where max(last_user_update) is not null) […]
cost licence calculated - Good morning all , How is the cost of the SQL CAL license calculated (Per number of Users) this is the SQL 2019 Standard Edition and according to you which is the cheapest CAL or Core license Thank you for your feedback
SQL Server 2016 - Administration
How to check if a column exists in SQL Server table? - I need to add a specific column if it doesn't exist. I have something like the following, but it always returns false: IF EXISTS(SELECT *   FROM INFORMATION_SCHEMA.COLUMNS   WHERE TABLE_NAME = 'myTableName'   AND COLUMN_NAME = 'myColumnName') How do I check if a column exists in the SQL Server database table?
SQL Server 2016 - Development and T-SQL
BCP - Export Query to Tab Delimited Text File - Dear Group: I am using SSMS and trying to export a query to a text file using T-SQL (I know there are options in the tool itself to do this, but I need this code for a stored procedure). I found examples but none of them seem to work and each gives a different error […]
Does SQL 2016 allow for column encryption? - I have a feeling I've asked this question before, but I can't find my having asked it previously. I'm sorry if I've already asked this question. We have a need to encrypt some data in the columns that they're stored in. However, we've no idea how that is done, both to store the data encrypted […]
SQL 2012 - General
How to compare development and production server database tables schema - Hello Everyone, We have converted a existing web application application from Asp.net Web forms to Asp.net MVC. The existing web-application hosted in dedicated server and the new one we are moving to Ms Azure cloud. On the development server we have Microsoft SQL Server 2012 - 11.0.2100.60 and in Azure cloud environment we have Microsoft […]
SQL Server 2019 - Administration
Connection issue from SSRS to SSAS data source - I have a data source defined on our SSRS server and it connects successfully when I am in IE but from Chrome or Edge, it fails. I ran Server Profiler on the SSAS server and see that when I Test Connection with IE, my user account logs in but when I do the same in […]
SSMS Encryption - Hello, Please forgive the elementary nature of this post -- I've been tasked with encrypting certain fields in our Azure SQL Server DB -- I have never done this and so far I have done the following: -Right-clicking on the column I want encrypted, and select 'Encrypt Column' -After following the prompts, SSMS created a […]
SQL Server 2019 - Development
String Manipulation Work? - Hello Geniuses, I have a string manipulation task that I am not sure is even possible...   Here is the data CREATE TABLE #TEMP ( Id INT IDENTITY(1,1), Sales Money, StateCode VARCHAR(2) ) INSERT INTO #TEMP (Sales, StateCode) Select '1200', 'MA' UNION ALL Select '200', 'MA' UNION ALL Select '120', 'GA' UNION ALL Select '190', […]
tune a table valued function that is using recursive CTE - We have a function that calculates student truancy records by counting their absence in a moving 30 days window. It uses a recursive CTE to count any 30 days passed. Then we use other table to join this table valued function, and it was extremely slow as records increased. I tuned it to select the […]
SchemaBinding and Temporal Tables - I have schema bound a view to a temporal (system-versioned) table and receive no errors in doing do. However, I am able to delete/modify columns from the temporal table, without issue. When I do a query against the view, it fails with a binding error. Has anyone else tried this? Should it work? BTW...on the […]
T-SQL SubQuery Help Please - Hi, I know this will be rather obvious to many, but I am struggling writing a sub-query at the moment. I am trying to return just the 1 row for each BadgeNo attendee based on the latest date updated joining it with a conf_code in table B. (Illustrative data below) Table A        […]
SSRS 2012
How to set up a zoom in the browser - Hi all, I have a problem with zoom option in SSRS. I published my report on the SSRS Report Server. After that I open it in GoogleChrome and when I go to the browser setting and change the zoom (for example 100 to 120) - my parameters are shifted. When I zoom in screen and […]
SSDT
Build SQL Server Data Project on Ubuntu - Hi everyone, we are currently designing CI/CD Pipelines and the build server we have available at the moment is a Ubuntu machine. I investigated a lot and it seems that this combination is just a bad idea and I really need a windows build server. Basically the CI pipeline is just a task to pull […]
Hardware
Block Size on MSSQL on Linux - Do I need to set my block size of drives on linux at 64k allocation size like I do on windowsOS?
 

 

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

 

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