Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you shouldn’t feel like an imposter when you get out of your comfort zone. It talked about how incredibly successful people didn’t know how to do what they eventually accomplished back when they started. For example, … Read more
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.… Read more
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.… Read more
Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches up skills to job titles.… Read more
If you are lucky enough to enjoy the work you do, it could be because you are frequently “in the zone.” The zone is a state of complete concentration, also called “flow,” where time seems to stand still, and performance is at its peak. Before I heard these terms, I often experienced deep concentration while … Read more
Google Firebase is a PaaS offering for developing web and mobile apps. Amit Jambusaria explains the advantages and walks through a sample app.… Read more
You can use Unity’s Remote Config utility to update settings for users. Lance Talbert walks you through using the utility including a JSON example.… Read more
Why is it such a cliché to complain about our parents? You hear it from friends or in films all the time…”damn, I have to go to my folks for dinner. It’s gonna be rough.” It’s a tale as old as time. As our parents age (and retire), they inevitably participate in the world less. They interact with the world far … Read more
Machine learning projects often stall when it's time to deploy. Shree Das introduces Kubeflow for data scientists, an end-to-end solution for ML projects.… Read more
SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.… Read more
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
Every year, folks make resolutions and set goals for the new year. It would be interesting to have some real numbers comparing success in 2020 to a typical year, but I bet that many of us have failed or at least had to postpone plans and goals. I had no idea that my trip to … Read more
The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. Greg Larsen explains the details and how to configure the SQL Server error log.… Read more
Python has become a popular language because of it’s simplicity and vast library support. In this article, Julio Sampaio demonstrates how to get started creating Python apps in Visual Studio.… Read more
Organizations can take advantage of pre-built services to build their own software faster. In this article, Hitendra Patel demonstrates how an organization can provide authentication services for a web-based application.… Read more
This year has been difficult for most of us, and it’s almost over. The lives of people throughout the world have been turned upside down. Many of us, myself included, already worked remotely, but now face a multitude of new challenges. When confronted with the looming crisis in March, Redgate thought first about the safety … Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
