Azure Data Factory Stored Procedure Activity Transformation Activities
In this post we will discuss Azure Data Factory transformation related pipeline activities using Stored Procedure activity.
Dealing with Server Objects, Settings and Features when Provisioning Databases
If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision.
A Clock With Benefits
Explaining how computers work can be hard for technical people, but it's important for us to help our clients, customers, and managers appreciate why building new software is hard.
Cross Database Queries in Azure SQL Database
Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.
Modeling Time
There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from storing and manipulating dates and time in SQL Server. In this article, Joe Celko discusses some of the many ways that SQL Server treats temporal data types.
Static Data and Database Builds
Whichever way you wish to ensure that a database, when built, has all the data that will enable it to function properly, there are reasonably simple ways of doing it. Phil Factor explains the alternatives.
Do you really know what’s happening with your servers?
As estates continue to grow and evolve, SQL Server professionals must continually adapt. But do you really know what’s happening with your servers? Jamie Wallis highlights the 4 key elements that are currently impacting the working life of an IT leader. Find out what they are here.
How to Enable SQL Server CLR Integration using T-SQL
In this tip we look at how to enable SQL Server Common Runtime Language aka CLR using T-SQL commands.
Data Challenges and Travel
A few problems in travel have Steve thinking about the complexities and challenges of companies that coordinate lots of data.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Percetakan NegaraHubungi: CS087781685567
WhatsApp 087781685567Jl. Percetakan Negara No.223 C, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah...
BCA KCP Setiabudi Atrium (??/Wa) 0821-8180-979
Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62 Lt.l Ruang 101...
BCA KCP Mangga Dua Square Hub/Wa 0838-3161-8849
WhatsApp:0838-3161-8849 Mangga Dua Square, Komp. Ruko, Jl. Gn. Sahari Blok G No. 8-9, Daerah...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers