| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Define All The Steps Up Front After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined the process, on either side, all the way through. See, we keep finding out there's one more thing to do. "What do you mean you don't have a Title 5 inspection of your septic system? You have to have a Title 5 inspection before you can sell." On and on like that. One thing after another that we didn't hear about up front so we could easily take care of it. Instead, it's always a scramble to arrange for one more person to swing by one of the houses to do something. How well are your own processes defined? Just how many flaming hoops do you make your developers hop through before they can deploy code changes to production? How many hidden little gotchas do you know about in your systems and their processes but no one else has a clue? Frankly, IT is hard. From the start of developing anything, to maintenance on old, well established systems, the full spectrum of IT is difficult. As much as humanly possible, document that stuff. Make things as clear as possible. Communicate to all your peers everything that they need to know. All sorts of hidden processes, secret tricks, and anything that adds to the difficult of IT should absolutely be eliminated. All the things we do in IT are hard enough on their own. Don't add to the difficulty by hiding stuff. 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 |
In the Global State of the MSP Report from Datto, cloud and cybersecurity were identified as two key areas for growth. In this blog we cover three wants Managed Service Providers can offer more value in this areas. |
If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed. |
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases. |
I was developing some personal .NET projects when ... |
AI/Machine Learning/Cognitive Services |
How do you convince decision makers in your enterprise to give a machine learning (ML) project the green light? You might be super excited about machine learning – as... |
The economic value of data for companies is challe... |
Your ability to land your next job could depend on... |
Administration of SQL Server |
Bulk operations to set up log shipping |
When creating a table you can specify IDENTITY wit... |
Did you know, you can use Actions to Filter Extend... |
In my previous article I have explained the basics... |
Hypothesis: If I have Dynamic Data Masking enabled... |
SQL Server provides information for troubleshootin... |
Relational databases represent an organization’s... |
In the process of installing, SQL Server creates s... |
Starting SQL: Basic Index Design Patterns If you want to check out my more advanced training, follow this link to get 90% off. |
Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options. |
Reading Time: 7 minutes In this post I want to co... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL and Azure Synapse.… The post How to query private blob... |
There are lots of reasons to attend the PASS Data Community Summit 2020. Itzik Ben Gan lays out several of them for you in this new video. |
We’ve opened up registration and the call for sp... |
Computing in the Cloud (Azure, Google, AWS) |
Two Andreessen Horowitz analysts take on the indus... |
Conferences, Classes, Events, and Webinars |
Join Flyway expert Carlos Robles in this session to explore and discuss the new features of Flyway v7 which make it one of best database version control and migration tools in the market. |
Discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck. |
Introduction In last Monday’s blog post, Fun Wit... |
Data Mining / Data Analysis |
Following on from my introductory blog series, Dat... |
As you have probably determined, with blog posts l... |
DevOps and Continuous Delivery (CI/CD) |
Click to learn more about author Romi Stein. We now know the story of how, over the past decade, the CIO role has transformed to be that of a... |
Transforming your business with intelligent automa... |
How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers... |
ETL/SSIS/Azure Data Factory/Biml |
I am excited to announce the latest release of SSI... |
Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences. |
Performance Tuning SQL Server |
A cautionary tail about the use of index hints. |
PowerPivot/PowerQuery/PowerBI |
It occurred to me that we have put so much effort ... |
Presently sponsored by: Guarantee peace of mind from credential stuffing attacks. Learn how at Arkose Labs’ webinar with Troy July 27 at 10 am PT. Save your seat! When the... |
Click to learn more about author Steele Arbeeny. If the COVID-19 pandemic taught us anything, it’s that you can never be too prepared for change – fast-moving, come-out-of-nowhere change that transforms... |
A little Python and some learning code |
You enjoyed the intro to Python video, now let's l... |
This is very useful if you are creating many repor... |
From SentinelLabs, a critical vulnerability in HP printer drivers: Researchers have released technical details on a high-severity privilege-escalation flaw in HP printer drivers (also used by Samsung and Xerox), which... |
World’s largest oil producer says some company files were compromised. |
Enterprise security teams have had a rough year. W... |
Wrestling with higher costs and more risk, insurer... |
Both OSes have flaws that allow attackers with a t... |
The August 25 meeting will convene industry leaders late next month to discuss strategies for confronting the growing threat of cyberattacks. |
Compromised routers give the hackers anonymity in ongoing large-scale attacks. |
Here's how software developers have come to reap some of the benefits of digital transformation. |
In the first article of this series, we discussed ... |
Despite advances in tools, platforms and languages... |
Muse Group's intentions appear to be good—but th... |
When it comes to error handling or troubleshooting a long stored procedure, RAISERROR is an easy statement to use that gets the job done. Way back in SQL Server... |
This is part 18 of a 19 part series on TSQL Basics... |
Another post for me that is simple and hopefully s... |
SQL is a programming language used to create, read, update, and delete databases. It has one of the most popular functions for rounding numbers, which can be very useful... |
Viasat fears SpaceX competition, sought freeze on launches and environmental review. |
The Renaissance artist and scientist's youngest li... |
US cities are working to shore up their flood defe... |
This time, there was a blastoff. Blue Origin f... |
Argo and Ford will deploy driverless cars on Lyft'... |
Images narrow down possible theoretical explanations for how black hole jets form. |
“What we know about Jeff Bezos is that he doesn?... |
Virtualization and Containers/Kubernetes |
Date: Tuesday, August 24, 2021 Time: 02:00 PM Ea... |
What is Azure Kubernetes Service? Probably makes s... | 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. 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. |
|
|