 | | The Complete Weekly Roundup of SQL Server News | | Hand-picked content to sharpen your professional edge |
|
Celebrate Success In addition to being a history nerd, I can be a bit of a current events junky. Because of this, I read a lot of news. Frankly, the “news” is bad. No, this isn’t a political statement in support of or against any individual or policy. I just mean that a very healthy chunk of the news is almost always very negative. This occurs despite the fact that there are extremely positive things going on in the world all the time. Scientific advances and individuals helping people just because they can, all sorts of things that just about anyone can agree is a net positive, yet they aren’t covered by the news. Same thing happens at work. Every time you have a failed restore, a unsuccessful deployment, or a failed data load, everyone knows about it. Meetings are scheduled to discuss what happened, who caused it, and, hopefully, a remediation course so it doesn’t happen anymore. There is a non-stop list of all the stuff that is bad. Granted, if we can’t restore our databases, this is something that needs to be fixed, without delay. However, in addition to that failed restore, not discussed was the successful one (or six). A big part of our job as technologists is to prevent bad things from happening, so we can focus a lot of attention there. However, to inspire us to more and better work, I’d argue a good and regular does of positivity is needed. Did your DR process work? Scream that from the mountain tops. WE ROCK! WE DID A GOOD JOB! List out how you saved the company money because your monitoring solution has enabled you to be proactive in disk management rather than reactive to the downtime caused by the lack of the same. Celebrate your successes as loudly, louder, than you trumpet your failures. You’re doing hard work, and doing it well, make darned sure your organization is aware of that fact. Focusing only on the negative aspects of your job (or life on this planet), can make work (and living) a pretty dark and depressing activity. While we have to address and deal with the bad things as they occur, focusing on and celebrating the positive things will make dealing with the negative things easier. 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 |
Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group. |
Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting. |
You can now write applications in C# or F# that take advantage of Apache Spark. In this article, Edward Elliott walks you through installing everything you need and creating your first Apache Spark app. |
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application. |
| AI/Machine Learning/Cognitive Services |
Machine learning is a skill that many data profess... |
I don't normally drop users and logins in producti... |
They immediately paid for Comprehensive Database P... |
Recently I was asked by the customer of Comprehens... |
A couple weeks ago I presented for the 24HOP Su... |
I'm not a regular user of Maintenance Plans for SQ... |
Welcome back to The Ironic DBA Files, a series whe... |
No, Not That Bug There’s a known bug with partit... |
This is an introductory article about automation i... |
At one of my customer sites, I recently started ha... |
Be sure to get the latest version of this script f... |
If you’ve read about the Accelerated Database Re... |
(Be sure to checkout the FREE SQLpassion Performan... |
Bench marking your environment is an important ste... |
Azure SQL Database originally started off with ver... |
| Computing in the Cloud (Azure, Google, AWS) |
helps you to move large amounts of data into or ou... |
| Conferences, Classes, Events, and Webinars |
As prep for our pre-con at the PASS Summit, Kendra... |
Date and time: Thursday October 10 16.00-17.00 BST/ 10.00-11.00 Central - Join Microsoft's DevOps Lead, Abel Wang and Microsoft MVP, Steve Jones to discover what is DevOps and the lessons Microsoft learned from their DevOps transformation. |
Date and time: Wednesday October 16 16.00-17.00 BST/ 10.00-11.00 Central - Microsoft MVP, Kendra Little will show you how Redgate tools enable you to speed up software delivery with reliable, repeatable processes that remove the database bottleneck. |
Date and time: Wednesday October 2 16.00-17.00 BST/ 10.00-11.00 Central. Join John Sterrett, CEO of Procure SQL, to learn the difference between Azure SQL Database, SQL Managed Instances, Elastic Pools, and SQL Virtual Machines. |
On Oct 5, 2019, a free day of SQL Server training in Memphis, TN, USA |
On Oct 5, 2019, a free day of SQL Server training in Pittsburgh, PA, USA. |
On Oct 5, 2019, a free day of SQL Server training in New York City, USA |
Come for a free day of learning in Bucuresti, Romania on October 5, 2019. |
Run whichever version of PowerShell Core from the ... |
| Data Mining / Data Analysis |
| Data Privacy, Compliance, and GDPR |
Microsoft is staffing up a new Data Dignity team i... |
Europeans have the right to be forgotten, but only... |
AT&T files motion to compel arbitration in cas... |
Click to learn more about video blogger Laura Kah... |
This is a keynote from the Strata Data Conference ... |
| Database Design, Theory and Development |
In Part 1 we showed that Codd intended in 1969 to ... |
| DevOps and Continuous Delivery (CI/CD) |
The tooling necessary to incorporate DevOps practi... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
In this post we saw how to create some graph table... |
‘Shortest path’ is by far the most feature of ... |
| ETL/SSIS/Azure Data Factory/Biml |
A few days ago, I (along with some smart people) w... |
Tim Mitchell takes us through term extraction in S... |
Data exploration is an essential piece of any new ... |
If you ever need to work with data involving dates... |
I’ve been asked from one of my friends who were ... |
Storage of five bits in every NAND cell is coming,... |
Having launched a variety of curved ultrawide disp... |
The delay on Ryzen 9 3950X's launch makes sense, g... |
While many gaming-branded components come adorned ... |
Microsoft has designated Windows 10 1903 ready for... |
Windows 10 is finally closing in on the 1 billion ... |
| Performance Tuning SQL Server |
First Time, Long Time I’ve written about all of ... |
Paul White on performance spools, and how they can... |
Harkening In dramatic fashion, I’m revisiting so... |
| PowerPivot/PowerQuery/PowerBI |
We often focus on deep analysis and insights gener... |
While it’s easy to make reports in Power BI, it ... |
Originally posted on: http://coolcat.de/darrengosb... |
Patrick shows how you can see query dependencies w... |
Patrick walks you through how to use custom format... |
Thanks for watching this week's Power BI news roun... |
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server. |
| Product Reviews and Articles |
Back in the article How Redgate Helped Define our ... |
This article explains the basic components of a te... |
| Product Upgrades and Releases |
Earlier today I had the opportunity to release the... |
This month’s release has a lot of new feature go... |
The NVIDIA-powered G4 instances that I promised yo... |
Click to learn more about author Rosaria Silipo. C... |
This series of videos spotlights a very powerful A... |
Are you interested in guest posting? Publish at Da... |
Are you interested in guest posting? Publish at Da... |
| SQL Server Security and Auditing |
At a project, we asked if we could get a SQL Serve... |
Intruders got access in May. DoorDash only found o... |
"Checkm8" exploit works on devices from iPhone 4s ... |
Demo of crypto-cracking algorithm fails to convinc... |
In a document published earlier this month (in Fre... |
This post describes some (more) advanced error han... |
I had a number of responses to my blog post about ... |
In this blog post, we will talk about Performance ... |
Question: Where is Table Variable Created? Answer:... |
I previously mentioned that SQL Server supports a ... |
Today we are going to discuss the performance comp... |
tl;dr; Add PRINT and/or SELECT statements. Comment... |
While the CROSS JOIN is not used much, and, depend... |
Ars takes Trek's latest electric bike for a spin a... |
There are two new options for automating your SQL ... |
| Virtualization and Containers/Kubernetes |
Click to learn more about author Jay Chapel. As we... |
  | 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. |
|
|
