| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Where the World Takes You We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about the preceding year. Yeah, it had its challenges. Nah, I'm thinking a bit broader. I just think it's interesting where our life choices take us. In 2005, I was bummed because, at my very first PASS Summit, I couldn't get into the SQL Server Central party because I didn't register ahead of time. Today, I'm putting together this editorial which I'm going to attach to the Database Weekly mailing, all with admin privileges on SQL Server Central. Now that, my friends, is a journey. It's all about the choices we make. I never, in any way, set out to be an admin on SQL Server Central. It's the result of a number of other choices, where I did, with intent, try to make certain things happen. For example, I got my job at Redgate because I went to them and asked for it. The results are what we're looking at today. You may set out with one goal, and achieve, other, equally good things. Just make sure you're striving towards something. Anyone else found themselves in places they would never have expected? 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 |
| Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here! |
| Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers. |
| AI/Machine Learning/Cognitive Services |
| The future of cities will center around mobility, ... |
| Remember the days when we used to stand in a queue... |
| Organizations are at a pinnacle time to address how to leverage intelligent technologies. As a part of their modernization strategies, AI can help companies keep up with changing expectations... |
| Administration of SQL Server |
| Learn about the more useful and helpful truncation... |
| I was helping out with a SQL Server upgrade recent... |
| SQL Server provides two ways to include an increme... |
| Microsoft has announced that the next version of S... |
| Managing permissions is a constant issue for Datab... |
| Analysis Services / BI on the MS Stack |
| So you want to add a sparkline in a Power BI report and wonder how to do it. Fortunately, the Power BI team recently added that functionality, and it... |
| In this article, we will learn how to perform a po... |
| Azure SQL Managed Instance |
| In the previous blog posts in the SQL MI How-Tos w... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| In this article we look at how to handle missing d... |
| Computing in the Cloud (Azure, Google, AWS) |
| There’s no doubt that the Internet can be a grea... |
| There are times when it is better to deploy cloud-... |
| In this article we look at different parameters an... |
| In this article we look at how to install SQL Serv... |
| Data Mining / Data Analysis |
| I’ve just started a new blog, Mathematical Odds ... |
| Ashley Kramer, Chief Product and Marketing Officer... |
| Since the onset of the pandemic, when the world plunged into a state of suspended animation, “touchless business” has become more than a boardroom buzzword, a survival mechanism. Customer... |
| Database Design, Theory and Development |
| Continuing on with our series from last time – s... |
| Going lean is all about the elimination of waste and risk. In the manufacturing world, lean methods focused on delivering a high-quality product to the customer. In the data... |
| Data Mesh vs Azure –Theory vs practice Use the tag Data Mesh vs Azure to follow this blog series. As a reminder, the four data mesh principals: domain-oriented decentralised... |
| DevOps and Continuous Delivery (CI/CD) |
| While NoOps will never fully arrive, IT teams cont... |
| Phil Factor offers a programmer's guide to the Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to... |
| ETL/SSIS/Azure Data Factory/Biml |
| I’ve been working on a project to populate an Op... |
| SSIS Azure Feature Pack and the Flexible File comp... |
| LN: Returns the natural logarithm of a number. https://dax.guide/ln/ LOG: Returns the logarithm of a number to the base you specify. https://dax.guide/log/ LOG10: Returns the base-10 logarithm of a... |
| Start reusing tiles and dashboards through the new... |
| Semantic Search, a feature of Azure Cognitive Sear... |
| We are excited to announce the preview release of ... |
| Performance Tuning SQL Server |
| Strictly speaking, a recompile isn’t really a pe... |
| See one way to use a queue table to spread out spi... |
| Fledgling Like many things, applications tend to ... |
| In this series of articles, we will learn how to convert the disk-based table to an in-memory table of SQL Database. This article is the first article of the... |
| PowerPivot/PowerQuery/PowerBI |
| As a Power BI administrator you want to see what?... |
| In this article we look at how to concatenate data... |
| Are you wanting to use streaming data? Patrick loo... |
| DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports. |
| Product Reviews and Articles |
| This book aims to introduce Azure SQL managed databases, how does it fare? |
| One of my favorite activities is teaching. I love ... |
| With October 2021 version of R Studio (2021.09.1 P... |
| Playing a simple guessing game with R. It’s called Mastermind game! This game was originally created for two people, but R version will be for single-player mode, when an... |
| In this article we look at how to create a User De... |
| DuckDuckGo has had a banner year: And yet, DuckDuckGo. The privacy-oriented search engine netted more than 35 billion search queries in 2021, a 46.4% jump over 2020 (23.6 billion). That’s... |
| Cloud security professionals are already in short ... |
| Learn how Active Directory makes it easier for IT ... |
| Attackers use the comment feature in Google Docs t... |
| The 2021 Strategic Security Survey highlights conc... |
| Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL. |
| In 2022, the burdens of enterprise data management... |
| Any time we stare into the crystal ball and try to... |
| Before reality, there’s simulation. A 2021 missile-inceptor test conducted by aerospace and US defense technology provider Raytheon Technologies held no surprises because the company had already tested almost every... |
| Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.… The post Crowdsourcing quality: Can the hive mind/herd mentality help... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| This is the fourth post in a series named One Way ... |
| This is the first post in a series named One Way t... |
| Virtualization and Containers/Kubernetes |
| In this article we look at how to setup SQL Server and Docker to run on a MacBook without the need for a Docker image that supports ARM64. |
| 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. |
|
|
