| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Practical IOT A lot of the IoT devices that make the news are consumer ones, many of which can feel silly and trivial to many of us. How many of us find a lot of value in toasters, cat litter boxes, or deodorant? Even light bulbs feel slightly silly to me as I don't know I've every been concerned about switching a light that I couldn't get to physically in my house. Then again, I don't try to set up holiday light displays. In the last few years, however, I've seen some interesting talks on how more business or government IOT devices have really changed a number of businesses. The ones I've found that give me hope for a better future are often local government initiatives where the investments and changes are in gathering data from sensors and using those to service citizens. This week I ran across an article about how the city of Phoenix, AZ in the US is using IoT to improve livability. If you have never been to Phoenix, it's in the desert, and it gets hot. So hot that you can burn your feet walking around barefoot. Sometimes it's not enough to literally cook an egg on a paved surface. One experiment they ran used sensors to measure how different surfaces held heat, and they used the results to try and manufacture tarmac materials that would lower the temperatures. Still hot, but less dangerously so. They have also implemented drones for us in search and rescue as well as fire operations. This is the type of device that can literally save lives and prevent costly damages. The use of technology and IoT is something that has the potential to bring about better service, often in ways that weren't possible in the past. I like that there are people using innovative ideas and products to improve the world. Hopefully we see more of this in the future as more people realize the power of data and the availability of it from new types of sensors and devices. 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 |
| In the previous two articles in this series, you learned about SELECT and INSERT, two important data manipulation language (DML) statements in MySQL. In this article, I focus on the UPDATE statement, another valuable DML statement in MySQL. |
| AI/Machine Learning/Cognitive Services |
| As more industries leverage artificial intelligence to support vertical-specific operations, many without experience in managing a virtual agent may soon do so. Just last year, for example, investment in... |
| To receive The Algorithm newsletter in your inbox every Monday, sign up here. Welcome to the Algorithm! This year we’ve seen a dizzying number of breakthroughs in generative AI, from... |
| Administration of SQL Server |
| Issue A backend compatibility issue was encountere... |
| What is index fragmentation and how does it occur? It is important to know that SQL Server data is stored in data pages, with each page holding 8KB of... |
| Azure Databricks, Spark and Snowflake |
| In this article, we will look at how to use an Azu... |
| Cloning is a powerful feature within snowflake (al... |
| Introduction In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure... |
| When you enable Auditing on Azure SQL, you can select a storage account as destination. One interesting option to consume these audit logs is to use "Merge Audit Files" option... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| While working with a customer, they had a requirement to restore modified files to a specific point in time. They had built their architecture on top of a Data lake. |
| Career, Employment, and Certifications |
| While automation has transformed the way IT operat... |
| I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in... The... |
| At the PASS Data Community Summit, Thursday is the... |
| Computing in the Cloud (Azure, Google, AWS) |
| This article will show the basics of hosting MySQL... |
| Here are three suggestions to help organizations f... |
| Technical issues are hindering organizations' cloud operations, according to Forrester Research's recent "Top 10 Trends in Cloud" report. |
| Conferences, Classes, Events, and Webinars |
| There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Register now. |
| Spaces are still available for this month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now. |
| There's only a couple of days until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Register now. |
| Learning Common Table Expressions is one of my favorite classes, with over 8 years of prep time for this course, including presentations at live conferences, writing a book on... |
| Join Azure SQL Managed Instance Product Group team at PASS Data Community Summit 2022. This year we are bringing 14 sessions in total with 1 full day workshop, 4 live sessions (where one... |
| PowerShell 7 is the successor to PowerShell 5.1. It’s fast, reliable and it is cross-platform. Without a doubt, PowerShell 7 is the future. You can install PowerShell 7 on... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
| According to IDC, the amount of digital data created over the next five years will be greater than twice the amount of data created since the advent of digital storage. Mirroring this sentiment, Statista... |
| ETL/SSIS/Azure Data Factory/Biml |
| Data quality issues have been a long-standing challenge for data-driven organizations. Even with significant investments, the trustworthiness of data in most organizations is questionable at best. Gartner reports that... |
| Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick... The... |
| Microsoft’s Surface Laptop 5 ditches AMD for an ... |
| Storage specialist Solidigm's roadmap features a high-capacity SSD treat for those looking to accelerate their storage subsystems, and hastens the death-knell for HDDs in all but the most specific... |
| We tested Thermalright’s AXP120-X67 and were surprised to find it can handle Intel’s i9-13900K in most scenarios, despite it’s small size. |
| We put Intel's new 13th-Generation Raptor Lake Cor... |
| Samsung now mass produces 8th Gen V-NAND: 1Tb 3D T... |
| Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this video, we introduce this optimization with some examples. |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| In this blog, we will walk you through the basics ... |
| For PGSQL Phriday #002, Andreas Scherbaum asked us to consider PostgreSQL backups, how we do them, any recommendations we have, and whether pg_dump is a backup tool. |
| It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. |
| Pat Wright talks about the importance of thinking through your backup process. |
| Performance Tuning SQL Server |
| Can SQL Server piece together two different indexes in a single-table query, rather than just giving up and scanning a suboptimal clustered index? The short answer is: yes, in... |
| PowerPivot/PowerQuery/PowerBI |
| Learn how to implement an incremental refresh for ... |
| Power BI table visuals with a visual-level filter ... |
| Learn how to upgrade your ribbon charts to prioritize the rank between categories. We'll use a bit of DAX magic mixed with some Calculation Group wizardry to achieve this... |
| In this article, we look at how to use different user types to display or hide data in a Power BI report based on SQL Server login credentials. |
| If your Power BI dataset is too large you may run into errors when you refresh. |
| Product Upgrades and Releases |
| If you’re interested in getting a digital copy, ... |
| Assess, get right-sized Azure recommendations for Azure migration targets, and migrate databases offline from on-premises SQL Server to Azure SQL Database. |
| I am pleased to announce today the opening of our 28th AWS Region: Europe (Zurich), also known by its API name: eu-central-2. An AWS Region allows you to deploy... |
| New public preview features include reading Delta Lakes in fewer steps, debugging and monitoring training jobs, and performing data wrangling. |
| New GA features include the ability to automate auto-shutdown/auto-start schedules, configure and customize a compute instance, seamlessly build NLP/vision models, and assess AI systems. |
| Intra-account container copy helps you create offline copies of containers within Azure Cosmos DB SQL API and Cassandra API accounts. |
| Azure Automation now supports Availability zones to provide improved resiliency and reliability to the service, runbooks and other automation assets. |
| In version 161 of SqlPackage and DacFx some default connection settings have changed to improve the default security of database connections. In this article we will focus on these changes... |
| You can now save on Virtual Machine software from third-party publishers by purchasing software reservations. |
| Deprecation notice: transition from Azure MFA Serv... |
| It is long overdue, but time for a new updated version for the Power BI Model Documenter external tool! The latest release lasts from the first week of 2022... |
| When addressing somebody unknown to you with an un... |
| Google Trends is a website by Google that analyzes the popularity of top search queries in Google Search across various regions and languages |
| SQL Server Security and Auditing |
| Learn about the new dynamic data masking features in SQL Server 2022 to control data masking based on user permissions. |
| Cloud storage databases, often deployed as "rogue ... |
| Security logging can help organizations recover from ransomware attacks – and even negotiate with attackers. |
| What quality makes code production-grade? That’s the question posed by Tom Zika in this month’s edition of T-SQL Tuesday. I don’t believe there’s a “right” answer to this question... |
| It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading |
| T-SQL and Query Languages |
| For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality." |
| Reading Time: 3 minutes For this months T-SQL Tuesday contribution I want to explain why you should think twice about your comments when writing code. Because you never... |
| This month’s T-SQL Tuesday is hosted by Tom Zika. Tom’s topic is a good one: “Which quality makes code production grade?” I can hear data minds thinking, “It depends.”... |
| Happy T-SQL Tuesday, everyone! I’ve missed the past couple of ones but I’m happy to jump back in. This month, Tom Zika (t | b) asks us to talk... |
| In publishing, and Im sure many other industries, ... |
| 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... |
| Introduction A very common need in query languages is the ability to extract the maximum and minimum values in a column of data. The Kusto Query Language provides this capability... |
| In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I... |
| Plaintiffs are asking for at least $9 billion in d... |
| The 2021 external audit concluded that Twitter had appropriate safeguards. Months later, Twitter's cybersecurity chief had left and alleged the company's practices were marred by “egregious deficiencies.” |
| At IoT World Austin 2022, city officials showcased... |
| McDonald's UK is giving away a gaming chair that holds your fries and dip and warms your McCrispy Chicken Sandwich. |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| 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. |
|
|
