 | | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Shared Work Spaces: Hell, Heaven, Both? I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are all these strangers. Don't get me started on the open, shared work environment where you're just sitting with a bunch of people at long tables. Ugh! All that said, I've been at these places for meetings with co-workers. Many of whom, due to the, let's say, interesting last couple of years, I have never met. Further, some of them had never met each other. Just getting to see the people I depend on at work, talk with them, look them in the eye as we talk (and really in the eye, not looking either at my camera or at their face, online meetings are not the same, no matter what you say), are marvelous experiences. More than that, we get work done. Fast and efficient. Sure, the environment pings on my paranoid, introvert self in ways that are hard to describe. However, I can't deny that these shared work environments are essential tools in today's world. While I may not care for the concept, there's absolutely no denying the utility, at least from what I've seen so far. Have you used these? What do you think of them? Oh, I do like the fresh coffee that I don't have to make. That's very nice. 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 |
| IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes. |
| Administration of SQL Server |
| One of the new language features added in SQL Serv... |
| Learn about semantic search capabilities in SQL Se... |
| I love how Microsoft treats deprecated and discont... |
| In this tip, I show some real-life reasons why you... |
| Have you had an opportunity to play around with SQ... |
| … and you can install it, too! Visit Download SQ... |
| This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands. What is the xp_cmdshell stored procedure?... |
| Hey there! This post is the “Summary/Recap” fo... |
| I talk about a few of the things I worked on in my... |
| Azure Cosmos DB accounts can now take advantage of... |
| Azure Synapse (SQL Data Warehouse and Data Lake) |
| Trying to get started with a Modern Data Lakehouse... |
| Computing in the Cloud (Azure, Google, AWS) |
| This article explores the benefits of adopting a c... |
| This post is part of our Week in Review series. Ch... |
| The way the cloud platform works on Azure is very ... |
| Use the new Azure Data Studio MongoDB extension fo... |
| Generally available updates made in late June 2022... |
| Conferences, Classes, Events, and Webinars |
| Join Grant Fritchey to discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck. |
| When you need to create files and folders on a... |
| Our most-read PowerShell articles included instructions for encrypting scripts, initializing disks, and using If Else statements. |
| Data Mining / Data Analysis |
| Running a business is impossible without data. Dat... |
| Database Design, Theory and Development |
| If you can generate a quick Entity-Relationship diagram for any version of a database, you'll have a simple way to 'sanity check' it for unreferenced tables, missing keys and other design flaws. This article shows how to auto-generate these diagrams when running a migration, using Flyway Teams and PowerShell. |
| DevOps and Continuous Delivery (CI/CD) |
| (2022-Jun-20) As it takes a village to raise a ch... |
| In this article we cover what data pipelines are, how they compare to ETL and some of the tools that are available. |
| In this fourth session in our DevOps 101 series, w... |
| The SWITCH function in DAX has been optimized over... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| In this article, we are going to learn how we can ... |
| PowerPivot/PowerQuery/PowerBI |
| You have a cloud data source like Azure SQL Database. Why can't Power BI connect to it? They are both in the cloud! Adam shows you some things to... |
| During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example. |
| Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature. |
| As I’m sure a fair number of you already know I ... |
| Several factors have influenced my coding style over the years leaving me with a preference toward lean code syntax. I’ve been developing for quite a while, so it would... |
| In this article, I discuss several advantages to m... |
| When clients and consultants tackle MBI and MDP projects together, there can often be an assumed "one right way" to get the job done. This myopic focus on the... |
| How does the conversion between decimal to binary ... |
| SQL Server Security and Auditing |
| Create a self-signed certificate to use with SQL S... |
| When setting up encrypted connections - one of the... |
| Treat identity management as a first-priority prob... |
| A voicemail-themed phishing campaign is hitting sp... |
| The concept might make us sharp and realistic, but... |
| ShiftLeft's Manesh Gupta join Dark Reading's Terry... |
| T-SQL and Query Languages |
| Learn various ways to calculate the average of a s... |
| IndexOf First, I want to advise you to avoid doing things as much as possible like this in T-SQL. Use CLR, if you can. Or do it outside of your... |
| Transcription of Video: Here’s an example of a CTE that’s been created for data paging, where the select statement inside of the CTE that shown in blue is just... |
| Transcription of Video: Now on to CTE’s in stored procedures, functions and views. When I first started doing this presentation several years ago, people would ask, “oh, can the... |
| The role of sysadmin may not be going away anytime... |
| Perhaps it is more surprising that Microsoft has t... |
| Only about half of firms have an open source softw... |
| In 1930, the telegraph giant Western Union put the... |
| Microsoft Lists calendar view is getting better with conditional formatting... |
| This is today’s edition of The Download, our w... |
| The European Space Agency's Mars Express orbiter r... |
| Farmers are incorporating high-tech solutions like... |
| Virtualization and Containers/Kubernetes |
| Most people find setting up and managing Kubernetes to be difficult, but it doesn't have to be — if you follow these five best practices. |
  | This email has been sent to newsletter@newslettercollector.com. 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. |
|
|
