| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Making the World Better Many of us that work in technology are blessed. We perform a job that requires creativity and intelligence. We don't have to work outside or engage in hard physical labor. We are well compensated, and we can do this job for many years. Certainly that's not true for everyone and there is plenty of stress, but compared to many construction trades, medical workers, and more, we have a good job. I believe in giving back to the world, both in time and money. Volunteering for causes that matter to you is a good way to spend some of your time. I hope everyone volunteers at some point in their life, and I also hope that you support those charitable causes that matter to you. This is the holiday season, with many celebrations across various cultures and religions. It is a time of the year that many of us donate a bit more, and I was reminded of that this week. Denny Cherry and Associates Consulting has published a post where they will donate to a cause if you view the post. Their cause of the Elizabeth Glaser Pediatric AIDS Foundation. They also have a link where they will match your donation if you click through and donate yourself. This isn't a cause I normally think about, but I do think it's good to take extra care of children, so I donated myself. If you believe in this cause, then please think about adding your own funds. If you have other causes, local or otherwise, take a minute today and think about if and how you can support them this year. 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 |
| Before you commit your Flyway migration files, you may want to run some automated checks for style or 'code smells'. This article demonstrates how to run basic cross-RDBMS code quality checks using SQL Fluff. We analyze the results in PowerShell to produce reports and analytics on the number or types of issues found. |
| Over time data in SQL Server tables needs to be modified. There are two major different aspects of modifying data: updating and deleting. In my last article “Updating SQL Server Data” I discussed using the UPDATE statement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use the DELETE statement to remove rows from a SQL Server Table. |
| AI/Machine Learning/Cognitive Services |
| Azure Machine Learning (or Azure Machine Learning Service and abbreviation AML) is Azure’s cloud service for creating, managing and productionalising machine learning projects. It is a collaborative tool for... |
| The explosion in text-to-image AI models like OpenAI’s DALL-E 2—programs trained to generate pictures of almost anything you ask for—has sent ripples through the creative industries, from fashion to... |
| If you remember in part 2 we discussed what Key Wo... |
| In this post, I'll show you multilingual (Japanese... |
| OpenAI has built the best Minecraft-playing bot ye... |
| Administration of SQL Server |
| In SQL Server 2022, we have introduced a method of... |
| Issue An issue was noticed recently while enabling... |
| What’s the best way to avoid most blocking issue... |
| We all (should) know that running SQL Server in hy... |
| It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With... |
| Azure Databricks, Spark and Snowflake |
| This blog post is not about which User Interface i... |
| Azure SQL Managed Instance |
| In this blog that is continuation of #sqlmiops series, we will present a feature for moving Azure SQL Managed Instance from one to another subnet located in a different... |
| This article covers how to deploy, configure and test the managed instance version of Azure SQL Database using the General-Purpose edition. |
| Career, Employment, and Certifications |
| In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for over a year. In 2023 I’ll be mentoring ?… Why do I... |
| IT managers will need to harness the power of team... |
| This month the fine folks behind New Stars of Data and the DataGrillen Newcomer Track bring us the Tell Your Story blog party. Where we The post Tell My Story... The... |
| As DCAC has done in prior years we are looking for your help with our donation program to the Elizabeth Glazer Pediatric AIDS Foundation. As today, December 1, 2022,... |
| (The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something... |
| Since the launch of The Redgate 100, we’ve been ... |
| Computing in the Cloud (Azure, Google, AWS) |
| As today’s analytics landscape evolves with impr... |
| When updating databases, using a blue/green deployment technique is an appealing option for users to minimize risk and downtime. This method of making database updates requires two database environments—your... |
| Way back in 2009 I wrote Introducing Amazon RDS – The Amazon Relational Database Service and told you that: RDS makes it easier for you to set up, operate,... |
| Since we launched AWS Database Migration Service (AWS DMS) in 2016, customers have securely migrated more than 800,000 databases to AWS with minimal downtime. AWS DMS supports migration between... |
| AWS VP and Chief Evangelist Jeff Barr, plus a select group of AWS Developer Advocate colleagues, have personally chosen their picks for some of the most impactful and exciting... |
| Conferences, Classes, Events, and Webinars |
| Copy: However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them. Start learning. |
| Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop. |
| Data Privacy, Compliance, and Governance |
| Many companies have been criticized in recent years for mismanaging data. For example, a major social media conglomerate recently came under fire for reports that user data was accessible to employees,... |
| A SAS programmer was trying to simulate poker hands. He was having difficulty because the sampling scheme for simulating card games requires that you sample without replacement for each... |
| ETL/SSIS/Azure Data Factory/Biml |
| The title of this blog post is a bit misleading, b... |
| This year's Black Friday CPU deals make this the b... |
| ISSUBTOTAL: Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise. https://dax.guide/issubtotal/ |
| Microsoft has recently announced the general availability of Windows Update... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| In this blog, we compare two of the most popular t... |
| A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The data returned by the subquery is passed into the DML statement... |
| In this article, we will learn about different types of PostgreSQL joins with examples. Introduction Data is generally hosted in a variety of data management repositories, one of them... |
| Performance Tuning SQL Server |
| PowerPivot/PowerQuery/PowerBI |
| After a series of exciting Power Platform announcements from Ignite... |
| Table partitioning has long been an important task... |
| Power BI is architected to consume data in a dimen... |
| One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI... |
| Multifactor authentification is crucial for creati... |
| Though there have been fewer than expected publicly reported attacks involving the vulnerability, nearly three-quarters of organizations remain exposed to it. |
| Laptop technicians routinely violate the privacy of the people whose computers they repair: Researchers at University of Guelph in Ontario, Canada, recovered logs from laptops after receiving overnight repairs from... |
| T-SQL and Query Languages |
| Check out this article to help you figure out real dates and times when using a SQL Server RowVersion value. |
| This article will show different SQL timestamp fun... |
| The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and... |
| Fun With KQL - Percentiles |
| Today, we announced the preview release of Amazon CodeCatalyst. A unified software development and delivery service, Amazon CodeCatalyst enables software development teams to quickly and easily plan, develop, collaborate... |
| Earlier this month, Microsoft rolled out a new set... |
| Virtualization and Containers/Kubernetes |
| This article describes the steps you take to prepare the VMware infrastructure for installing and configuring a high-availability SAP ASCS/SCS instance on a Windows failover cluster by using SIOS... The... |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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. |
|
|
