| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Distracted I've found myself to be very distracted this week. Concentration on the task at hand has proven to be a challenge. I'm pretty sure the cause is that I just came off of three weeks of travel, which can be exhausting. Concentration, like so many things in life, requires energy. No energy, no concentration. So, the question is, how to recharge. Now, a big part of that is simply going to be getting a good amount of sleep, in your own bed (with my own pillow, I miss my pillow when I'm on the road). However, you also need to make sure you're eating well, exercising, and getting in whatever "me" time you need. All of this is challenging. Further, except for the sleep, all of it requires effort, which requires energy, which I don't currently have. HA! It's a blocked process. The lesson is, take care of yourself so that you can do what's necessary, including taking care of yourself. 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 |
PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime. |
AI/Machine Learning/Cognitive Services |
A career in in artificial intelligence involves s... |
Prominent Google computer scientist Geoffrey Hinto... |
AI ethics are a factor in responsible product deve... |
Deep learning pioneer Geoffrey Hinton announced on Monday that he was stepping down from his role as a Google AI researcher after a decade with the company. He says... |
The insurance industry has witnessed a significant shift in recent years as technological advancements continue to transform traditional business models. From underwriting to claims management, artificial intelligence (AI) and... |
The debate over whether ChatGPT and other generati... |
Administration of SQL Server |
Hello Dear Reader! My lastest blog on our Azur... |
Hello, I’m Steve Stedman, and I want to talk abo... |
Learn how to improve your database efficiency with... |
What if there is no primary key in table? |
Introduction These are my SQL Server Diagnostic Information Queries for May 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... |
As a business owner or IT professional, you know your SQL Server is critical to the success of your organization. It’s essential to ensure your SQL Server is running... |
Azure Databricks, Spark and Snowflake |
In this post, we will discuss how to use SnowSQL client in Windows to connect and work with Snowflake. If you are new to Snowflake, we […] The post How... |
The article is published here on the Microsoft Sec... |
Learn about the steps needed to remove a SQL datab... |
Today Data Exposed went live at 9AM PT for a special Ask Me Anything and news update. If you missed the episode, you can find them all at https://aka.ms/AzureSQLYT.... |
Azure Synapse (SQL Data Warehouse and Data Lake) |
Taking advantage of Notebooks in Azure Synapse Ana... |
Amazon has announced the general availability of i... |
Today we are launching AWS User Notifications, a single place in the AWS console to set up and view AWS notifications across multiple AWS accounts, Regions, and services. You... |
Today, I’m happy to announce that a new open-source sample application, a fictitious used books eCommerce store we call Bob’s Used Books, is available for .NET developers working with... |
This blog post aims to provide an overview of Azur... |
V4 is the latest upgrade for Microsoft Azure Backup Server (MABS). Azure Backup Server can now be installed on Windows Server 2022 with SQL Server 2022 as its database.... |
Reading Time: 3 minutes In this post I want to cover spreading your SQL Server wings with Azure SQL Edge. As part of a series of posts about... |
In prior articles we have covered how you can use Microsoft Purview as an inexpensive solution to grant read access to SQL’s system metadata information. You achieve this if... |
Demis Hassabis' view echoes those of Geoffrey Hinton, a giant in AI who now fears the tech he was seminal in developing. |
Computing in the Cloud (Azure, Google, AWS) |
In 2023, major banks, wealth managers, insurance companies, and other FS organizations are leaning heavily on public cloud for digital banking services. |
There are virtually no tools designed to help with cloud repatriation, so you are pretty much on your own. Here's a guide on what to think about when planning... |
Conferences, Classes, Events, and Webinars |
Join us for the second webinar in our PostgreSQL 101 series. As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time. Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL. |
In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more. |
In this article, learn about Puppet a tool to help... |
Active Directory Group Policies (GPO) enables you ... |
Learn how to import the Active Directory module in... |
Fun With PowerShell - Authoring Help |
Data Mining / Data Analysis |
Where do hammerhead sharks go at night? And perhap... |
On Wednesday, May 17, at 11 AM PT, @eWEEKNews will host its monthly #eWEEKChat. The topic will be Best Practices in Data Analytics, and it will be moderated by... |
The SAS 9 Content Assessment is a collection of applications that are designed to help users understand the various characteristics of their deployment. SAS Content Assessment delivers information that... |
Sharing my love letter to data which I penned as part of the Pythian “Love Letters to Data” series. |
As I have mentioned in prior blog posts, I have be... |
Learn about the process and principal components of building a data warehouse and learn about the five predominant architectures Independent Data Marts, Data Mart Buses, Hub-and-Spoke, Centralized Data Warehouses,... |
Database Design, Theory and Development |
To prevent unscheduled downtime, here are some bes... |
Clean, high-quality data is critical for business operations, but many companies have a data mess behind the scenes. Here’s how to clean and prevent unwanted data. |
New technologies like ChatGPT are all the rage, as they aim to answer questions and provide information that makes our lives easier. Yet, the validity of the results generated... |
DevOps and Continuous Delivery (CI/CD) |
If you are using SSDT for authoring, building, deb... |
There has been a lot of attention given to ChatGPT... |
Been playing with opencommit and wanted to assess... |
Defining different cloud costs can vary across providers, which is a challenge that the Google- and Microsoft-supported FinOps FOCUS specification aims to solve. |
SamoesA DIY 3D-printed a solution to keep his grap... |
Melanie Allen with BusKill has designed a 3D-print... |
TSMC has plans to establish a 28nm chip fab in Sax... |
Jo M is using a Raspberry Pi to record passing tra... |
When you need more breadboards, this project from ... |
We take you through a few methods to test RAM to s... |
Maker Glen Akins has repurposed an old aircraft ta... |
Backblaze has poured through its HDD failure rates... |
1upKeyboards has released two new Raspberry Pi Pico mechanical keyboard kits to build the DIY ortholinear keyboard of your dreams. |
Intel to describe benefits of PowerVia backside PDN with 4nm-class test chip. |
Microsoft has released a new email alerts feature ... |
I just completed a major refactoring of a piece of code inside RavenDB that is responsible for how we manage sorted queries. The first two tiers of tests all... |
Learn more about the new Optimizing DAX second edition video course: who should attend, technologies included, content organization, companion book, and much else! Course announcement: https://www.sqlbi.com/articles/optimizing-dax-second-edition/ Buy now: https://www.sqlbi.com/p/optimizing-dax-video-course/ |
Oracle/PostgreSQL/MySQL/other RDBMS |
Database and development teams often load data from plain text files into their MySQL databases. The files might be used to add lookup data, support test and development environments,... |
Performance Tuning SQL Server |
Tibor Karaszi builds a test: You have probably see... |
A Little About Trivial Plans In SQL Server Going F... |
A Little About Memory Grants In SQL Server Query Plans Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... |
PowerPivot/PowerQuery/PowerBI |
Thank you so much to those of you who were able to... |
Working with many companies that implement Power B... |
What happens in Power BI when you have row-level s... |
Remember Analysis Services? Maybe not for some of ... |
A convergence of events – including the global pandemic, a shift to remote work, and increased use of the cloud – has accelerated companies’ digital transformations over the past... |
I wish I'd read this blog post years ago.I don't h... |
As a DBA, your job involves much more than just ma... |
Today is a small but significant milestone in my c... |
I just released my 49th course on the learning platform Pluralsight. Building this new course Validate Data Cleanliness Using Asserts in Python, was fun. First appeared on Validate Data Cleanliness... |
In this article, we look at examples of non-linear relationships such as exponential, logarithmic, quadratic, and cubic using Python. |
A key law enforcement computer network has been do... |
New reporting from Wired reveals that the Departme... |
Strong password practices are important every day of the year. World Password Day is a chance to improve how we protect our our digital lives. |
Malicious packages are hard to avoid and hard to d... |
Oracle's characterization of the vulnerability in ... |
Being able to trace an incident backward from brea... |
Researchers find attackers are successfully evadin... |
Migrating Critical Traffic At Scale with No Downtime — Part 1Shyam Gala, Javier Fernandez-Ivern, Anup Rokkam Pratap, Devang ShahHundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive... |
T-SQL and Query Languages |
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial. |
In relational databases like SQL Server, the SQL J... |
This is a great opportunity and I am honoured to b... |
Formatting a date in SQL Server with the Z indicat... |
Learn about the different ranking functions in SQL Server along with how to use each of these: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE(). |
This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. Sometimes, as a reporter following climate technology,... |
Microsoft is removing the waitlist for its new AI-... |
Cybersecurity is a hotbed of startup activity, and... |
Tools for Dev (SSMS, ADS, VS, etc.) |
THE VIDEO THE SYNOPSIS In this video, we will talk... |
Step 1: go into Tools, Options and set this: Step ... |
One thing I enjoy about AI chatbots is that they c... |
Virtualization and Containers/Kubernetes |
This is a follow-up to my previous blog post I pub... |
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. |
|
|