| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Looking Back and Forward I took part in a podcast this week, Arrested DevOps. I did one with them once before, almost ten years ago. The host and I were both a little surprised that it had been so long. This caused us to look back a bit. Interestingly enough, ten years ago meant I was only about two years into my gig with Redgate. Things were so different then. I don't want to say better or worse, but very different. I think the biggest thing is that we had really just launched ourselves into the whole DevOps thing. Now you may be a lot younger than I am and so you don't have ten years of experiences within IT to look back on. Doesn't matter. It's not a bad thing to look back on your career, life, whatever, and see how you've come along (or haven't). Take a moment. Mourn the losses, but don't linger there. Savor the triumphs. Hold that for a second. Now, face forward. What's on the agenda for the next ten years? Yeah, you can't really say for certain. The future is quite literally, unknowable. However, goals, at least a sense of direction, that is something that you can know. Have something, anything, to shoot for. Myself, I've got a couple of goals. At work, I'm really hoping to get recognition as a PostgreSQL influencer, teacher, go-to person. Outside work, I'm barely scratching the surface as a maker (focused on electronics), but I'm really hoping to build that skill set & grow. In addition to the core, care for and love of my family, these goals keep me going. Identify your goals, and your core, and keep going at it. The future will work itself out, one way or another. But you'll have set a direction and brought influence to bear so that, ten years on, you can look back with some pride and a lot of learning. Then do it all again. 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. |
| AI/Machine Learning/Cognitive Services |
| If you’re reading this, chances are you’ve pla... |
| Researchers find artificial intelligence applicati... |
| Last week I posted polls on Twitter and LinkedIn a... |
| Everyone assumes that AI is the Hollywood version with robot overlords taking over the world. In reality, AI is already here and we are using it in society. Phone... |
| The pharmaceutical industry operates under one of the highest failure rates of any business sector. The success rate for drug candidates entering capital Phase 1 trials—the earliest type of... |
| Airline violates privacy protections of the EU's G... |
| While AI’s ubiquity is becoming increasingly evident through everyday tools like chatbots, smart cameras, and smart content generation, there’s an expansive universe of less recognized but highly potent advancements... |
| Administration of SQL Server |
| Pain Point: Something bad happened and you need to... |
| The defaults for saving SQL Agent Job history are ... |
| The defaults for saving SQL Agent Job history are ... |
| Have you ever had to deal with ghost records? Whil... |
| I had to test something for a customer, and as a p... |
| I’m excited to be presenting at PASS Summit 2023... |
| In this article, we look at two different methods ... |
| I came across a puzzle about "The Two Doors, Two Guards," popularly known as the "Two Doors Riddle" or the "Heaven and Hell Riddle". First appeared on SQL SERVER –... |
| Learn how to generate images using AI and Microsof... |
| Analysis Services / BI on the MS Stack |
| Fun With KQL Windowing Functions - Prev and Next |
| Learn how to use calculation groups and how they w... |
| Incorporating Full-Text Search functionali... |
| Azure Databricks, Spark and Snowflake |
| This post aims at describing the differences betwe... |
| In this article, we discuss transactions in Snowfl... |
| This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article will cover how to create virtual warehouses and different types of tables, how to handle semi-structured data, how to profile queries, and the benefits of clustering keys. Practical demonstrations of the concepts explained will be provided throughout the article. |
| In July, we've delivered multiple improvements ac... |
| I'm going to show you different configurations to ... |
| In this blog post, we will embark on an exciting journey into the world of Azure SQL Database performance monitoring using PowerShell and the powerful sys.dm_os_performance_counters system view. By... |
| Azure SQL Managed Instance |
| Performance pillar in the Well-Architected Framework for Azure is focused on ensuring that your workload can meet performance requirements and that it can efficiently use resources to deliver results. There... |
| Career, Employment, and Certifications |
| A customer called us, quite upset, because their R... |
| First, A Story Years ago I managed an ETL Team at ... |
| Good morning dear reader, Long time no talk. It ha... |
| 12 Years, 50 Courses: A Tale of Enthusiasm, Determ... |
| I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading |
| Job recruiters share advice to help applicants increase the chance of landing the job, even as more tech is used in the process. |
| Kendra Little examines the differences between rol... |
| Summer is in full swing here in Seattle and we are... |
| Increasingly more organizations initiate AWS migr... |
| It’s probably no surprise that generative artifi... |
| In March 2023, AWS and NVIDIA announced a multipar... |
| As organizations grow, the records that contain in... |
| I am happy to announce that a new AWS Local Zone in Phoenix, Arizona is now open and ready for you to use, with more instance types, storage classes,... |
| Public preview enhancements and updates released f... |
| Promo Video I couldn’t have said it better myself. Registration is here. Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love... |
| Computing in the Cloud (Azure, Google, AWS) |
| For workers outside the tech sector, the Great Res... |
| Fundamental engineering skills are crucial for IT ... |
| With much of the U.S. and many other parts of the ... |
| Here's why organizations need to get on board with... |
| As businesses try to optimize their costs during e... |
| Conferences, Classes, Events, and Webinars |
| The wait is finally over. This year’s PASS Data Community Summit sessions are now live! |
| Watch this video to learn techniques for working w... |
| This midyear roundup of our most-read PowerShell a... |
| Automate the execution of PowerShell scripts using... |
| In today's fast-paced digital landscape, it is crucial for organizations to efficiently monitor and manage their infrastructure's resource utilization. High resource consumption or misconfigured open ports can lead to... |
| Microsoft has announced some important changes com... |
| Data Mining / Data Analysis |
| Data analysts are an important part of modern busi... |
| El objetivo es siempre el mismo: poder desarrollar... |
| As a member of the SAS Data Ethics Practice, I was... |
| El ritmo de vida actual puede resultar, en ocasion... |
| Gartner technology analysts predict that organizations leveraging augmented analytics solutions will grow at twice the rate of those that do not use these solutions. Those organizations that provide self-serve augmented analytics to... |
| Database Design, Theory and Development |
| The last few years have seen a big change in the size, make-up, and nature of database estates. Data is growing both in volume and complexity, it is now... |
| DevOps and Continuous Delivery (CI/CD) |
| In this article, we will look at GitHub Copilot fo... |
| GitOps is a way of implementing continuous deliver... |
| Thousands of organizations use DevOps practices ev... |
| Learn the importance of adding security practices ... |
| “Garbage in, garbage out” defines the importan... |
| Looking for a career in software development? Check out our guide on what a DevOps engineer does and what it takes to become one. |
| The concept of tact is simple. Telling people truths, often harsh truths, without making it seem harsh. Hopefully, it is clear that being truthful is one of the more essential things in life. As a person in technology (and certainly as an editor), we often need to be honest when the truth hurts a bit more than average. |
| Crucial's X6 and X8 Portable SSDs have been attrac... |
| THE VIDEO THE SYNOPSIS In this video, we will trai... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| This article discusses what Microsoft Fabric is an... |
| Introduction Fabric Warehouse is a new interesting... |
| Microsoft has launched a URL page for its Microsof... |
| Microsoft has released a new firmware analysis fea... |
| Microsoft Teams is getting a new Meet app that sho... |
| On July 27th 1993, Microsoft released Windows NT, ... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| Mutaza Umair gives an introduction to security within the PostgreSQL framework. |
| Writing queries to retrieve the data from a databa... |
| In this article, we look at how to get historical ... |
| In the previous article in this series, I introduced you to the MySQL LOAD DATA statement, which lets you retrieve data from a plain text file and insert it... |
| Performance Tuning SQL Server |
| Do Best Going Further If this is the kind of SQL S... |
| Decipher the SQL Server performance mysteries with SQL DM. Microsoft's SQL Server is a robust and widely adopted database. First appeared on Deciphering the SQL Server Performance Mysteries with SQL... |
| PowerPivot/PowerQuery/PowerBI |
| In today’s world of wanting to automate everythi... |
| I have been doing a fair amount of work on Row Lev... |
| SQL Server Security and Auditing |
| Actually, this is a change for many products and s... |
| I'm delighted to announce the launch of my 51st co... |
| A widespread disinformation campaign aimed at Amer... |
| Weak encryption algorithms leave radio communicati... |
| Seems that there is a deliberate backdoor in the t... |
| Hackers have three key pathways — the OS, apps, ... |
| Boards must now file notice of a "material inciden... |
| Developers need more software security safeguards ... |
| Living up to its name, Maximus sees a whale of a b... |
| Interesting research: “(Ab)using Images and Sounds for Indirect Instruction Injection in Multi-Modal LLMs“: Abstract: We demonstrate how images and sounds can be used for indirect prompt and instruction injection in... |
| T-SQL and Query Languages |
| In today's data-centric landscape, Azure SQL Datab... |
| This tip presents a high-level overview of impleme... |
| MIT Technology Review’s What’s Next series loo... |
| Virtualization and Containers/Kubernetes |
| Application Gateway for Containers is the next evo... |
| I haven’t touched Docker Swarm for a looooong ti... |
| Trusted content is paramount in securing the suppl... |
| Go-SqlCmd provides additional features for deployi... |
| 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. |
|
|
