| The Complete Weekly Roundup of SQL Server News | Hand-picked content to sharpen your professional edge |
| Be Professional There are a lot of challenges in our current situation. Most of us reading this are likely stuck at home, dealing with the challenges there. Some of us reading this may be going through the insanely tough challenge of looking for employment. There also are likely some of us with health issues or dealing with the health issues of those around us. Through it all, there’s a relatively high likelihood that you’re on social media of one form or another, trying to connect with your co-workers, family, friends and acquaintances. The one piece of advice I can offer you that applies any time, but doubles in importance during our current situation, is that you act, communicate, and be, professional. There can be a lot of baggage associate with the idea of professionalism. Is it about simple competency? Punctuality? Responsibility? Sure, it’s all those. In order to be professional, you must strive for a level of competency. You also have to show up on time, deliver on the things for which you’re responsible, and generally get your work done. That’s all taken for granted. However, there is more to it. A professional is also able to deal well with others. The easy part is communicating your work and your responsibilities to your teammates and others. The hard part is dealing with adversity. In adversity the professional shines. They listen to others respectfully and actively. The professional doesn’t lash out and get emotional if confronted. The professional largely treats others as they would like to be treated. All this is more important than ever on social media because that public post, that’s forever. Future customers, clients, co-workers and friends can find that moment when you decided that a sick burn or a hot take or an ad hominem rant was more important than being a professional. The best way to be professional is to act professional. That’s been true in the past and it will be true in the future. Keep it in mind as you engage with others on social media today. 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 |
The State of Database Monitoring survey is open. How are you currently monitoring your database estate? Are you working cross-platform? Tell us your opinions in our annual survey on the State of Database Monitoring for your chance to win a $500 Amazon voucher. Take the survey. |
About eight years ago, I wrote a (kind of long) an... |
I recommend leaving the hyper-threaded logical cor... |
You may run into some trouble with sp_execute_external_script and R when you pass in CHAR and/or VARCHAR "string" data as part of your input data set. Here is an... |
In the previous entry in this series, I implemented Environment Variables that will let me have one code base that can easily generate jobs in DEV, PROD, or whatever... |
Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session. The post Removing the default trace – Part 2 appeared... |
Ok, so Azure SQL doesn’t really have its own err... |
Career Growth and Certifications |
It’s time for my annual update on the wild ride. If you want to catch up, check out past posts in the Brent Ozar Unlimited tag. This post covers... |
Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals,... |
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of... The... |
Community Interests and PASS |
I’ve gathered a bunch of notes from conversation... |
Covid-19 has taken a toll on communities across the globe, impacting lives in unprecedented ways. The stresses and strain of course vary depending on your situation, but there’s one... |
Computing in the Cloud (Azure, Google, AWS) |
Sometimes in life you have to do things you really... |
In our earliest post, we have discussed in detail ... |
Conferences, Classes, Events, and Webinars |
I’m doing a webinar next week, on Wednesday, Apr... |
Date and time: Wednesday April 15, 4-4.30pm BST / 10-10.30am CDT - Frequent deployments can give you greater flexibility in meeting changing business requirements, but if code quality is poor this may cause major headaches for your customers and your whole organization. In this 30-minute webinar, Steve Jones will share how you can achieve frequent deployments without constantly needing to hotfix your production system. Can't join us live? register to receive the recording. |
Date and time: Thursday April 23, 4-5pm BST / 10-11am CDT - Microsoft's Principal Cloud Advocate & DevOps Lead, Abel Wang joins Redgate's Steve Jones to discuss what DevOps really is, and how it can enable you and your organization to adapt. Can't join us live? register to receive the recording. |
Date and time: Wednesday April 29, 4-5pm BST / 10-11am CDT - Join Microsoft Data Platform MVP Grant Fritchey to discover not only know why you should be using Extended Events, but also how to get going in Extended Events the easy way. Can't join us live? register to receive the recording. |
I will be presenting a session to the Adelaide SQL Server User Group on April 15th, 2020, and if you’re awake at that time (it’ll be 9pm on April... The... |
The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one ... Continue reading The post #PowershellBasics: Using environment variables ($env:ProgramFiles)... |
There have always been a few options for running background asynchronous tasks within PowerShell. Traditionally, PowerShell (PS) Jobs was the go to method as a job could be started... |
This article is part of our back-to-basics blog se... |
DevOps and Continuous Delivery (CI/CD) |
In this article, Grant Fritchey explains how leavi... |
ETL/SSIS/Azure Data Factory/Biml |
This open source code project delivers a simple metadata driven processing framework for Azure Data Factory (ADF). The framework is delivered by coupling ADF with an Azure SQL Database that houses execution stage and pipeline information that is later called using an Azure Functions App. |
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,... The... |
(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform) incoming JSON data for further processing. Recently I've found a very simple but very effective... The... |
HA/DR/Always On/Clustering |
What's This about I figured I'd go ahead and take this article which I've gutted several times and share some thoughts, even if it's not an authority on the topic.... |
SK Hynix today announced that they’ve begun sampling of its first ever PCIe 4.0 enterprise SSDs in the form of the new 96-layer 3D-NAND U.2/U.3 form-factor PE8010 and PE8030... |
In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.… The post Storage 101: Data Center Storage Configurations appeared first... |
Microsoft is continuing to make adjustments to various Microsoft 365/Office 365 services with the aim of providing continuity during the coronavirus pandemic. |
Microsoft is not planning to have an in-person event until after July of FY2021 concludes and is re-thinking its entire conference strategy. The post Microsoft’s Conference Strategy Reboot appeared... |
Click to learn more about author Niels Brinch Experts in relational database structure may find it very confusing to structure data in a document database. However, there are actually... |
Performance Tuning SQL Server |
“Common” Is Not A Compliment … |
When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users... |
*clinks glass* This post will have links to all the demo videos for my presentation, The SQL Server Performance Tasting menu. Since the demos change over time with whatever I... |
PowerPivot/PowerQuery/PowerBI |
For a new series of posts to include tutorials and "how to" demonstrations for Power BI, SQL Server Reporting Services (SSRS) and Paginated Reports, I need your help... |
Row -Level Security or managing roles in Power BI is not something new. But environments, where there is a need for securing read access for end-users based on their... |
By Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time... |
One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the... |
Product Reviews and Articles |
When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including... The... |
In my previous article, How to design an automated database deployment process, I wrote about the steps companies and organizations should take to introduce automation to their database deployments.... |
Product Upgrades and Releases |
I wrote yesterday about the issues with SSMS 18.5 ... |
SQL Server Security and Auditing |
I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading The post Has this login been used... |
Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I... The... |
Blacked-out text is readable, revealing 952,000 po... |
Attack matrix for Kubernetes, using the MITRE ATT&... |
Three weeks ago (could it possibly be that long already?), I wrote about the increased risks of working remotely during the COVID-19 pandemic. One, employees are working from their... |
RSA-250 has been factored. This computation was performed with the Number Field Sieve algorithm, using the open-source CADO-NFS software. The total computation time was roughly 2700 core-years, using Intel... |
Fingerprint-based authentication is fine for most people, but it's hardly foolproof. |
Company is playing catch-up as pandemic magnifies every flaw. |
Microsoft announces support for protection against Return-Oriented Programming based control flow attacks in Windows 10 Insider builds on the Fast Ring. The post Hardware-Enforced Stack Protection Preview Arrives For Windows... |
The SQL MERGE statement is a device whose mystery ... |
Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL. The post Fundamentals of table expressions, Part 1 appeared first on SQLPerformance.com. |
FOR JSON lets you return the data in JSON format. As you might know, SQL Server can return and query JSON documents, but It doesn't have a... |
The datetimeoffset data type was added in SQL Server 2012 and allowed us to not only store date and time values, but to also store a time zone offset... |
Lab director: Hospitals are “astonishingly unpre... |
In this article, we’ll review the types of unit testing dependencies. This is more of a reference article, to which I’ll be referring in future posts. Still, this topic... |
I started this on Facebook, privately with friends... |
Books are only available to patrons of participati... |
The accuracy required is a measure of how unstable and difficult a juggling pattern is. |
The awards were supposed to be announced at the NY International Auto Show. |
Virtualization and Containers/Kubernetes |
One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up... The... |
At work we are seeing a burgeoning demand for Kubernetes test and development environment, as such we have been looking at simple and rapid ways to provision clusters. I... |
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. |
|
|