Protecting Data Between Services
Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.
Service Broker Part 2: Why Service Broker
The second part of this series focuses on the advantages of Service Broker over other messaged-based technologies to introduce asynchronous message processing into your database applications.
Easing the transition from shared to dedicated database development
Working in a dedicated database model is the ideal. So, what does it take to move from shared development to a dedicated model? Infrastructure costs, merging multiple changes and maintaining an increased estate might be on your list of things to consider before committing to the switch. In this article we show how Redgate tools can ease the transition and new working approach.
SQL For Cosmos DB – Tips and Tricks
Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more...
The Evolving Skillset for Database Professionals
Aunt Kathi remembers all the SQL Server versions she has worked with over the years.
Group Islands of Contiguous Dates (SQL Spackle)
Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.
The Case for Considering Git
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
Safely Deleting Clones and Images during Database Development and Testing
Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time it takes to grab a coffee, after which can quickly deploy the new clones.
Security Considerations for ERP Applications
Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the security aspects of ERP systems and some of the techniques used to protect data.
Scary Data Collection
More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren't always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Alaydrus TLP/WA 08216977701
Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
BCA KCP Menteng TLP/WA ( 08216977701 )
Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCU PANGERAN JAYAKARTA TLP/WA (08216977701)
Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers