| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Christmas in July My son asked me to sign for a package on Friday. He was at work and had ordered himself some new joystick for a gaming thing. He told me this was his "Christmas to himself in July." We've just past the halfway point of the year, and it's been interesting. Both a semi-stressful moving on from the pandemic, and a fantastic opening up of life for me in many ways. I've had some great trips, experiences, and enjoyed time with people. This is a time when many will treat themselves to a Christmas in July, perhaps with a gift or a trip that let's them enjoy life. I thought about that as I saw a few articles like this one on sales and deals. It's Independence Day on Monday, a holiday in the US, and lots of retailers use this as an excuse for a sale. I won't likely get anything techy, but I do need some new gloves since we are putting in 1000' of new fence at the ranch. If you've had a good year, is there something you'd reward yourself with? A new mobile device? Maybe some tech-game thing? An upgrade to hardware? Maybe you'll get a new car, like I did last year. Perhaps you'll take a trip or partake in some event. I guess I fall into that category as my wife and I have tickets to the jazz festival in Winter Park in a few weeks. We'll spend a weekend in the mountains as a reward for our hard work. If it's been a tough year, maybe there's something you treat yourself with to cope with this crazy world. Let us know what you will do, or maybe dream a bit and think about what you might wish you would do. Steve Jones - SSC Editor 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 |
| Watch this 30-minute training session to discover how you can use SQL Prompt in combination with other tools in SQL Toolbelt Essentials to boost productivity, simplify collaboration, and deliver accurate database changes faster. |
| Administration of SQL Server |
| After another Patch Tuesday™ has come and gone, I have seen more confusion about build numbers and what they mean. |
| MTLS is commonly found in a zero trust architectur... |
| In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage. |
| Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best... |
| I wrote about the Date_Bucket() funct... |
| Azure Databricks, Spark and Snowflake |
| We are excited to announce data cleanrooms for the Lakehouse, allowing businesses to easily collaborate with their customers and partners on any cloud in a privacy-safe way. Participants in the data cleanrooms can share and join their existing data, and run complex workloads in any language – Python, R, SQL, Java, and Scala – on the data while maintaining data privacy. |
| Issue: When connecting from inside Azure (an Azure... |
| Issue: SQL Server performance issue: possible high... |
| I wrote before about enforcing Azure SQL AD Authen... |
| In this episode of Data Exposed with Anna Hoffman and Ido Keshet, learn about how defender for SQL (and defender for cloud) can address the top security concerns. We’ll... |
| Azure SQL Managed Instance |
| Recently I have been working on some cases for stuck operations on Azure SQL managed instance. These operations can be such as an update backup storage redundancy or scale... |
| Career, Employment, and Certifications |
| Over the last four years, ok it seems longer than ... |
| Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting professional development and career ones in the queue, so I cherry-picked... |
| Yelp's CEO comes out strongly against hybrid work, as more workers continue to demand more flexibility. |
| Well, it’s only been about a week and a half but... |
| Recently PASS Data Community Summit sessions were selected and the wounds were opened on Twitter around speaker diversity in the community. I heard from several people via my DMs... The... |
| There’s some valuable discussion going on regarding diversity and conferences. I wrote about it last year. I’d like to write more of my thoughts on the subject, but so... |
| Computing in the Cloud (Azure, Google, AWS) |
| We used to have cases where our customer faced the following error message: "TCP Provider: The semaphore timeout period has expired" in this video below my colleague Dineu Assis... |
| Don't fall for these cloud pricing myths: Figuring out how much cloud computing will cost you is not as simple as it seems on the surface. |
| Conferences, Classes, Events, and Webinars |
| 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. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover the benefits of, and best practices for frequent deployments. |
| SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization. |
| A few years ago, we posted a question on this blog that is as relevant today as it was years ago: “Is there a good use case for a stacked bar chart?” |
| Database Design, Theory and Development |
| As I was troubleshooting a performance issue, I noticed that there was an implicit conversion (SQL Server automatically converts the data from one data type to another) happening in my join. The join was on a column that was named the same in both tables, but one was datatype INT (integer) and the other was a datatype of VARCHAR(50) (variable character up to 50 places). |
| We put the Patriot P400 SSD through our rigorous t... |
| Hewlett Packard Enterprise now offers 1P machines ... |
| The new 'Core i9-13900K ES3' chip increases the CP... |
| The SWITCH function in DAX has been optimized over... |
| Performance Tuning SQL Server |
| Errant Hairs I’ve used this proc as an example in the past. It’s a great parameter sniffing demo. Why is it great? Because there’s exactly one value in the Posts table... |
| In this article, we will learn various methods of how to get an SQL execution plan of a query. Introduction A SQL Execution plan is a very helpful query... |
| Locks in database can be either Read Lock or Write Lock. Locks are used when concurrent applications tries to access the same table. Locks prevents data from being corrupted or invalidated when multiple users try to reach while others write to database. |
| PowerPivot/PowerQuery/PowerBI |
| Every visual shown in a report in PBI, contains some form of aggregation. The question is how the aggregations are calculated and at which step in the pipe of bringing the data from the data source to the report. In this article, I’ll be using data coming from Azure Data Explorer aka Kusto aka ADX. |
| I recently got a new laptop and I had to install all my programs again. Everything was going as expected, except when I went to use ALM Toolkit, the program would not open. I would click on ALM Toolkit, I would see it open for a few seconds in task manager and then it would disappear. |
| In the early days of developing Power BI solutions... |
| Power Query Online is, as the name suggests, the o... |
| In this blog post we’ll explore how to trigger a... |
| In this article, we will learn how to use smart na... |
| In this article, we will use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well. Introduction Data volumes... |
| You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I... The... |
| Product Reviews and Articles |
| Flyway, especially Flyway Teams edition, can be us... |
| SQL Monitor has improved a lot over the last coupl... |
| Product Upgrades and Releases |
| Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can download the MPs from the links below. Majority of the changes are based... |
| Microsoft Purview data sharing for in-place data sharing for Azure Data Lake Storage (ADLS Gen2) and Azure Blob Storage is now in public preview. |
| The MATCH clause is used in the Azure Digital Twin... |
| Multi-user authorization for Backup provides enhanced protection for your backup data in recovery services vaults against unauthorized critical operations. |
| Query Store was first introduced in SQL Server 2016 and it is amazing how far it has come in such a short time. You can already use Management Studio and Azure Data Studio to get detailed resource consumption for all your queries, such as CPU, memory, and I/O, for Query Performance Insight to give you a quick and efficient way to determine impact. The automation and built-in knowledge that is used to make your job easier is impressive. |
| Restoring a backup file is the easiest way to copy... |
| I had the opportunity to do a presentation at work last week about SQL Server 2022. I titled it “Features in SQL Server 2022 We’re Looking Forward To”. I... |
| Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL Server 2022, now in public preview, is our most Azure-enabled release... |
| SQL Server Security and Auditing |
| I love database audits. They are simple, easy to u... |
| Andrew Appel has a long analysis of the Swiss online voting system. It’s a really good analysis of both the system and the official analyses. |
| Presently sponsored by: Detack. Detect & preve... |
| It didn't have to be this way: So far 2022's tranche of zero-days shows too many variants of previously patched security bugs, according Google Project Zero. |
| A new group of AI-assisted tools is emerging from GitHub and AWS to help developers more rapidly develop code. |
| T-SQL and Query Languages |
| Not sure what the different JOINs mean in Azure Sy... |
| Transcription of Video: So here’s an example of ... |
| Imagine that while developing or testing a SQL Server database, you get an error message mentioning a database object, and you scratch your head, and mutter ‘by the bones... |
| Transcription of Video: Let’s take a look at another recursive CTE. That’s not looking at tables, but it’s just looking at math. And here, we could create a recursive... |
| The path to data maturity begins with the realizat... |
| A Forrester Research analysis of the state of cloud in the U.S. found that 94% of organizations now use the cloud, though a number of challenges still remain. |
| Broadcom announced that it was planning to acquire VMware in... |
| Customized Xbox Series X has the looks, but probably not the power of Mjolnir. Xbox sweepstakes is open now until July 21. The movie is in cinemas starting July... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| We used to have cases where our customer asked wha... |
| Come learn seven quick tips that will make you a b... |
| 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. |
|
|
