| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| The 2022 Preview This was a strange week for me. Traveling in Brussels with my wife and prepping for a few presentations. Then Techorama, an even more 2019-era conference in Belgium where I spoke around a few customer calls sprinkled in during the week. I have a new SQL Saturday I was trying to get scheduled, while coordinating with my doctor for a surgery Friday, and keeping up with some travel plans for the next month. In the middle of all that, Microsoft Build took place this week. Needless to say I didn't see any presentations from the event, but I did see quite a few blog posts and entries this week from various MVPs and others. I took a few minutes to watch Data Exposed, and I read a few posts. I liked the thoughts from Paul Andrew on the Intelligent Data Platform. He is more of a BI person, and I think a lot of the evolution of the platform is moving to add more BI and get more intelligence from the database for customers. I've been playing with the CTP lightly for a few months. Many of the MVPs have as well, and while most things work the same, there are some new things that might be useful in your workload. You can get the CTP of SQL Server 2022 at https://aka.ms/getsqlserver2022, and see what's changed, test your current apps, and in general get excited about the future of SQL Server. If you want some ideas and demos to follow around, check out Bob Ward's demos at https://aka.ms/bobsqldemos. He's put his various scripts and notebooks for the platform, where you can reproduce and examine some of the features. Bob has been showing off some of these things at various conferences for awhile, and now you can get his code to do some testing. Aaron Bertrand also has a number of posts on SQL 2022. As always, if you find issues, send in feedback. MS does read this stuff, and while they don't always agree with you or I, they do consider things. The more you put the reason you want a change in business terms, the better off things are. Rather than saying "an empty CATCH clause hides an error", you might say that "the empty catch clause was unexpected and caused clients to resubmit a form 22 times before customer service could track down a bug." Be specific and show a relation to a tangible business problem for all your errors. In many ways SQL Server is a very mature product for me. The core engine meets most of the needs I have for SQL Server Central as well as those of many of my customers. However, there are lots of organizations that might benefit from one or more of these features. Whether on premises or in the cloud, we want the platform to grow and improve. Plus, it can be exciting to reproduce one of Bob's demos and learn something. As we move towards a new version of SQL Server, take a little time to get excited about technology and see what changes are coming in SQL Server and the Data Platform. 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. |
| AI/Machine Learning/Cognitive Services |
| A data lake becomes a data swamp in the absence of comprehensive data quality validation and does not offer a clear link to value creation. Organizations are rapidly adopting... |
| As companies address ethical concerns about AI systems, they run the risk of glossing over complex questions. |
| Knowledge is power. And the data that you collect in the course of your business activities, whether that’s information about the efficiency of your production line or statistics on... |
| Administration of SQL Server |
| How to filter SQL Server logins mapped to a specif... |
| Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes called initializing, preparing or data sychronization) process. Seeding is a size of operation-based data, copying... The... |
| I am a heading Some events: event_name memory_grant_feedback_percentile_grant memory_grant_feedback_persistence_update parameter_sensitive_plan_optimization process_killed query_optimizer_nullable_scalar_agg_iv_update spinlock_backoff sql_exit_invoked tsql_feature_usage_tracking A bunch of stuff: package_name event_name description qds automatic_tuning_query_check_ignored Fired when APRC decides to not track a query that is marked as ignored qds automatic_tuning_wtest_details … |
| Brand New Here are new sys.configuration entries in SQL Server 2022: +------------------------------------+-------------------------------------------------------------------------------------+ | name ... |
| Visual Studio team added Azure Cosmos D... |
| Azure Databricks, Spark and Snowflake |
| In this article we explore how to use transactions and a comparison of transactions in SQL Server versus Snowflake. |
| Build your next app on Azure SQL Database Azure SQL Database is a relational database service built for the cloud. Built upon the powerful SQL Server engine, you can use... |
| Data loss prevention is a major concern with all customers who would like to have granular control over their data and how it gets exported from their databases on... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| Not sure where to begin with Azure Synapse Analytics? Patrick gets you started and teaches you the clicks to get up and running quickly! Get Started with Azure Synapse... |
| Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.… The post Azure Synapse Link for SQL: From production to a data warehouse... |
| In this article, we will learn what is an Azure Lake Database conceptually, and the different components of this solution, followed by its practical implementation in upcoming articles. Introduction... |
| Career, Employment, and Certifications |
| I talk about some of the things I do to be more productive, and hopefully some of these can help you in your role, too. |
| Microsoft has unveiled enhancements coming to the Learn platform during... |
| As IT professionals adjust their hybrid work strategy through a series of trial and error, they'll need to focus on change management and user feedback. |
| An overview of my Chief Data Officer certificate experience at Carnegie Mellon. |
| Computing in the Cloud (Azure, Google, AWS) |
| Introduction The PASS 2022 Data Community Summit o... |
| Private cloud computing is by no means disappearing, but the buzz around it isn't what it once was. Here's why. |
| Recently, I came across a question where a user wanted to test Private endpoint connectivity from Azure Data Factory ( ADF) to Azure SQL Database. The Azure SQL server... |
| Data Mesh Radio Interview Context Last month I joined Scott Hirleman (@DataProductScot) on the Data Mesh Radio Podcast. With no expectations we agreed on the below talking points and... |
| Conferences, Classes, Events, and Webinars |
| At the PASS Data Community Summit in Seattle on N... |
| I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately hit bad traffic, all four lanes of I-4 blocked that resulted in a 30 minute... The... |
| I am honored to deliver a full day pre-conference session at the PASS Data Community Summit 2022! My precon is titled “A Day of Azure Data Factory.” Register today!... |
| PASS have announced the Summit community pre-conference sessions and speaker lineup! Choose from 14 pre-cons featuring Brent Ozar, Kimberly Tripp, Melissa Coates, Itzik Ben-Gan, Denny Cherry, and others, taking place on Monday Nov. 14 and Tuesday Nov. 15. Full-day pre-con sessions will cover topics including database performance tuning and troubleshooting, T-SQL querying, DAX, security, cloud VMs, Azure Data Factory, Azure infrastructure, parameter sniffing, Power BI, PostgreSQL, equity toolkits, and much more! |
| You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous... |
| I recently read a terrific post from Mike F. Robbins about using Format-Wide to display strings. Format-Wide is one of those cmdlets that I don’t think gets much use.... |
| In this article, we will review PowerShell For loops, While... |
| In this article we learn about the basics of PowerShell cmdlets, what they are, how to use them and what is available specifically for SQL Server. |
| Data Mining / Data Analysis |
| Data sharing is a hot topic. Multiple analysts and consultancies have been featuring data sharing as one of the key enablers to successful business partnerships and accelerated growth. Both Gartner and McKinsey have... |
| Data Privacy, Compliance, and Governance |
| As states address privacy with ad-hoc laws, corporate compliance teams try to balance yet another set of similar but diverging requirements. |
| Even though the European Union’s General Data Protection Regulation (GDPR) went into effect four years ago and a hundred other countries have adopted stringent data privacy laws, the U.S. is lagging... |
| T-learners, S-learners and X-learners are all meta... |
| Through virtual and in-person workshops around the globe, we have taught tens of thousands of people how to communicate effectively with data. This series captures some of the noteworthy... |
| In this article learn how to make decisions about when to buy and sell a financial security using Candlestick Chart values, T-SQL and SQL Server. |
| Database Design, Theory and Development |
| Note: To demonstrate the correctness and stability... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
| Graph databases and models have been around for well over a decade, and are among the most impactful technologies to emerge from the NoSQL movement. Graph data models are... |
| HA/DR/Always On/Clustering |
| In this article we continue building Distributed Availability Groups to migrate SQL Server databases to a different Active Directory domain. |
| Contained availability groups are here. Learn more about them. The post Contained Availability Groups in SQL Server 2022 appeared first on SQLHA. |
| We've tested dozens of external hard drives and SS... |
| OS-independent XTS-AES 256-bit encrypted device un... |
| Introduction During a Computex 2022 Keynote on May 23, 2022, AMD CEO Dr. Lisa Su revealed some interesting new AMD Ryzen 7000 processor information. Here is her presentation: Unfortunately,... |
| FIRSTDATE: Returns first non blank date. https://dax.guide/firstdate/ LASTDATE: Returns last non blank date. https://dax.guide/lastdate/ |
| PARALLELPERIOD: Returns a parallel period of dates by the given set of dates and a specified interval. https://dax.guide/parallelperiod/ |
| I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete... |
| Microsoft has announced the release of Windows Server 2022 build... |
| My Thoughts Following MSBuild 2022 The MSBuild conference was excellent. The effort Microsoft put into making the experience work across time zones, in different languages and hybrid (in person/online)... |
| Microsoft has unveiled a couple of security improvements to Azure... |
| There's yet another new Microsoft platform in town: The Microsoft Intelligent Data Platform. Here's what this is and why app developers, chief data officers and IT pros should take... |
| Microsoft fixes Windows 10 to fix Microsoft Store ... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security.… The post Security in MySQL: Part Two appeared... |
| Performance Tuning SQL Server |
| Bestest If we want to start this post in the right place, we have to go back to 2009. That was the first time a (much) young(er) Erik Darling wrote... |
| Manifesto This is a problem I deal with quite a bit when helping people track down performance problems and, you know, solve them. The basic scenario is something like this: CREATE PROCEDURE ... |
| PowerPivot/PowerQuery/PowerBI |
| Have you noticed some extra queries being sent when using Incremental Refresh in Power BI? Patrick explains why this could happen and a potential workaround. Privacy Levels: https://docs.microsoft.com/power-bi/enterprise/desktop-privacy-levels The post... |
| ABSTRACT At the end of last year, one called... |
| Power BI Datamart is integrating well with other components of the Power BI ecosystem (such as workspaces, sharing, deployment pipelines, endorsements, sensitivity labels, etc). In this article and video,... |
| One of the newest additions to the Power BI components is the Datamart. Power BI Datamart is more than just another feature, it is a major milestone where the... |
| Use object level security and field parameters to ... |
| In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The transformations will perform better if they can be converted... |
| This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. IMPORTANT: while this feature is in preview, you must enable it... |
| This video analyzes the dynamic parameters feature in Power BI, unveiling some of the internals of its implementation. IMPORTANT: While this feature is in preview, you must enable it... |
| Product Reviews and Articles |
| This book aims to help you reduce your Azure costs, how does it fare? |
| Product Upgrades and Releases |
| Microsoft Purview Data Estate Insights (in GA July 1, 2022) provides a bird's eye view of your data estate's health. |
| Enable proof that your database has not been tampered with and restore it back to the original value if needed by enabling ledger in Azure SQL Database. |
| Simplify and expedite application development and reduce time-to-market with new features for Azure SQL Database. |
| Run your production workloads on the Business Critical service tier, best for high-performance transactional or analytical applications and achieve a 1.5x performance improvement over Single Server on open-source community... |
| Azure Database for MySQL Flexible server is now offering 80 vCore compute for tier 1 workloads. |
| Moving data to and from AWS Storage services can be automated and accelerated with AWS DataSync. For example, you can use DataSync to migrate data to AWS, replicate data... |
| Azure Virtual Machine backup protects Write Accelerator enabled disks |
| Autoscaling allows you to define the minimum and maximum streaming units. Stream Analytics will automatically take care of dynamically optimizing the number of streaming units needed for your workload. |
| I am excited to share the latest release of SSIS C... |
| I am excited to announce that Amazon Elastic Compute Cloud (Amazon EC2) C7g instances powered by the latest AWS Graviton3 processors that have been available in preview since re:Invent... |
| Building your own executable Python applications i... |
| This tip extends prior coverage of candlestick charts by taking advantage of financial time series data stored in SQL Server and charted via Python. |
| The malware’s abuse of PowerShell makes it more dangerous, allowing for more advanced attacks such as ransomware, fileless malware, and malicious code memory injections. |
| Organizations must ensure their kubelets and relat... |
| Insider threats have grown more rampant following the widespread adoption of remote workforces. Learn how to boost your company’s insider threat prevention efforts. |
| Microsoft has published an advisory about a distributed denial-of-service (DDoS)... |
| The PyPI "pymafka" package is the latest example of growing attacker interest in abusing widely used open source software repositories. |
| T-SQL and Query Languages |
| Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL batches. This functionality allows you to store and manipulate JSON documents in... |
| A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical... |
| Itzik Ben-Gan dives deep on two of the more interesting T-SQL enhancements in SQL Server 2022: the new WINDOW clause and the windowing NULL treatment clause. The post T-SQL Windowing... |
| The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.… The post The VALUES clause... |
| The deal is the biggest takeover ever for a chipmaker and extends an acquisition spree for Broadcom CEO Hock Tan, who has built one of the largest and most... |
| Non-volatile random-access memory, or NVRAM, is increasingly a technology to watch. Learn about how NVRAM works, use cases, and more. |
| In this article, I’m going to show you how to... |
| With rapid business expansion often comes data siloing, where one department doesn’t share its data with any of the others. While this may be noticed and fixed quickly in... |
| Microsoft has announced a new custom virtualization solution called “Microsoft... |
| At the BUILD developer conference today, Panos Panay said third parties will be able to start building Windows 11 widgets as companion experiences for Win32 and PWA apps later... |
| A good password manager is secure, seamless, and s... |
| Back in 2015 Intel, went through a significant res... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| Life can be easier when you block out the noise an... |
| 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. |
|
|
