| A community of more than 1,600,000 database professionals and growing |
| | | Use More Pull Requests I noticed a short while back that Books Online is on github. You can fork the code and make corrections to pages and then submit a pull request. This is the model that many OSS projects use, including the amazing DBATools project. That one I really like, and if I was better at PowerShell, I'd contribute. If you're a PoSh whiz, I'd urge you to contribute. A few years ago I saw a lot of complaints about the SQL Saturday site, and over the years I've also seen a number of complaints about the Pass Summit sites, and the registration process. At one point there was a debate over whether PASS should build a registration system or continue to pay for the service. To me, this was a perfect place to start a project, maybe with a few volunteers, and then crowdsource enhancements and improvements. Get help from the members of this technical community, after all, this is the way most of us make a living. If Microsoft can get help from outside, I'd expect other organizations could as well. Certainly PASS has limited resources, and this is a great way to perhaps get new ideas, innovate, and grow their system. There will be some friction and loss in reviewing changes, but I'd expect that the overall gain would come from the greater number of people contributing to the software. We've kicked this around for SQLServerCentral and Database Weekly, and I am hoping to start getting help in enhancing my own site from its community at some point. There are certainly challenges and difficulties in integrating code from lots of sources. DevOps makes this easier, with more automation to evaluate and test code before a human needs to review it. However, DevOps has its own challenges, with extending the culture and process to others, and finding those individuals that want to contribute and buy into the philosophy, not to mention maintaining code quality and standards. However, I hope that you consider using pull requests and getting help from others in your own organization or project. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
| |
|
|
| | | | | Erin Stellato from SQLServerCentral.com Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries. More » |
| | Press Release from Redgate Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. More » |
| | Additional Articles from MSSQLTips.com Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work. More » |
| | matthew.mcgiffen 73574 from SQLServerCentral Blogs I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full... More » |
| | Bradley Schacht from SQLServerCentral Blogs I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing... More » |
|
|
| | | Today's Question (by Steve Jones): I assign a simple set of values to a variable in R: football <- c("LT", "WR", "LG", "HB", "C", "QB", "RG", "FB" ,"RT", " ", "TE", "WR") I then want to shape this somehow, so that when I run this: print(football) I get this [,1] [,2] [,3] [,4] [,5] [,6] [1,] "LT" "LG" "C" "RG" "RT" "TE" [2,] "WR" "HB" "QB" "FB" " " "WR" What code do I use to shape this? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: R Language. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I am trying to round upfor in my coffee card tracking to ensure that I never run out of money. For each amount, I want to round down and ignore the cents, which means that I will be saving fractions of dollars throughout the year. I'll use all these at the end of the year to buy Christmas presents. I also want my deposits (show as negatives) to also be rounded, to add more savings. In testing, I don't seem to get the right results from this query. WITH mycte (a, n) AS (SELECT a, n FROM (VALUES ('Coffee', 2.38), ('Coffee', 4.53), ('Recharge card', -15.50), ('Recharge card', -5.25)) a (a, n) ) SELECT a, SUM(FLOOR(n)) FROM mycte GROUP BY a; I have more tracked in recharges than I added, not less. Why? Here are my results. a ------------- ------- Coffee 6 Recharge card -22
Answer: I need to change my query to use CEILING(n) Explanation: The Floor function will round down, always to the lower integer. This is the opposite of what I want. I need the CEILING function. This rounds up my positive values, and down my negative ones. Ref: CEILING - click here » 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. Index creation not completed - Hi, tried to create below index CREATE NONCLUSTERED INDEX IDX_POSITION_ID_FROM_DATE_TO_DATE ON . (,,) INCLUDE (,,,,,) index creation is not completed after 30 minutes. issue is in... Strange transaction log activity - I'm suddenly seeing unusually large transaction log backups for a small database, and the application team swears that nothing has... SQL Server 2014 SP2 upgrade on Alwayson + FCI - I want to upgrade my SQL Server 2014 to SP2 which is involved in SQL Server FCI and Alwayson. Below... Location options for data and indexes - Setting up a new server. For the data, I have 2 TB SSD RAID1 as drive D: and 12 TB SATA... Script or Ways to check if SSRS encryption key backed up - Hi Experts, Can anybody help me finding out how to check if the SSRS encryption key have been backup up... Updatable View to remote table with Identity column using phantom NextVal? - SQL Server Internals? - I have a situation and I need some internal advice. Here is the history of the situation. We have a... Fill in missing gaps on intergers - given a starting value and an ending value when stored as INT. how can i achieve the following. CREATE TABLE... Append variable to query - Hi, declare @Value varchar (20) SELECT @Value = case when @Status = 'Y' then '' else 'top 500 ' end I need to append the above @Value... Send and save a copy of an email (as .msg) - To start this off on "the right foot", I am pretty sure that this can't be achieved by T-SQL/SQL Server.... Max isn't working in my query - Hello, I have this script which is an extract of my database. I don't design it, so the structure will not... Optimize query that is using like statements - I currently have a large query which is taking over an hour to run, and am attempting to optimize. Unfortunately,... Failed to create AppDomain "mssqlsystemresource.dbo.3". - SQL ERROR LOG - Error : Date 8/8/2017 12:39:47 PM .....Source spid62Message Failed to create AppDomain "mssqlsystemresource.dbo.3". Exception has been thrown by the target of an invocation. Findings : Last... How to do incremental loading without date filters - We need to load the data which is inserted or updated in last four days in a source to staging... Subroutines in TSQL - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should... Store Procedure Problem - When i am running first time sp it will take 30 sec and second time it will execute 1 sec. My... Find out the not matching key value in look up - Friends, My SSIS package is loading data into DWH on daily basis. On one of the package , inside the data flow,... SSIS Package Import Problem - We are in the process of upgrading our servers from 2008 R2 to 2014. It has been decided though that... How to access another server temp table without any Linked server - Hi All, I have a requirement where #temp table is available in one server lets say "A" and I need... Data flow concept - Thoughts wanted - Looking for thoughts on this. I have an application where we receive data from customers via text file. Unfortunately, we... Query optimization - Select Into .. Alter Table ADD CONSTRAINT PRIMARY KEY ( ASC) - I need help to Query optimization. Query is part of StoredProcedure which executes for more than one hour. I need to optimize the... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
