| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Happy Birthday USA! This is the Fourth of July weekend here in the US when we celebrate the birth of the country based on the publication of the Declaration of Independence. For those who don't know, this celebration mostly consists of fireworks and outdoor cookouts. However, at our house we've always tried to do a little bit more with a focus on history. In the past we've visited various museums (lots to choose from where I'm currently located in Massachusetts, birthplace of the revolution) and took part in community projects, stuff like that. While I love my country, I know that you probably love yours. I've visited quite a few other countries at this point, and frankly, there's a lot to love about them. The one thing I really like to do before I visit a new country is read about its history. I just feel like a good understanding of where people came from helps to understand where they are. Plus, it makes it easier to pick & choose which cities to visit, and what museums or sites to see when I go. It's those stories from history that really tell you about how a place came to be. They're frequently fascinating and entertaining. So, this weekend, whether you're in the US or not, I'd like to suggest you take a few moments and appreciate the history of your place, wherever it is. While we're at it, maybe see if there's a little volunteer work you can do to help preserve that history. Protect your story and share it with others. 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 |
| How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error. |
| A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code. |
| AI/Machine Learning/Cognitive Services |
| I recently was a part of GestaltIT’s AI Field Da... |
| This article will show how to source data from Azu... |
| Click to learn more about author Juras Juršenas. Not all machine learning applications have been met with resounding success. In fact, there’s a lot of disappointment involved. From overly... |
| Administration of SQL Server |
| In this article, we are learning about the sp_help... |
| This is a quick non-technical discussion (i.e. not... |
| SQL Server Transactional Replication is one of the... |
| One of the biggest differences between the Data Me... |
| Introduction These are my SQL Server Diagnostic In... |
| First, you need to be sure that ... |
| This article will restore a Transparent Data Encry... |
| When using a Geo Replicated Azure SQL Database Re... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.… The post How to query blob... |
| Computing in the Cloud (Azure, Google, AWS) |
| With bare-metal cloud computing, customers get alm... |
| The next generation of cloud is here: Here's how organizations can take advantage of it to advance their business objectives. |
| Linkerd, considered the easiest to use open source service mesh, just got easier with Buoyant Cloud's Service Mesh as a Service. |
| I just finished an interview with a friend for a blog post where he was surprised how differently I was Tags: AWS, azure, GCP, oracle Del.icio.us Facebook TweetThis ... |
| Measuring the impact of cloud computing is about more than just figuring out the cost per compute for a given hour – it's about optimizing IT operations. |
| Microsoft is acquiring AT&T’s Network Cloud technology and staff as part of a deal to eventually handle all of the wireless carrier’s 5G traffic. |
| Conferences, Classes, Events, and Webinars |
| The Best of Summit 2020 series is now live! This curated series features a selection of the most-viewed content from PASS Virtual Summit 2020 to help you find relevant data platform training related to this year’s conference tracks. Best of Summit 2020 includes sessions from some of the top speakers in the data industry including Erin Stellato, Andy Yun, Melissa Coates, Pinal Dave, Hamish Watson, and many others. |
| Data Mining / Data Analysis |
| With the ubiquity of online survey services like S... |
| Click to learn more about author Avee Mittal. Advances in Internet of Things (IoT) systems are increasingly facilitating data collection and information transfer over the IoT network to provide... |
| Three years ago, we challenged you to create a square area or waffle chart. Many who completed that challenge commented that this was their first time making a square... |
| Start small with OKR to see whether OKR systems--and OKR itself--are right for the organization. |
| Click to learn more about author Matt Tanner. Knowledge graphs aren’t new, but they’re the latest and greatest trend as people and companies realize just how versatile they are. Whether... |
| ETL/SSIS/Azure Data Factory/Biml |
| On 2nd June 2020 Apress reached out to me about th... |
| (2021-Jun-30) One of my university professors lik... |
| Sage business thinkers have long espoused the valu... |
| Performance Tuning SQL Server |
| The article could be named, “How to use up all o... |
| Monitoring SQL Server for performance is a critica... |
| PowerPivot/PowerQuery/PowerBI |
| It’s surprisingly easy to stop query folding hap... |
| I wanted to announce a brand new DataCamp course, ... |
| With Log Analytics integration in Power BI, you ca... |
| Product Upgrades and Releases |
| Data science, machine learning, and analytics have re-defined how we look at the world. The R community plays a vital role in that transformation and the R language continues to be the de-facto choice for statistical computing, data analysis, and many machine learning scenarios. |
| SQL Server Migration Assistant (SSMA) is a suite of 5 tools designed to automate migrations from Oracle, Access, DB2, MySQL and SAP ASE (formerly SAP Sybase ASE) to Microsoft SQL. It automates the conversion of database schemas to a Microsoft SQL Server schemas, deployment of the schemas, data migration to the target SQL Server (see below for supported versions), and validation of migrated objects. |
| While we are clearly beginning to see in-person ev... |
| The world of data is changing, and changing fast. ... |
| As ransomware becomes more common, I’m seeing more discussions about the ethics of paying the ransom. Here’s one more contribution to that issue: a research paper that the insurance... |
| “The FBI has definitely decided to be more aggressive,” said Elvis Chan, the assistant special agent in charge of cyber investigations in the FBI’s San Francisco field office, in... |
| Two reports this week. The first is from Microsoft, which wrote: As part of our investigation into this ongoing activity, we also detected information-stealing malware on a machine belonging to... |
| There is an increasing need for software developers to provide an accurate accounting of the components that make up a given application. |
| This is part 12 of a 19 part series on TSQL Basics... |
| In early 2011 Jes Borland invited us to write abou... |
| Work Off While helping a client out with weird per... |
| Another post for me that is simple and hopefully s... |
| Whiffle Ball How you do date math in a where clause matters, because wrapping a column in any sort of expression can really hurt your query performance. The thing... |
| This is part 13 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and... |
| In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database. However, SQL Developer Web has its... |
| A year into the covid-19 pandemic, Apple commemora... |
| For Apple, Amazon, Facebook, and Alphabet, covid-1... |
| Not all astronauts start off as test pilots. I spo... |
| Musk expects near-global coverage in August and up... |
| Slack Huddles, one of the new tools, will let users have casual audio conversations across channels and direct messages on the workplace communications platform. |
| Space agency needs to know exactly what's wrong in order to switch to backup hardware. |
| Danish antiquarian Ole Worm conducted the first survey of the Kalvestene in 1650. |
| "I truly believe that space belongs to all of us." |
| The computer scientist Marijn Heule is always on the lookout for a good mathematical challenge. An associate professor at Carnegie Mellon University, Heule has an impressive reputation for solving... |
| "I am not allowed to talk about that." |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| The Azure SQL Databases don’t give us access to ... |
| Troubleshooting a slow restore using Extended Events |
| As part of a long game on deprecated SQL Server fu... |
| If you need to manage multiple code analysis setti... |
| A developed asked me how to recover scripts after SSMS crashed |
| Virtualization and Containers/Kubernetes |
| Thanks to its container customer training, the $1 ... |
| 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. |
|
|
