| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| AI Concerns I hosted a webinar a few weeks ago about Artificial Intelligence and how it might affect data professionals. It was an interesting discussion with Kellyn Pot'Vin-Gorman and Brian Randell, with all of us having slightly different perspectives. Overall, we all agree AI is amazing and can be a useful tool for data professionals. This week I've been in Redmond at the MVP Summit, and AI has been a topic among many MVPs. Lots of jokes have been told, no shortage of which dealt with getting rid of staff. Not that these MVPs want to see less staff, but they know that executives and managers might see all the AI hype about how GitHub CoPilot writes code and think they need less developers. I don't know if that is really how executives will view the world, especially as most IT departments have more work than resources to complete their list of tasks. I can see AI helping get more done, which might mean less hiring (or slower hiring) in the future. There was an article this week talking about ways to protect your job in the age of AI hype. It was interesting in that the suggestions all revolve around bringing more value to your job. The suggestions about working in specialized areas, complex areas, being a better employee with documentation, these are all things that I've done in my career. It's what I also see from many MVPs. Maybe the most interesting item was to think about incorporating AI into your work now. It's not necessarily an expert on your work, but it is a tool. As the models absorb more information and become better trained, they can be a level to help you get more work done. They can assist you in tedious work, which is something many of us can benefit from. I am looking forward to getting access to CoPilot and keeping an AI tool up on my desktop, learning how it might help me, and maybe more importantly, where it won't help me. I can't stop this trend, but I can better understand it and learn how it might fit with my daily work. Knowing that helps me better understand how I might have an informed and rational discussion with management about the advantages or disadvantages of this new technology. Steve Jones - SSC Editor 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’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases. |
This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database. |
AI/Machine Learning/Cognitive Services |
This is a continuation of the evolution of AI with ChatGPT and how much it can be leveraged, allowing me Tags: AI in IT Del.icio.us Facebook TweetThis Digg ... |
ChatGPT and Watson Assistant are two popular AI-based chatbots, and both are riding the immense wave of interest in generative AI. Advanced AI Chatbots – in essence, generative AI... |
We put ChatGPT’s PowerShell scripting abilities to the test. See how the AI chatbot performed. |
This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. If regulators don’t act now, the... |
Administration of SQL Server |
During a routine SQL Server patching process on SQL Server some error messages appeared in the SQL Server Error Logs. As a result SQL Server was not able to start up |
This article will guide you through the steps to convert your existing data into tamper proof data by using the ledger feature. To enable ledger for a specific table,... |
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility Level at the database level: When you upgrade SQL Server or... |
DBCC SHOWCONTIG is a has been announced to be depr... |
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL... The... |
THE VIDEO THE SYNOPSIS We’ve installed SQL Server…but what next? Learn about important configuration options for that new SQL Server instance. LINKS AND ADDITIONAL INFORMATION All of these videos... |
Azure Databricks, Spark and Snowflake |
In this article, we will walk through how to mount different types of Azure storage like Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL, and Azure Cosmos... |
In this post we will look at the differences between map and mapValues functions and when it is appropriate to use either one. |
In previous blog posts, I explained how to automate the Database Project Build & Deployment process using Azure DevOps (Release) Pipelines. These blog posts focused on setting up as easily as possible using the Classic Editor. |
In this article, we walk through the steps of how to add an Azure SQL Database to an existing auto-failover group. |
Career, Employment, and Certifications |
If you're a software developer, thinking outside t... |
Computing in the Cloud (Azure, Google, AWS) |
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for Redshift in the tool DBeaver. When you work with SQL Server Management Studio (SSMS), you typically don’t have this issue as a temporary copy is always saved. Close down SSMS, restart it and the queries are still there. |
AWS Amplify is an Amazon Web Services (AWS) applic... |
There is no single command that can rename a S3 bucket. Mainly because S3 is not a filesystem and a bucket is not a typical folder […] The post How... |
This article continues the GCP series and we will learn how to manage and monitor Google Cloud resources and billing. |
Conferences, Classes, Events, and Webinars |
Join Redgate Advocate, Ryan Booz, and find out about the history of PostgreSQL, the different PostgreSQL variants, and the reasons behind its increasing popularity. |
SQL Saturday Haiti returns on April 29, as a virtual event in French. Register today and join us for free education and knowledge. |
Please join us for the next meeting on Monday, May 1st, at 6:30 PM ET. Akshata Revankar (Data Engineer, Specialist at McKinsey & Company) will show you how to... |
We hope you can join us on Wednesday, April 26, for a free-to-attend online event, AWS Developer Innovation Day. AWS will stream the event simultaneously across multiple platforms, including... |
Sometimes special characters are a nuisance. If you are trying to create some user accounts in on-premise or cloud environments, you should avoid special characters in usernames. In this... |
Are you creating PowerShell scripts for the first ... |
Fun With PowerShell - StringBuilder |
Data Privacy, Compliance, and Governance |
Organizations nowadays process tons of consumer data every day. This data ranges from the standard – names, email addresses, etc. – to personally identifiable information, like social security numbers... |
Here are four ways your enterprise can develop an accountable data privacy culture. |
The "Teacher’s Corner" of The American Statistician enables statisticians to discuss topics that are relevant to teaching and learning statistics. Sometimes, the articles have practical relevance, too. Andersson (2023)... |
The Woodbury matrix identity is a commonly used identity for inverting a matrix of a particular form. The identity states that where , , and are conformable matrices, i.e.... |
DevOps and Continuous Delivery (CI/CD) |
GitLab's research reveals software development trends: focus on security, AI in workflows, and DevSecOps adoption for improved efficiency. |
Seagate to recognize revenue shipments of 30TB+ HD... |
The Lenovo Slim Pro 7 is pretty and thin for a lap... |
At 1 cm thick and approximately 1 kg in weight, Asus is cramming a lot of tech into a svelte chassis. |
The Crucial T700 looks to be the fastest PCIe 5.0 ... |
Microsoft is reportedly working on an artificial intelligence chip based on TSMC's 5-nanometer process to better compete with Nvidia and other chip suppliers. |
I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. |
Oracle/PostgreSQL/MySQL/other RDBMS |
The process of modifying MySQL data from within Python is, in many respects, similar to querying data. You must define a connection object that links to the database and define a cursor object based on that connection. |
A common use case with PostGIS data is to calculate things, such as distances between points, lengths of lines, and the area of polygons. The topic of accuracy, or inaccuracy, with GEOMETRY data comes up often. |
Performance Tuning SQL Server |
How Indexes Talk To Each Other In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and... |
Back in 2018, when I started working on the SQL Server Execution Plan Reference, I spent quite some time thinking about what icons to show for all operators. I... |
Improving The Parallel Query Processing Documentation For SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and... |
Join Simplification In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing the results to... |
PowerPivot/PowerQuery/PowerBI |
I had a requirement where I wanted to only have th... |
Have you started using the new on-object editing for Power BI visuals? Adam found some hidden gems that you may not be aware of when using it! You need... |
Developing Power BI reports can be a very manual process. After building a report, you (or someone else in your team) has to publish the report into the right workspace at the right time. You might have multiple workspaces featuring the same content, for example to allow stakeholders to perform user acceptance testing (UAT) before a report is released. |
Stop queries showing aggregates in the Power BI fi... |
Product Reviews and Articles |
When you are integrating Flyway into an existing SQL Server SSDT development, you don't necessarily have to change everything at once. The development team might continue to use the... |
Product Upgrades and Releases |
On April 13, 2023, Microsoft released SQL Server 2... |
Linux SMB clients can now use Azure Files identity based authentication and authorization. This capability is available to devices that are domain joined to either customer-managed Microsoft AD DS or Azure... |
One of the more challenging technical details of columnstore indexes is the need for data to be ordered to allow for segment elimination. To assist with this challenge, SQL Server 2022 has added the ability to specify an ORDER clause when creating or rebuilding an index. |
SQL Server Security and Auditing |
Today, we worked on a service request that our customer got the following error message : Managed Instance needs permissions to access Azure Active Directory. You need to be... |
Invariably, when I ask people what Transport Layer Security (TLS) does, they say something like, “it protects my credit card info when I buy things online.” The response is not... |
CitizenLab has identified three zero-click exploits against iOS 15 and 16. These were used by NSO Group’s Pegasus spyware in 2022, and deployed by Mexico against human rights defenders.... |
Because the security vulnerability is under active exploit, Google isn't releasing full details of the flaw while users could remain vulnerable. |
T-SQL and Query Languages |
In this article, we will learn about one of the im... |
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation. |
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. In spite of what may be a controversial title to many of... |
In this new blog post I am going to explain how to use dynamic threshold in log alerts. Think for a second, that you need to create an alert that must, at the same time, apply to more than one resource and react to different thresholds. |
When working with SQL Server, it’s not uncommon to need to store data in a temporary table or table variable. While both options can be used to accomplish the... |
SQL Server provides several join types to combine data from two or more tables based on a common column or set of columns. Among these are the essential join... |
AMD's Ryzen 7 7800X3D is 7% faster in Linux compar... |
My latest book, A Hacker’s Mind, has a lot of sp... |
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. |
|
|