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
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
alamat kantor BCA KCU KUNINGAN Tlp|Cs:0817825533
WhatsApp: 0817825533, Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Ground Floor,...
BCA KCP Banjarnegara No.Telp:087757645171
Whatsapp:087757645171 Jl. Pemuda No.72, Krandegan, Kec. Banjarnegara, Kab. Banjarnegara, Jawa Tengah 53414
Cara mengatasi lupa username bank bws CS.Tlp/Wa 0811•700•4141
10.District 8 SCBD, Treasury Tower 26th & 27th Floor, Jl. Jend. Sudirman kav 52-53...
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