A community of more than 1,600,000 database professionals and growing

Featured Script

dba_CopyLogins

The Voice of the DBA

Azure DevOps

I've been a fan of Visualstudio.com and VSTS for some time. I moved most of my demos to this platform a couple years ago and I've been pretty happy with it since then. There is tremendous flexibility in how you can use automation and dashboards to build software and coordinate the activities of your team.

The VSTS system underwent a rebranding and reorgnaization renently. The various pieces of the system were renamed a part of Azure DevOps, with the different parts being given new monikers such as Azure Pipelines, Azure Boards, and more. This was combined with an initiative from Microsoft to better support open source projects by giving them unlimited build minutes for public Github repositories on a variety of platforms such as Windows, OSX, and Linux.

I'm not a bit fan of name changes, as I think that if the software performs well and provides value, it will succeed. However, marketing people need work, too, and management inside a company often rearranges things to put their own mark on a project. I'm actually glad the marketing effort was ramped up as I think the Microsoft platform based on TFS for tracking work, version control, builds, and releases has become a fantastic platform for anyone building software. That's not to take away from some other products like Bamboo and Octopus Deploy, which might work better for you. If they do, they plug into the Azure DevOps platform easily.

If you haven't tried Azure DevOps, I'd urge you to give it a try. There's an all day recording of various parts of the system being used to produce software that will show you how to get started and use the system. I'm sure there will be more information and talks this week from Ignite. There aren't a ton of database tools, but there are some add-ons from various companies to help you build and deploy databases alongside your application software.

While there are challenges with databases, I'd argue that incorporating a known process will increase reliability and lower risk for making changes. This won't help you build better code. That's something you still need to ensure your developers are doing. This system just helps ensure simple, silly mistakes aren't made and everyone knows exactly how your changes will be deployed to your production environment.

Give Azure DevOps a try today and see how you can build a smooth, repeatable, reliable process for your software.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.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.

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

Microsoft MVP Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps. This webinar offers a closer look at the key findings in the 2018 Accelerate State of DevOps Report, and investigates the growing importance of the database in successful DevOps and IT performance.
Register now

What’s the top challenge faced by SQL Server professionals in 2018?

Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report

Featured Contents

Uploading On-Premise data to Azure Blob Storage using SSIS

Supriya Pande from SQLServerCentral.com

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task. More »

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps. More »

Questions About HIPAA That You Were Too Shy to Ask

Additional Articles from SimpleTalk

As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask. More »

From the SQLServerCentral Blogs - Using Table Valued Parameters with sp_executesql

Kenneth Fisher from SQLServerCentral Blogs

Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to... More »

From the SQLServerCentral Blogs - Them Con+cat+enatin’ Blues

Roland Alexander STL from SQLServerCentral Blogs

We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic... More »

Question of the Day

Today's Question (by Thomas Franz):

What will the query in the following statements return (tested on SQL 2017):

 CREATE PROCEDURE dbo.test AS PRINT 1; GO EXEC sys.sp_rename @objname = 'dbo.test', @newname = 'test2', @objtype = 'OBJECT'; GO SELECT sm.definition FROM sys.sql_modules AS sm WHERE sm.object_id = OBJECT_ID('dbo.test2') GO

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: sp_rename.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

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 David Fundakowski):

What will the output be of the following:

 DECLARE @string NVARCHAR(max) = ( SELECT REPLICATE(N'X', 9000) ) SELECT DATALENGTH(@string)

Answer: 8000

Explanation:

The correct answer is 8000. According to the docs, if the statement expression inside replicate() is not a MAX datatype and you are working with strings, replicate will truncate the return to the first 8,000 bytes.

Ref: REPLICATE() - click here

» Discuss this question and answer on the forums

Featured Script

dba_CopyLogins

Chuck Hamilton from SQLServerCentral.com

Source server	Server from which you are copying logins
Destination server	Server to which you are copying logins

Execute code on destination server to create the stored procedure in the master database.
Create a linked server on the destination server that references the source server.
Execute the stored procedure on the destination server using the linked server name as the @PartnerServer parameter
Optionally include @debug=1 to output the commands that would be executed without actually executing them.

Example:

exec dba_CopyLogins @ParnterServer = 'PrimaryReplica'

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 : SQL Server 2017 - Development

Obfuscating values (via T-SQL) in several Varchar, Char, and Datetime columns ? - Is there any good T-SQL solution that you can recommend for obfuscating a dozen of Char and Varchar fields in...

SQL Server 2016 : SQL Server 2016 - Administration

What happens to Primary replica if secondary replica server did not come online after patching - Hi Guys, I got a question about AG group. I have a AG group setup A-P with automatic failover (Async). What will...

sp_DatabaseRestore - Hi, I'm just curious if others use sp_DatabaseRestore from Brent Ozar's First Responder's Kit. If so, are you having any issues...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

SQL Server stored procedures fast in SQL but slow when called by ASP.NET - Query inside the stored procedure giving result fast (twenty seven thousand records in 2 seconds) but when i called the...

Insert 2k rows in one second - Hi , I have a bourse application that in beginning of the day , service application get 2K messages that this messages...

How to get precise error message when processing SSAS through SSIS? - First, please tell me if I am on the wrong forum... My Server is SQL 2016 I process a SSAS database through...

SQL Server 2014 : Development - SQL Server 2014

Multiple joins vs. 1 lookup table (alternatives) - Hi, In a DataMart analysis for a CRM system, about 10 Dim tables are joined with FactTable to see if the...

SQL Server 2012 : SQL 2012 - General

?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 - ?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 ?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 ?????//??VK31//#// OPK69.COM //??????????? ????????? ?

??????/??VK31/?/#/?/???:OPK69.COM/????????????? ????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-31 - ??????/??VK31/?/#/?/???:OPK69.COM/????????????? ????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-31 ??????/??VK31/?/#/?/???:OPK69.COM/????????????? ????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-31 ??????/??VK31/?/#/?/???:OPK69.COM/??????????

??????//??:WHT79//??????// KORG1.COM //??????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-9 - ??????//??:WHT79//??????// KORG1.COM //??????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-9 ??????//??:WHT79//??????// KORG1.COM //??????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-9 ??????//??:WHT79//??????// KORG1.COM //??????????????? ?????? ?????????

????«??:WHT79»?????«//KORG1.COM//»??????????????? ?????? ????????? ???? ?????????? https://www.korg1.com/blank-12 - ????«??:WHT79»?????«//KORG1.COM//»??????????????? ?????? ????????? ???? ?????????? https://www.korg1.com/blank-12 ????«??:WHT79»?????«//KORG1.COM//»??????????????? ?????? ????????? ???? ?????????? https://www.korg1.com/blank-12 ????«??:WHT79»?????«//KORG1.COM//»??????????????? ?????? ????????? ???? ??

??????//??VK41//??????//OPK69.COM//???????????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-23 - ??????//??VK41//??????//OPK69.COM//???????????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-23 ??????//??VK41//??????//OPK69.COM//???????????????? ?????? ??????? OP ???? ????? ????? ???? https://www.opk69.com/blank-23 ??????//??VK41//??????//OPK69.COM//???????????????? ????

?????{/??:WHT82/}????{// KORG1.COM //}?????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-19 - ?????{/??:WHT82/}????{// KORG1.COM //}?????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-19 ?????{/??:WHT82/}????{// KORG1.COM //}?????????????? ?????? ????????? ???? ???????? https://www.korg1.com/blank-19 ?????{/??:WHT82/}????{// KORG1.COM //}?????????????? ?????? ?????????

?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 - ?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 .?????//??VK31//#// OPK69.COM //??????????? ????????? ?????? OP ???? ?????? ??????? ???? ?????? https://www.opk69.com/blank-8 ?????//??VK31//#// OPK69.COM //??????????? ?????????

????????VK41?// //#?OPK69.COM????????????????????????????????OP???????????????????? - ????????VK41?// //#?OPK69.COM????????????????????????????????OP???????????????????? ????????VK41?// //#?OPK69.COM????????????????????????????????OP???????????????????? ????????VK41?// //#?OPK69.COM????????????????????????????????OP???????????????????? ????????VK41?// //#?OPK69.COM?????????????????????????????

SQL Server 2008 : SQL Server 2008 - General

Line and Columns combination -

Data Warehousing : Integration Services

Starting a TeamCity build from SSIS via the TeamCity ReST API - Has anyone managed to initiate a TeamCity (TC) build from an SSIS script task? This is quite a simple task in...

SQL Server 7,2000 : T-SQL

How to get output of SP_HELP_JOB into a script? - Trying to write a T-SQL script to check up on the status of a replication merge agent job that randomly...

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.
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.