A Fine Slice Of SQL Server
Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fabric capacity licenses, it just makes sense to do that migration because Dataflow Gen2 gives you data destinations into four destinations, which we don’t have in Dataflow Gen1. However, converting Gen1 to Gen2 isn’t that complicated. The process is explained in this blog and video.
Click through for the blog post and the video.
Comments closedDavid Fowler backs up a database:
Way back in the mists of time I wrote a post on how to backup SQL server to an S3 bucket using TNTDrive, https://sqlundercover.com/2018/06/18/backup-your-on-premise-sql-server-directly-to-an-aws-s3-bucket/.
Back then, if we wanted to backup SQL to S3 we needed to use a third party tool. Since SQL 2022 things have changed and we’ve now got the option to backup directly to S3 in a similar way that we can backup to Azure BLOB store.
And, going one step further, you can also use PolyBase to read data from S3 buckets in SQL Server 2022.
Comments closedThe short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 in 10 SQL Servers is finally running the latest version.
The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the summer 2024 version of our SQL ConstantCare® population report.
As always, this is my reminder that we’re looking at a particular sample of the SQL Server population—users of Brent’s service—and will likely have some skew. That said, even within the context of this population, it is interesting to see these trends over time, and Brent covers that in the post.
Comments closedJosep Prat announces a slew of changes:
We are proud to announce the release of Apache Kafka 3.8.0. This release contains many new features and improvements. This blog post will highlight some of the more prominent features. For a full list of changes, be sure to check the release notes.
See the Upgrading to 3.8.0 from any version 0.8.x through 3.7.x section in the documentation for the list of notable changes and detailed upgrade steps.
This also puts Kafka one step closer to getting rid of its ZooKeeper dependency altogether.
Comments closedTom Collins breaks the bad news:
Question: Is it possible to restore a higher version of SQL Server to a lower version though a .bak file?
Answer: SQL Server doesn’t support restores from a higher version to a lower version using .bak backup & restore method.
Click through for a demonstration of fact.
Comments closedHey SQL Tools fans! We’re halfway through 2024 and due to a confluence of events we have a release of SQL Server Management Studio to announce, version SSMS 20.2.
While we’ve been focused on work for SSMS 21, we made time for a few updates to address known issues that affected your workflows and use of SSMS. You can read about each update and fix in the release notes, but let’s cover some important fixes here.
Read on to see what’s new in 20.2, as well as some of the major plans in mind for SSMS 21.
Comments closedRandolph West turns back the clock:
Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported version of SQL Server (preferably SQL Server 2022). How do I do that?
Read on for Randolph’s answer on how to do this. Pre-2008, things may get a little shaky, as that’s back when Microsoft really deprecated functionality. So even if you do restore a backup using this technique, I do wonder what happens if you were using a deprecated datatype like NTEXT or TIMESTAMP. As of SQL Server 2022, those are still in the product, so I don’t have a good example so much as a bit of niggling paranoia.
Comments closedSimon Liew shows off a change in SQL Server 2022:
Tempdb often acts as a high-traffic repository in SQL Server, experiencing significant contention. This includes not only temp table usage but also processes such as triggers, worktables for storing intermediate results for spools, cursors, sorts, work files for hash join, and temporary large object (LOB) storage, just to name a few.
A prominent issue is Global Allocation Map (GAM) and Shared Global Allocation Map (SGAM) system page latch contention, which can be particularly problematic under specific high concurrency workloads.
Read on for a demonstration of this.
Comments closedAndy Leonard fills us in on what’s happening in the world of Integration Services:
I’m not sure why the decision was made to “fork” development and maintenance of the Integration Services extension for Visual Studio 2022. Based upon experience with SSIS, Visual Studio, and the Microsoft SSIS team, I am confident there’s a very good reason. As one can glean from my appointment screenshot above, I save the links to both pages. The links are:
SSIS Pre-2022: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&ssr=false#overview
SSIS 2022: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices
Read on to see what’s new in both of those projects.
Comments closedAh, SQL 2022, the release that finally brought box SQL and Azure managed instance closer together. We have wonderful toys such as Managed Instance Link, allowing us to connect our SQL 2022 on prem instances with Managed Instance Link. It waslike the first real effort to integrate modern Azure offerings with those who also need / prefer an On Prem presence.
Rob Litjens has a follow-up on this:
I prepared some questions:
- What polices does Managed Instance have?
- Why did Microsoft implement the ‘Always-up-to-date update policy’ Policy?
- Why is it named Policy?
- Do we need to update our Azure scripts to implement it (immediately)?
- Is there impact on offerings like Managed Instance Link
Do read both of these as they combine for a rounded perspective of the issue Rod brought up.
Comments closed