| The Complete Weekly Roundup of SQL Server News | Hand-picked content to sharpen your professional edge |
| What's Causing the Pushback with DevOps? The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps to instead say “a DevOps style process”. My intention is to try to steer clear of some of the rocks forming around the term. What I don’t entirely understand is why the pushback is occurring, but it’s out there. The core concepts of DevOps are pretty simple. Let’s focus on people in order to help them get their work done. We start with the elimination of silos and walls between groups, combine Development with Operations. It’s in the name. We focus on process that better supports people so that more, and better, stuff gets delivered for the organization. In support of that process, we implement as much automation as we can. That, in a nutshell, is DevOps. Who could possibly push back against that? Well, if that paragraph above represented how everyone understood DevOps, we wouldn’t be seeing pushback. However, there’s just tons of information out there that is poor. People get told stuff, a lot, that just isn’t true. So, a bad opinion forms. Further, a DevOps style process is something of a challenge to implement. You have to make changes to how you do things, always a challenge. Then, in order to support more and better automation, you have to spend a lot of time and effort in learning new tools and building new stuff. Sometimes, the implementation of a DevOps process fails. So, the misinformation and the failures combine to build a somewhat negative impression. However, more and more people are successfully implementing DevOps approaches. Even as you see some implementations fail, the details of the process, for example, getting your databases into source control, still results in overall improvement in how people work. In short, even if we toss the term because it’s being abused, the overall approach is succeeding and won’t go away. That’s a win! Grant Fritchey Join the debate, and respond to the editorial on the forums |
The Weekly News | All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. |
Vendors/3rd Party Products |
Redgate have launched their very own Online SQL Formatter powered by SQL Prompt. Visit the page here to try formatting your SQL code with a few pre-defined styles, or find out how to create and share your own styles with SQL Prompt. |
Jeremiah Peschka, a tech lead for SQL Monitor deve... |
Imagine having at your fingertips all the metadata queries you need to explore your SQL Server databases and then, a few clicks later, all your diagnostic queries to troubleshoot... |
Redgate are Gold sponsors of PASS Virtual Summit, which this year is available to all online. It's time to accelerate your data career by joining Redgate's Advocates who will be presenting a variety of sessions, as well as demo solutions throughout the week of 11 - 13 November. See what's happening and register today. |
SQL Server monitoring can enhance collaboration and stability by creating a feedback loop between devs and DBA teams about the impact of deployments. In this free whitepaper, we discuss how SQL Server monitoring can assist with a number of common challenges, from removing bottlenecks to identifying and responding to deployment-related performance issues. Read the whitepaper here. |
Based on Microsoft Documentation |
I haven’t had a need to resolve call stack symbols (see my post here for an explanation) on a SQL Server 2019 instance until last weekend, when I was prepping... |
Following an incident at a customer’s production environment, Nathan Lifshes and I realized that we stumbled upon a yet-unknown bug in SQL Server, causing an access violation error... |
Last release note for Azure Data Studio was about ... |
Have you ever been asked to make a schema only cop... |
Total: 1 Average: 5SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production servers during the non-business... |
Azure Databricks, Spark and Snowflake |
Before discussing why you would want to pin a cluster it would be useful to understand the different states of a cluster... |
A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token |
This post looks at how to re-configure a local Azu... |
This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Get started immediately on your first project with the new Knowledge center... |
To further accelerate time to insight in Azure Syn... |
I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer... The... |
I’ve been playing around with Azure Synapse Analytics for a while now exploring the preview features and trying to find a meaningful use case for the ‘single pane of... |
Computing in the Cloud (Azure, Google, AWS) |
I ran across an interesting a couple of weeks ago when working with a client. The client has several subsidiaries each with their own vNet. The client had a... |
The Microsoft Azure Modular Datacenter (MDC) is designed to support datacenter scale scenarios for humanitarian aid, disaster response, and other needs for high-intensity, secure cloud computing in challenging environments. |
Conferences, Classes, Events, and Webinars |
T-SQL is my favorite aspect of working with SQL Server. The release of SQL Server 2005 coincided with the beginning of my involvement with the community as a presenter... |
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule, with lots of neat sessions. I’ll be speaking in the am, and am happy to... The... |
With the launch of SQL Monitor 11, you can now monitor your SQL Servers hosted on Amazon RDS alongside your on-premises and other cloud-based servers, instances, and databases. Join this webinar on October 28 to discover the benefits of monitoring your entire estate; including on-premises and cloud-hosted databases, from a single pane of glass. |
As you probably already know by now, the 2020 edit... |
Like most things in life, this piece of work came about while attempting to complete something else... |
Data Mining / Data Analysis |
Taking your organization’s data to the next leve... |
Data Privacy, Compliance, and GDPR |
Over the past few years, several new regulations r... |
Database Design, Theory and Development |
At D2L, we’re the perfect candidate customer for In Memory OLTP features, but we’ve held off adopting those features for years... |
Last year, Aaron Bertrand tackled the question, How To Alter User Defined Table Types. Aaron points out that “There is no ALTER TYPE, and you can’t drop and re-create a type that is in use”. .. |
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had to do this the other day,... The... |
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process. |
Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch. |
DevOps and Continuous Delivery (CI/CD) |
More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment at scale.… The post Continuous... |
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch. |
Performance Tuning SQL Server |
If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all... |
I have written a nearly 1,000 page book on SQL Ser... |
Live Fish I recently had the pleasure of appearin... |
PowerPivot/PowerQuery/PowerBI |
Changing the credentials of a data source is very similar to what we’ve done with report parameters, but there are a few... |
Recently I had to get some data from a Power BI Dataset. At first, I started... |
For this article, I want to share a way for you to create your own Power BI “Helper Tool” and register it... |
The ability to apply custom format strings directly inside the Power BI Desktop report view was first announced back in February 2020. At the time I was quite excited... |
Thanks for watching this week's Power BI news roun... |
Product Reviews and Articles |
This book aims to update your DBA skills to cover SQL Server 2019, how does it fare? |
I streamed about writing a technical book earlier ... |
Finding the right balance between collaboration an... |
Conventional wisdom says that communication is the critical for success in just about any aspect of life, be that personal relationships or within teams or corporations. Of course, miscommunication... |
eWEEK DATA POINTS: Data-driven enterprises centralize their knowledge of data by automatically capturing metadata on what the data describes, from where the data emanates, who's using it, and how... |
In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL Servers and also connecting to a PostgreSQL database. |
I saw this on a post at SQLServerCentral and wanted to share... |
I swear It’s Not String Splitting I have to do this a fair amount, and I always go look at this little cheat sheet that I have. Then it occurred to... |
Your database is riddled with computed columns whose definition includes a scalar user-defined function. Even up to & including SQL Server 2019, which boasts faster scalar function processing, any... |
Familiar readers will know that I don’t actually do New Music Friday here very often. Okay, ever. I don’t do it ever. Because frankly, nobody writes music about us.... |
Virtualization and Containers/Kubernetes |
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading The post SQL Virtual Machines appeared first... |
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. |
|
|