 | | The Complete Weekly Roundup of SQL Server News | | Hand-picked content to sharpen your professional edge |
|
| 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 |
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log. |
| AI/Machine Learning/Cognitive Services |
Who can use forecasting? The goal of forecasting,... |
| Analysis Services / BI on the MS Stack |
DAX.do is a new website by SQLBI where you can wri... |
| Azure Databricks, Spark and Snowflake |
Question: When an activity in a Data Factory pipel... |
For the past year Microsoft have said that Generat... |
You can see an announcement from Buck Woody (b | t) of Microsoft on Data Exposed. Essentially, Microsoft is providing a number of free resources to help local user... The... |
This is one way to create a polling loop in PowerS... |
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites. |
| Data Privacy, Compliance, and GDPR |
Citibank was trying to make $7.8M in interest paym... |
Virginia is about to get a data privacy law, model... |
| DevOps and Continuous Delivery (CI/CD) |
This is the fifth year that Redgate has surveyed I... |
Many organizations use out-of-date architecture pa... |
DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job. |
Last month we have been hiding things in Excel, so... |
| HA/DR/Always On/Clustering |
The attached PDF is the slide deck for my Introduction to Corruption presentation from Feb 17th 2021. I hope you enjoyed the session. The post Introduction to Corruption Slide Deck... |
As part of my job, I’ve been tasked with doing s... |
| Performance Tuning SQL Server |
Having up to date statistics is vital for getting ... |
When you are making changes to an existing Non-Clu... |
Milk Carton Part of reviewing any server necessarily includes reviewing indexes. When you’re working through things that matter, like unused indexes, duplicative indexes, heaps, etc. it’s pretty clear cut... |
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you... |
| PowerPivot/PowerQuery/PowerBI |
I have previously explained a number of use cases ... |
Do you have slowly changing dimensions in your Pow... |
Writing useless strings has been a focus of this series, and L-Systems (Lindenmayer Systems) are no different. It is a set or a string of characters that is rewritten... |
Guy Glanster explores the multiple behaviors of qu... |
As I have been building my Twitter management soft... |
This mission brings a lot of new hardware and scie... |
Chrome OS's rise in market share has been swift an... |
Back in our day, memes didn't benefit from central... |
  | 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. |
|
|
