 | | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
Finding New Employment I have been working for Redgate Software for 15 years (14 as an FTE). I think this is the best job I've ever had, and I hope this is the last FTE job that I ever have (fingers crossed). Plenty of people have found new jobs during the pandemic, which surprised me. I thought many people would be careful and cautious, but the pandemic opened up remote work, new possibilities, and opportunities that didn't exist in the past. Both employers and organizations took advantage of the changes to better their situations. I know quite a few friends who found new positions, with better compensation, during the last two years. I think that trend continues as technology is an area that is adapts well to remote, hybrid, or in-person work. If you're looking for a job, or you need to hire some candidates, Brent Ozar put out a post that lets either side post a comment and let people know there are jobs and talented people available. I posted a note about Redgate in there, as we are looking for software developers in the UK. There are plenty of other positions. In Denver, I had lunch with a friend working at a new company, Sierra Space. They are growing and hiring quite a few people and they use SQL Server. My son works at ULA, and he said they need people as well. While some businesses struggled the last two years, it seems that many technology companies thrived and there are lots of opportunities out there. I am a big proponent of actively managing your career. I give talks on professional development and building your brand. My view is that you should work to improve your skills, showcase them, build a network of colleagues, and then find the dream job that fits you. That's different for all of us, but a little work and effort can help you find something you love. I'm approaching retirement in my 50s, and I love my job. Many of you are much younger and still building careers, learning what you like and don't like (which is more important). You're deciding what type of job you want and what interests you. Study, learn, come to SQL Saturdays (or ask your local group to run one), and pick the opportunity that works for you. Drive your career forward and I know you'll be as happy to go to work each day as I am. 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 |
It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations. |
| AI/Machine Learning/Cognitive Services |
n this fourth (and hopefully final) entry in my “Icing the Kicker” series of posts, I’m going to jump back to the first post where I used tidymodels to predict whether or not a kick attempt would be iced. However, this time I see if using the h2o AutoML feature and the SuperLearner package can improve the predictive performance of my initial model. |
Data management and security practices are changing rapidly as data becomes fully distributed and fully situated in the cloud today. Every organization is using hundreds of software-as-a-service (SaaS) apps—many... |
We hear a lot about responsible AI or AI ethics in the marketplace today. At SAS, we believe there should be a larger conversation about responsible innovation. In reality,... |
| Administration of SQL Server |
There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. |
As there was no owner, it was not possible to open... |
Imagine that we’re seeing very heavy load on our... |
SQL Server TDE on AWS RDS is similar to SQL Server... |
| Azure Databricks, Spark and Snowflake |
Databricks or Synapse seems to be the question on everyone’s lips, whether its people asking why you are using Databricks instead of Synapse Spark Pools or people asking what I should use and when, it’s definitely a hot topic right now. Given Microsoft are developing, investing, and recommending Synapse it is a reasonable question for everyone to be asking. |
Databricks or Synapse seems to be the question on ... |
Reading Time: 5 minutes In this post I want to ra... |
Today Data Exposed goes live at 12PM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming... |
| Azure SQL Managed Instance |
This is the third blog of a series focused on SQL ... |
The purpose of this series of articles is to describe some of the details of how High Availability works and how it is implemented in Azure SQL Managed Instance in both Service Tiers - General Purpose and Business Critical. |
| Career, Employment, and Certifications |
Can reskilling employees and financial planning so... |
Is your company hiring for a database position as ... |
This month for TSQL Tuesday I’d like to hear abo... |
Like lots of companies, Redgate has moved to a hybrid working model with some people working mainly from home and others now returning to the office a few days... |
| Computing in the Cloud (Azure, Google, AWS) |
ARM templates are widely used when we need to repeatedly deploy solutions/infrastructures in the cloud. Leveraging the concept of infrastructure as code ARM templates are a powerful resource to ease our daily job, however we might face some challenges when using them. |
The concept of a geo-replicated partnership betwee... |
Using cloud services provides various conveniences. One of which is the transparent auto-scaling of the infrastructure. Especially with the event-driven architecture approaches, we enjoy deeper sleep during the night while our app and the underlying platform flex their muscles to serve our customers. I bet you are implementing all the security measures that come to the top of your backlog |
For the longest time, we didn’t have one of the ... |
Reading Time: 5 minutes Building upon Azure Datab... |
Defining a Data Product Use the tag Data Mesh vs Azure to follow this blog series. I was recently asked by Data Mesh Radio host Scott Hirleman and several... |
| Conferences, Classes, Events, and Webinars |
Just because conferences and training events are cancelled this year doesn’t mean technology in the data platform will stand still. Connect with your peers and keep the #SQLFamily strong with a free two-day virtual conference, plus access to all previous sessions. |
This last 5th of May, my colleague Sabrin Alsahsah... |
Reading Time: 4 minutes In this post I want to an... |
Jacksonville's 14th Annual SQL Saturday event includes two paid pre-con tracks and one FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their skill set in Business Intelligence, Analytics, and SQL Server. |
I’ll be at VS Live this June to speak on a coupl... |
I’m delighted to announce I’m participating in a panel discussion about data warehouse modernization. The full title is “Data Warehouse Modernization – Crafting a Successful Migration Strategy Post Pandemic”.... The... |
Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization. |
Whatever your learning objectives or career goals are, Summit has the guided learning pathways you need to achieve them. Summit attendees can choose from 9 learning pathways, featuring over 40 industry-leading speakers, which have been designed to walk you through a specific set of learning outcomes to ensure that you leave Summit with the skills you need to make an immediate impact in your organization. Presenters include Ginger Grant, John Morehouse, Erin Stellato, Dustin Vannoy, and many more! |
Microsoft has a created a great Powershell extension for VS Code that makes it easy to work with Powershell files. Once the plugin is installed you get intellisense, syntax highlighting, and even visual debugging for files that have a Powershell extension. This debugger can be easily started by pressing F5 when you’re in a Powershell script. Stopping execution on a particular line is as easy as setting a breakpoint by clicking next to a line number. |
We just wrapped up the 2022 edition of the PowerSh... |
In this article we look at how to get started writing functions in PowerShell along with several basic examples to get you started. |
For Each loops let you perform an action against multiple items in PowerShell. Read these step-by-step instructions to learn how to use a For Each loop. |
Principal stratification was proposed in Frangakis... |
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.… The post Combinations, permutations, and derangements appeared first on Simple Talk. |
A few seats remain for our inaugural Craft the Narrative public workshop on May 11-12! If you want to break out of the “death by PowerPoint” spiral and... |
| ETL/SSIS/Azure Data Factory/Biml |
CSV data format is an old format and very common f... |
In this article we look at various ETL tools to he... |
Our picks for the best ultrabooks (super thin and ... |
Mushkin's 1TB Delta SSD leverages QLC flash, excha... |
Are you looking to build a PC but intimidated abou... |
The Key v2 is a triple-key macropad with RGB light... |
Seagate's special edition Star Wars HDDs have Boba... |
Lenovo's new premium clamshells are dubbed the Lenovo Slim series, including CPUs from Intel and AMD and GPUs from Intel and Nvidia. |
In this article we cover how and when to use the D... |
CONFIDENCE.NORM: Returns the confidence interval f... |
NORM.DIST: Returns the normal distribution for the specified mean and standard deviation. https://dax.guide/norm-dist/ NORM.INV: Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.... |
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server. |
Microsoft has announced some important changes regarding its Update Compliance... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL. |
| Performance Tuning SQL Server |
Used To Love Her I used to get so excited about l... |
When you see “index seek” on an execution plan, that doesn’t mean SQL Server is jumping to exactly the row you’re looking for. It only means that SQL Server... |
Questions, Arise! I think it was sometime in the last century that I mentioned I often recommend folks turn on Forced Parameterization in order to deal with poorly formed application... |
| PowerPivot/PowerQuery/PowerBI |
Most of you have probably run into a situation where someone in your organization has authored a report in the Power BI web service, and now they want to make changes that can only be done with Power BI Desktop. So, you try to download the PBIX file from the Power BI web service, only to discover that you can’t, because if it wasn’t created as a PBIX, it can’t be downloaded as a PBIX. Infuriating! |
In this article, we will learn how to report data ... |
DESCRIPTION Do you have a lot of reports but are still searching for answers? Do you really know what you are working toward? If so, we need to... |
Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How can they share a single dataflows in Power BI? |
Did you ever experience a long waiting time while ... |
A few months ago one of my colleagues at Microsoft... |
I wrote before about Automating table Refresh in P... |
This talk introduces Visual Studio Code as a simpl... |
This is video three in a four-part series walking ... |
Because Power BI is an easy-to-start platform and you don’t need an extensive learning curve to get started with Power BI Desktop, we often see some bad practices in... |
Reports are only as useful as they are easily understandable. When making reports for executives and other business leaders, it is vital to ensure the context and insights of... |
Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get... |
While there are settings that you can customize through the menu system in Power BI for a custom theme, one of the settings you cannot edit is to add... |
| Product Upgrades and Releases |
Introduction These are my SQL Server Diagnostic In... |
Label data with text classification using machine ... |
We are happy to announce that Azure SQL database,�... |
In this article we look at how to use Python to ge... |
You know that sinking feeling that you get when you’re months into a big project and you log in one day and nothing works? Turns out something has updated and things have been removed that you needed and now you need to spend hours-days figuring out what’s changed and your masters deadline is getting closer and … ok, apparently this took me back to a very specific event. |
I firmly believe that animation and transition between different data states can give end-users much better insights and understanding of the data, than a single table with data points or correlation metrics. |
When it comes to O(N log(N)) time complexity funct... |
The startsWith function comes with base R, and determines whether entries of an input start with a given prefix. (The endsWith function does the same thing but for suffixes.)... |
If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking... |
| SQL Server Security and Auditing |
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server. |
Researchers use code, Bitcoin transactions to link... |
The passwordless future just became closer to reality, as Microsoft, Apple, and Google pledge to make the standard possible across operating systems and browsers. |
QNAP and Synology say flaws in the Netatalk filese... |
The same infrastructure traced back to Russian-speaking threat group Nobelium is being used to set up misspelled domain names, presaging impersonation attacks bent on credential harvesting, analysts say. |
The infamous ransomware group appears to be back from the dead -- maybe -- and using the old brand, but experts question whether a reconstituted gang will have much... |
A company's response to a breach is more important than almost anything else. But what constitutes a "good" response following a security incident? (Part 2 of a series.) |
Microsoft has released a new update for its Authenticator app... |
Most companies are over-spending to meet cloud migration deadlines, and incurring technical debt in the process. What’s the impact of this down the line? |
| T-SQL and Query Languages |
Every now and then I run across a use case for the arcane NATURAL JOIN SQL operator, and I’m even more delighted when I can make that a NATURAL FULL JOIN |
Don’t Know Why Normally people handle errors to... |
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post I wrote about using... The... |
In this article we look at how to use the SQL MAX() function in SQL Server to find the maximum values in a result set along with several examples... |
I wrote about this trip for an editorial, and here... |
| Virtualization and Containers/Kubernetes |
Minikube, K3s, and MicroK8s all provide an easy way of running lightweight Kubernetes. Here's what sets them apart from each other. |
  | 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. |
|
|
