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

Daily Coping Tip

Make a no plans for one day this weekend; be kind to yourself.

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.

Delivering in a Day

I wrote about Redgate's Down Tools Week recently, where we suspend most work for a week and assemble teams to work on a project. It's amazing to me how many things come out of a week's worth of work from a team of 5-10 people.

While looking to see how other companies have done this, I ran across a few interesting posts. There is a consulting company, called Six Feet Up, that wrote a series of posts after running eleven ShipIt days, one a quarter. They seemed to enjoy the process, though I wonder if they still do them and have gotten tired or writing about them or they stopped.

Atlassian is the company that started this, running the days as 24 hour events where they provide resources to help teams work together. They work from Thursday afternoon until noon on Friday, at which point teams can present their project. The idea seems to be to foster some camaraderie, an exciting environment, and pressure to chase an idea. While some might see it as a chore, others see opportunity.

There seems to be a large amount of participation, and I'm sure this can be hard on those with families, but for one day a quarter, perhaps this might be fun. Atlassian has a lot of employees, and they've moved to remote ShipIt days, with some projects taking multiple ShipIt days across quarters. They have a fun video that shows some of the ways in which this hackathon works.

While I hope that people don't feel too pressured to join in, I also hope that most people relish the chance to tackle a project and make something happen in 24 hours.

This week, however, I wonder if many of you think you could get traction on an idea in 24 hours? Would you want a ShipIt day at your company, 24 hours, once a quarter? Or maybe you'd be interested in Redgate's model, one week a year.

Let us know today by leaving a comment.

Steve Jones - SSC Editor

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

 
  Featured Contents

Database Snapshot Use Case: Service Migration

Br. Kenneth Igiri from SQLServerCentral.com

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.

Reverse-Engineering the Production Database into Source Control

Additional Articles from Redgate

Starting out a new database development with source control is relatively easy. To introduce source control into an existing database application can be more challenging. Phil Factor explains some of the fundamental steps.

SQL Server Problems We Don’t Have Anymore

Additional Articles from Brent Ozar Unlimited Blog

There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.

From the SQL Server Central Blogs - My August Christmas Card

Pam Mooney from The Non-Cluttered Index

Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...

From the SQL Server Central Blogs - The value of mentoring

gorandalf from Gorandalf's SQL Blog

I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...

 

  Question of the Day

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

 

What is a Pull Request?

What is a pull request in Git/GitHub?

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)

Getting File System Volume Info

What is the supported way to get the size of your C: drive on a SQL Server 2019 instance from T-SQL?

Answer: sys.dm_os_volume_stats

Explanation: xp_fixeddrives is not a supported extended stored procedure. sys.dm_os_volume_stats is the way to do this. Ref:

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
Editions and supported features in SQL 2017 - I am trying to do some research in terms of keeping cost to see if we can go with standard edition instead of Enterprise edition. Based on my research i found that standard edition has some limitation like 24 cores ,128 GB memory, online index create and rebuild, resumable online index rebuilds, Hot add memory […]
SQL Server 2017 - Development
Table in sql server 2017 takes alot of time to update/insert few rows - Hello I have a table in sql server 2017 that has around half million records and it is constantly used via website. Select statement are very fast over it or over its views,but update/insert of 1 or 2 rows takes a lot of time sometimes 1 row needs 15 minutes as if table is busy. […]
Same code but one is faster and another one is slower - Do you know why the query 1 runs for hours as  opposed to the query 2 with runs in seconds.? and how do I make query 1 faster? Query 1:SELECT distinct a,b ,c FROM [dbo].[d] WHERE Date > DATEADD(d,-3,GETDATE()) Query 2: SELECT distinct a,b ,c FROM [dbo].[d] WHERE Date > DATEADD(d,-3,GETDATE()) and Date <= DATEADD(d,-2,GETDATE()) […]
Fill in missing Dates for Shift - Hi, I have two tables DimCalendar and DimPersonShift, I want a SQL query which will fill in the missing dates that are not in the DimPersonShift table.   SQL Script to Create Tables DimCalendar and DimPersonShift CREATE TABLE [dbo].[DimCalendar]( [ISOdateKey] [int] NOT NULL, [DateKey] [smalldatetime] NULL, [DayNum] [int] NULL, [WeekDayNum] [int] NULL, [Day] [varchar](9) NULL, […]
SQL Server 2016 - Administration
sql server crash - I had sql server 2016 in one of our servers, then I decided to install SSIS AND SSAS for Bi purpose, And I tried to install these two services (SSAS AND SSRS) in another instance. After installing the second Instance, I notices that: I can’t connect to the first instance sql databases (It has been […]
SQL Server 2016 - Development and T-SQL
need script that returns all the columns in a table that have data in them - I need a query that will basically generate a select statement that will select all records for only the columns that have data in them .
Matching backslash in a table's column using R language - Given the following code: CREATE TABLE [dbo].[products] ( [nvarchar](25)) INSERT INTO [dbo].[products] VALUES ('A\BCDEFG') GO EXEC [sys].[sp_execute_external_script] @language=N'R', @script=N' pattern1 = "^[\x20-\x7e]{1,20}$" pattern2 = "[\x22\x27\x2c\x3f\x5c\x60]" outData <- subset(inData, grepl(pattern1, code, perl=TRUE) & !grepl(pattern2, code, perl=TRUE))', @input_data_1 = N'SELECT FROM [dbo].[products]', @input_data_1_name = N'inData', @output_data_1_name = N'outData' WITH RESULT SETS (AS OBJECT [dbo].[products]); GO why is […]
Administration - SQL Server 2014
Linked server gives error - Hi team, I had to update the TNSnames file under: D:\....\11.2.0\client_2(clinet_1) \network\admin, to reflect a new server name of Oracle. After doing this change, the test Linked server connection fails. TNS ping works fine. Telnet to the server name works as well. Do I need to reboot the SQL server ? Error is : TITLE: […]
SQL exception error - We have a job running multiple times a day from a app server which points towards the database server. The job runs fine most of the time but fails once or twice a day and gives the following error:   Exception : System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an […]
SQL 2012 - General
How to get all parts from temp table in case it return nothing ? - I work on SQL server 2012 I face issue I can't return data not have relation with function create table #TempPC ( PartNumber NVARCHAR(300), CompanyId INT, Status nvarchar(200) ) insert into #TempPC (PartNumber,CompanyId) values ('9C06031A2R43FKHFT',1233345), ('VJ0805AIR5CXAMT',8433324)   when make select as below : Select t.PartNumber,t.CompanyName,pc.FamilyName,t.Status FROM #TempPC t cross apply [PC].FN_PartCheck_Test( t.[PartNumber],0,1,1,t.CompanyId) pc Where pc.GroupID>-2 […]
Write to sparse file error and ndf files - Hi, We have ABC.mdf and ABC2.ndf and a relatively newly created ABC3.ndf We created ABC3.ndf because ABC2.ndf  was on a 2TB drive and was running out of diskspace. The drive ABC2.ndf  is on is pretty much full now. We are seeing Write a sparse file errors (17053 and 5128) saying there is a lack of […]
SQL Server 2019 - Administration
Always on AG - I was planing to configure AG between 3 servers. So Primary and Secondary Replica 1 on the same location and then Secondary Replica 2 on DR location. Primary Replica - Full, Diff and Log backups & Maintenance Jobs etc. Secondary Replica 1 (same location Sync mode for fail over) -  Reporting purposes and data transfer(with […]
SQL Server 2019 - Development
Efficient way of data comparison between tables - Hi All, I understood there is a table to table SQL Server Table & Data Comparision Tools, but this is for the table in same format & structure.   I finding, but unable find a Data Comparison Tools which is for different tables to compare the data. If such a yes, any experience with this? […]
getdate () brings me a different time than my operating system - Hello, I have SQL Server 2019 installed on a server with windows server 2019, in the operating system the time is 11:10 am but in SQL Server when I give it SELECT GETDATE () it brings 10:10, I don't know what else to check. many of the stored procedures use getdate () and obviously this […]
SQL Server 2008 - General
getdate () brings me a different time than my operating system - Hello, I have SQL Server 2019 installed on a server with windows server 2019, in the operating system the time is 11:10 am but in SQL Server when I give it SELECT GETDATE () it brings 10:10, I don't know what else to check. many of the stored procedures use getdate () and obviously this […]
 

 

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

 

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