| A community of more than 1,600,000 database professionals and growing |
| | | Start the DevOps Journey More and more, I find that getting someone's mindset to change is the major impediment to changing to a DevOps process. Once a person starts to believe in DevOps and accept a new way of working, they can rapidly start to improve the efficiency of their work. Moving on to change the mindset of a team (or teams) is even harder, but this is arguably the most important part of changing your software development process. I don't have a great way of changing everyone's mindset, but if you want to start, I have a thought for you that might add a little work, but will help you understand how to make changes in the way you work and experiment with a better way to deploy database changes. The tools are the easy part, and I want to help you get comfortable because the harder part is then trusting your process and helping others to learn how to trust a DevOps flow as well. To get you to start that journey, you need to learn one skill: how to execute your changes from the command line. That's it. Think about how you will manually execute your tasks now, and then ensure there are command line execution processes for these. This could be a call to SQLCMD with a filename as a parameter or it could be a DACPAC deployment with sqlpackage.exe. If you are a Redgate customer, we have PoSh cmdlets for deploying changes with SQL Change Automation or command line SQL Compare calls. A command line interface (CLI) is really the key for the DevOps toolset to succeed. That's only a small part of the process, since you need cultural change, you need to still model your database well and write good code, and you still need to learn how to improve your code over time. Adding a DevOps process allows you to spend time on code quality, testing, and skill improvement, instead of assembling changes and files for that next deployment. 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 | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | SQL in the City Summits - New York, London & Chicago This October, Redgate are inviting those interested in learning how their business can benefit from implementing Compliant Database DevOps to attend one of our SQL in the City Summits. If you manage SQL Server databases, or manage a team of people who do so, Redgate’s SQL in the City Summit is the conference for you. Find out who’s presenting and register for a Summit near you today.
Register now |
|
|
|
| | | | | Additional Articles from SimpleTalk Azure Storage can store many types of data, from NoSQL tables to VHDs. In this article, Supriya Pande explains how to work with Azure Storage Explorer, a tool that makes it easy to manage storage in Azure. She also provides an example of using the Azure Storage .NET SDK to upload files. More » |
| | Additional Articles from MSSQLTips.com In this tip we look at how to insert missing values for an identity column using the SET IDENTITY_INSERT command. More » |
| | Andrew Pruski from SQLServerCentral Blogs If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019. I... More » |
| | SQLEspresso from SQLServerCentral Blogs I saw this again recently and see it too often in environments so wanted to take a second to remind... More » |
|
|
| | | Today's Question (by Steve Jones): I decide that I need to ensure data used in dynamic SQL conforms to SQL Server identifier rules by adding QUOTENAME() to validate variables. However, in the string I am assembling, I want to be sure that I don't have any implicit conversions. If I use QUOTENAME(), what is the type of data that is returned to me? |
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: QUOTENAME(). 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): A tuple in Python contains a set of items, which could be other tuples. I create this tuple in the Python REPL: >>> AFCWest = (("Denver", "Broncos"), ("Kansas City", "Chiefs"), ("Oakland", "Raiders"), ("Los Angeles", "Chargers")) Now I want to access the elements. If I want to just return "Broncos", how would I do this?
Answer: AFCWest[0][1] Explanation: A element in a tuple is referenced with square brackets, just like an array. If there is a second tuple in that element, a second set of square brackets is used. Since python is 0 based, the Broncos element is at 0, 1. Ref: Python Tuples - 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. Failover - AG issue - Hi All, Issue: We have 2 instances say A01 AND A02. The client has network issue sometimes and they loose connection... How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL.... Sql server:Buffer manager , Datapages value question. - Hi experts, When I run: select * from sys.dm_os_performance_counters where object_name = 'SQLServer:Buffer Manager' and counter_name in ('Database pages') I get 'Cntr_value' around 10105000. Is... Databases in AlwaysOn Availability Group show "Synchronized" but they're not - Hi, Has anyone ever encountered a situation with an AOAG where the databases in the AG state that they're synchronized but... SSRS - Connect to two different databases in one SQL possible? - It doesn't appear by looking at the DataSets where you specify a Data Source that you can select from two... Automatically avoid error inserting into identity field - When I run the script below I get the error message below because it's trying to insert records in to... error message with try part of try catch when cursor updating tables - I have the code below which inserts records found only in tables in one database, into the matching tables in... BCP issues with export data files generated with queryout won't import in tables. - I have to Export data from ServerA and generate .csv files and then move files to other department for warehousing... Insert records in to table that has primary key identity seed - I'm trying to insert records from one table in to another table like the example below. The two tables have... Max size file in BCP process - Hi Experts, We are processing huge data file's on daily process form file to SQL server using BCP command. For Example : Daily... Wrong estimate when inserting in multiple sessions - Consider the following: 1. Create table test with int column id 2. Session A: insert 5 records, don't commit 3. Session B: insert... Where would you use XACT_STATE - Hello Using the example provided by BOL for XACT_STATE With stripped out comments and print statements below I'm struggling to see how XACT_STATE() is... Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an... Count values for first day of past n months - Query Performance Improvement - Hi All, I'm very new to PI and sorry if this is a silly question, but was wondering if I can... Running SSIS Package in scheduled job - Hi, I'm trying to run SSIS package stored on my local PC through SQL Server Agent job , and it always fails. When... Index Seek is costing a lot in execution plan - I've got a query that's costing me a lot during index seek. I ran the query on Database Tuning Advisor but... I need help with SQL queries - I need query in following format CustNo , YTDSales, PreviousYearSales, MTDSales I have query Declare @StartDate date = '01-01-2018', @EndDate date = '09-30-2018' Select ,sum(SalesAmt) YTDSales... Inserting recrods fromt the same table with an incremental value on every insert - how can we add a +1 on every insert or an update ? I have table with 3 primary keys and... Tracking use of measures/dimensions - Hi, I have a SSAS multi-dim cube used by around 100 people. It's a legacy cube that I'm re-developing on SQL2016, has... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
