Category: Microsoft SQL Server

Feed: Recent Announcements. Once you create tags for your RDS DB instances, you can separate RDS backup charges in AWS Cost Explorer according to the tags of the corresponding DB instances. When you view your Cost and Usage Report (CUR), you’ll find that the ResourceId for each RDS ChargedBackup line contains the name of the corresponding DB instance, and tags associated with the DB instance are marked in additional columns. Note that detailed backup charges have been activated as of October 8, 2019. Your RDS backup charges prior to this date will continue to show up as a single line ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Veronica Kupetz, Solution Architect; Veronica Kupetz, Solution Architect Change Data Capture (CDC) in Matillion is a great feature that will help keep your cloud data warehouse up to date with a source database (MySQL, PostgreSQL, Oracle, or Microsoft SQL Server). Setting it up is a fairly straightforward process. (This support article and our recent blog post about setting up CDC with an RDS MySQL source database are a few resources that can help.) But after you set up CDC, some questions may arise. A common question: How do we handle source data ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Veronica Kupetz, Solution Architect; Veronica Kupetz, Solution Architect Want to ensure that Amazon Redshift or Snowflake cloud data warehouse on AWS stays up to date with your source database? Change Data Capture (CDC) is your new best friend.  As we mentioned in our latest ebook, Accelerate Time to Insight, Matillion offers CDC functionality for AWS-hosted instances. CDC works directly with several AWS products: DMS, Lambda, SQS and S3. Setting up Change Data Capture takes a few steps. But once it’s ready to go, you no longer need to update with complex transformations, ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Julie Polito; In our latest ebook, Accelerate Time to Insight, we talk about the ways in which automating data transformation can help organizations maintain market leadership.  When it comes to staying ahead of the competition, insight is the new currency. And rapid time to insight is one of the biggest advantages and organization can have in today’s fast-paced business environment. Near-real-time insight is critical to providing exceptional customer experiences, streamlining operations, and fostering innovation. And ETL automation is one of the keys to helping you achieve that optimum speed and agility. ETL ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Visual Studio 2019 is a massive step forward in the developer spectrum. Not only has it shifted a lot of boundaries, but it has also made it easier to extend its interface.  In this article you will see tools – rather, extensions or add-ons - that can be added to the Visual Studio 2019 IDE to improve your database experience irrespective of what database it is. You should find these quite tools useful. MySQL Editor for Visual Studio Being a part time programming teacher, I always try to have good samples for ... Read More

Feed: James Serra's Blog. Author: James Serra. With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I access data in ADLS Gen2 instead of a copy of the data in another product (i.e. Azure SQL Data Warehouse)?”. The benefits of accessing ADLS Gen2 directly is less ETL, less cost, to see if the data in the data lake has value before making it part of ETL, for a one-time report, for a data scientist who wants to use the data to ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . SQL Server Integration Services (SSIS) was first made available well over a decade ago as part of the release of SQL Server 2005, replacing Data Transformation Services, which had been integrated into the product since SQL Server 7.0. This enduring pedigree has been interrupted by the introduction of Azure SQL Database, which, unlike its on-premises counterparts, restricted its capabilities to those implemented directly by the database engine. Unfortunately this meant that existing SSIS packages could not be used to perform extraction, transformation, and loading (ETL) tasks by relying on computing and storage ... Read More

Feed: Logicworks. Author: Lindsay Syhakhom; A staggering eighty-one percent (81%) of data breaches involve stolen or weak credentials. While two-factor authentication is now a foundational part of any identity security initiative, hackers are increasingly bypassing two-factor authentication methods.  Recently, a leader in identity governance and access management software came up with a new approach to help companies stay one step ahead of hackers in preventing unauthorized access. Their approach analyzes multiple factors of the authentication request so that two-factor authentication is only required if risks are detected. This process is called adaptive authentication or risk-based authentication and improves security while ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . If you have been a DBA for a while you have probably gone through at least one migration to a new version of SQL Server, or maybe even more than one migration.  One of the pains you might have discovered is migrating all the logins and associated permissions from one instance of SQL Server to another. Microsoft has made it fairly easy to script out the logins by using the sp_help_revlogin stored procedure. Only problem with this stored procedure is it doesn’t generate the permissions associated with each login. If you want ... Read More

Feed: Mr. Fox SQL. [read this post on Mr. Fox SQL blog] A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was my first keynote, so honestly I wasn’t quite sure what to talk about. Now I’ve been to many seminars, conferences, etc and seen many, many key notes – and so in the end I decided to have a bit of “light-hearted” fun and simply tell a story! So I decided to talk about SQL Server – yes, I know its exciting – but moreso about how it ... Read More