| The Complete Weekly Roundup of SQL Server News | Hand-picked content to sharpen your professional edge |
| New Stuff Can Be Scary I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's all fun. Then, there's being the net controller. This is the person who has to check everyone into the computer program to track them. So, you're operating the computer and the radio. Plus, on HF, there's this thing called a pile-up where lots of people broadcast over the top of each other. You have to pluck individual voices out of the mix and get their call signs. Also, you have to follow the scripts for checking people in, controlling the net, and more. You also have to do all this while still sticking to the law when it comes to broadcasts. And if you screw any of this up, you could be messing up people's chances at an award. In short, I'm a little terrified. However, learning and expanding your knowledge and skill set are vital. And yeah, learning new stuff and taking on new responsibilities can be scary. It's just a part of expanding what you do. It's no different from learning AWS, Azure ML, or some other technology. Sure, using it and learning it can be fun. Then, you have to implement it into production and your business is going to use it. That's scary. Just because we're scared of the new technology, new methodologies, and expanded capabilities, that's no reason not to embrace them. As with fear in general, it's not a question of whether or not your scared, but how you deal with it. 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. |
AI/Machine Learning/Cognitive Services |
Researchers have spent years trying to crack the mystery of how we express our feelings. Pioneers in the field of emotion detection will tell you the problem is far... |
The explosive successes of AI in the last decade or so are typically chalked up to lots of data and lots of computing power. But benchmarks also play a... |
Snapshot backup tools like Azure Site Recovery and Veeam are great for sysadmins. They let you quickly replicate a virtual machine to somewhere else without knowing too much about... |
TL;dr Trace flag 2549 is no longer required for checkdb or checktable in SQL Server 2016++. Trace flag 2562 may still benefit checkdb on a system (depends on disk... |
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a... |
Azure SQL Managed Instance |
Azure SQL Managed Instance is a fully managed, secure, and always up-to-date SQL instance in the cloud, providing an ideal destination for modernizing your SQL Server applications at scale. SQL Managed Instance is part of the Azure SQL family of database services which include virtual machines and managed databases. Since its inception, Azure SQL Managed Instance (SQL MI) has been continuously improved based on customer feedback, aiming to meet critical requirements of organizations that migrate and modernize their applications in Azure. |
Azure Synapse (SQL Data Warehouse and Data Lake) |
There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and... The... |
Career Growth and Certifications |
I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are... |
Community Interests and PASS |
If you saw any of my angry tweets last night, it’s not just because the Saints weren’t good. I’ve been writing a lot about PASS and C&C the for-profit... |
Computing in the Cloud (Azure, Google, AWS) |
I use Azure VMs quite often for trying things out, especially when tech reviewing articles for my day job as editor of Simple Talk. Frequently, a special purpose VM... |
No matter what you need, Azure probably has a solu... |
Sorry for spammy, SEO title, we got to pay the bills. Sometimes it’s fun to just write some code to solve problems, and not think about the world’s larger... |
Conferences, Classes, Events, and Webinars |
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview of my session at VMworld 2020 called Hybrid Cloud Architecture for SQL Server Workloads: Deep... The... |
Aaron Bertrand talks about a new project involving parsing the default values for parameters out of stored procedure and function bodies. The post Parse parameter default values using PowerShell –... |
Data Privacy, Compliance, and GDPR |
At first glance, encryption may seem like a one-step solution to protect sensitive data in the software development lifecycle. In this post we share why reality is not so... |
Many privacy advocates oppose Prop 24, which would buttress consumer privacy. |
View COVID data as easily as you view traffic or satellite data. |
DevOps and Continuous Delivery (CI/CD) |
A very common tenet used when building out a DevOp... |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
Click to learn more about author Bassam Chahine. Redis, which stands for “REmote Dictionary Server,” is a speed-optimized in-memory data store most often used as a cache. Redis has... |
ETL/SSIS/Azure Data Factory/Biml |
Azure Data Factory is a cloud based data orchestra... |
Portable flash-based storage solutions are one of the growing segments in the direct-attached storage market. The emergence of 3D NAND with TLC and QLC has brought down the cost... |
It may be a bit later than originally planned, but Samsung's first consumer SSD to support PCIe 4.0 is here. The Samsung 980 PRO was first previewed at CES... |
Western Digital recently unveiled their first energy-assisted magnetic recording (EAMR) HDDs for the retail channel. Today, the company is taking advantage of the same hardware platform with some tweaks... |
Business Intelligence Architect, Analysis Services... |
Performance Tuning SQL Server |
Mostoftentimes There is a good solution to alleviating parameter sniffing. Ones I commonly use are: Temp tables Changing indexes Dynamic SQL There isn’t really a good place to put a temp table in this... |
Today was kind of a rough day. It started with a... |
Pick A Database, Any Database Alright, maybe not any database. Let’s stick with SQL Server. That’s the devil we know. At some point in your life, you’re going to construct a... |
In environments where complex queries can get bad plans due to parameter sniffing, it would help to say that all queries with an estimated cost over X should be... |
If wait stats were celebrities, then CXPACKET would be a superstar, showing up in a gauche limo and getting swarmed by nerdy fans asking for an autograph. It would... |
PowerPivot/PowerQuery/PowerBI |
Some don't realize that Power BI Publish to Web is... |
While I was preparing to work in the new (for me) ... |
Speed up Power BI report load times by reducing th... |
Your Power BI report could be slow and not functio... |
Product Reviews and Articles |
I was contacted by Stellar Info quite a while ago.... |
You are invited to discover features of SQL Prompt... |
When database development is described, the detail... |
SQL Compare has a simple premise: it will compare ... |
SQL Compare has a simple premise: it will compare two databases, a source, and a target, and generate a script that, when executed on the target, will make its... |
Product Upgrades and Releases |
Microsoft R Open 4.0.2 has been released, combining the latest R language engine with multi-processor performance and tools for managing R packages reproducibly. You can download Microsoft R Open... |
SQL Server Security and Auditing |
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can... The... |
Zerologon vulnerability lets hackers access network crown jewels almost instantly. |
Amazon drivers — all gig workers who don’t work for the company — are hanging cell phones in trees near Amazon delivery stations, fooling the system into thinking that... |
A Dusseldorf woman died when a ransomware attack against a hospital forced her to be taken to a different hospital in another city. I think this is the first documented... |
eWEEK DATA POINTS: Cybercriminals thrive on--and use to their advantage--their victims' lack of preparation or overconfidence in what was deployed. |
So you want to build a recommendation engine? Whether it is for suggesting videos or developing the latest dating app, recommenders have become a powerful tool for many organizations.... |
I was in a need of converting some datetime values... |
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the... |
Total: 3 Average: 5 The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and performance. Additionally,... |
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got some data recently from an online... The... |
Tesla’s big “battery day” event, explained. |
Gaze upon it, but don't expect answers to your questions. Yet. |
“If God wanted man to become a spacefaring species, He would have given man a moon.” The famed rocket scientist Krafft Ehricke uttered those words in 1984. He wanted... |
The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions. |
Virtualization and Containers/Kubernetes |
The post Configure HyperV on windows 10 - Part 5 a... |
eWEEK DATA POINTS: While the Kubernetes development community has done a commendable job of providing clear and concise interfaces into Kubernetes, the integration of additional tools still requires deep... |
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. |
|
|